943,865 Members | Top Members by Rank

Web Development > Databases > Database Design > Entity Relationship Diagram for a library-HELP NEEDED
Ad:
Permalink
Nov 29th, 2008
0

Entity Relationship Diagram for a library-HELP NEEDED

Expand Post »
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, 2015 views)
Reputation Points: 10
Solved Threads: 0
Newbie Poster
axxouk is offline Offline
3 posts
since Nov 2008
Permalink
Nov 30th, 2008
0

Re: Entity Relationship Diagram for a library-HELP NEEDED

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.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Permalink
Feb 27th, 2010
0
Re: Entity Relationship Diagram for a library-HELP NEEDED
hello

why u 're writing these attributes in loan entity:memId*, memId*, dateOut, dateDue, dateBack!!!!??

the relationship is that a Member will loan a Book
so the relationship N:M between,so u have to write the loan as an entity with both pk of the member and book as fk and the most important attributes which is included in loan relationship

so the loan entity will inculde:memId,isbn,dateOut, dateDue, dateBack...
Last edited by al3amer; Feb 27th, 2010 at 8:49 am.
Reputation Points: 4
Solved Threads: 1
Newbie Poster
al3amer is offline Offline
3 posts
since Mar 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: best frontend
Next Thread in Database Design Forum Timeline: sqlite questoin





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC