hi i'm an absolute fresher in DBMS and our teacher gave us an assignment in this there are two questions,
we have to draw the UML diagram,
find the association,
ER diagram,and then to write SQL queries
the problem is that i'm little bit confused about the attributes i think this is the first step so can u help me in making the UML diagram
as soon as possible
i have attached my views
thanks
mandy2612
0
Newbie Poster
Recommended Answers
Jump to PostStoreloan has 1:n relation with Video Iid
Storeloan has 1:n relation with Books via Iid
Storeloan has m:n relationship with Customers
By the way no one will do you assignment unless if you put some effort on it.
Jump to PostHey,
I've Attached The Relationship Diagram.
It Might Not Mean Very Much Without The Table Contents To Flesh It Out. But I'll Get To That Soon.
How Much Detail Do You Want To Go Into With The SQL. I'm Writing Stored Procedures & Functions To :
…
Jump to PostHey,
I've Attached The Reply.
What About The SQL ? Have You Got SQL Server Or Some Other RDMS To Play With ?
Jump to PostI've Attached The SQL & Explanation For Both Queries
I Hope This Helps.
Rob
All 19 Replies
ithelp
757
Posting Virtuoso
Banned
mandy2612
0
Newbie Poster
patrick18
0
Newbie Poster
mandy2612
0
Newbie Poster
patrick18
0
Newbie Poster
mandy2612
0
Newbie Poster
patrick18
0
Newbie Poster
patrick18
0
Newbie Poster
mandy2612
0
Newbie Poster
patrick18
0
Newbie Poster
patrick18
0
Newbie Poster
mandy2612
0
Newbie Poster
patrick18
0
Newbie Poster
SkinHead
2
Light Poster
mandy2612
0
Newbie Poster
mandy2612
0
Newbie Poster
SkinHead
2
Light Poster
mandy2612
0
Newbie Poster
SkinHead
2
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.