Entity Relationship Diagram for a library-HELP NEEDED

Reply

Join Date: Nov 2008
Posts: 3
Reputation: axxouk is an unknown quantity at this point 
Solved Threads: 0
axxouk axxouk is offline Offline
Newbie Poster

Entity Relationship Diagram for a library-HELP NEEDED

 
0
  #1
Nov 29th, 2008
imaginary language into java. I have everything down except for the symbol table.

I am currently making ERD diagram for a library . The entities are below:

Entity Attributes
Member memId, memName, memAddress, memMaxbooks

Book isbn, bName, datePublished, pubId*, ageLower ageUpper, value

Copy cId, isbn*, dateAcquired, dateDestroyed

Loan memId*, memId*, dateOut, dateDue, dateBack

Publisher pubId, pubName, pubAddress

Author authorId, authorName

Authorship authorId*, isbn*





My ERD diagram is half finished and attached to this thread so please please please help me
Attached Files
File Type: doc ERD DIAGRAM).doc (34.5 KB, 176 views)
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 306
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 26
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: Entity Relationship Diagram for a library-HELP NEEDED

 
0
  #2
Nov 30th, 2008
I reviewed the document you attached; however, do you have any questions that you need answered? You mention that your ERD is half finished; are you unable to finish it and what do you need help with?

I see you have author, publisher and authorship listed as entities, but you don't have them in your diagram. Is that what you need help with? Do you need help with the loan entity? The loan entity would simply be located where the 'borrows' relationship is. Also, I believe the second Fk in the loan entity should be cID and not memID.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Database Design Forum


Views: 4609 | Replies: 1
Thread Tools Search this Thread



Tag cloud for Database Design
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC