| | |
Entity Relationship Diagram for a library-HELP NEEDED
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Nov 2008
Posts: 3
Reputation:
Solved Threads: 0
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
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
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.
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.
![]() |
Other Threads in the Database Design Forum
- Previous Thread: Fundamental Design problem (Weak entity)
- Next Thread: how 2 make normalization 4 this relationship?
| Thread Tools | Search this Thread |





