944,182 Members | Top Members by Rank

Ad:
Oct 15th, 2009
0

Help me please

Expand Post »
I request the assistance I work on the library database, But I have problem on the erd and relationship between entity ,if any one can help me I am grateful to him .
this my project if any one can add some entity and the erd please:
The system contains entities that act and participate with the system , these entities are :

Employee Entity : each employee has an ID, Name, DOB , Address , telephone # , and supervised by other employee. The employee deal with supplier who supply the books, and treat each order comes from customer

Book Entity : each book has an ID , Name , Author Name , Book Category , and Price of the book.

Customer Entity : each customer has an ID, Name, Address , Telephone # , the customer is person who borrowing books from the library .

Supplier Entity : each supplier has an ID , Name , Telephone # , Address , the supplier is supply the library with different category of books.

Order Entity : each order has an ID , order date , delivery date , ID for the employee , and the ID for the customer who borrowed the books , Quantity of the order .
Last edited by huss_584; Oct 15th, 2009 at 12:54 pm.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
huss_584 is offline Offline
7 posts
since Oct 2009
Oct 16th, 2009
0
Re: Help me please
well the first apparent error i see is the many to many relationship between the book and customer as one book can be loaned by many customer and a customer can loan many books, it is also not uncommon for a library to more than one copy of the same book, instead you should have a composite entity between customer and book entities and have a book_loan entity. also i hope you're not using the book's ISBN number as the primary that could be troublesome if you have more than one copy a book instead use a composite primary key (the ISBN and a surrogate key).
Last edited by baki100; Oct 16th, 2009 at 8:22 am.
Reputation Points: 12
Solved Threads: 14
Junior Poster in Training
baki100 is offline Offline
79 posts
since Apr 2009
Oct 16th, 2009
0
Re: Help me please
thank you for suggestion
please if you can see the diagram and modify it

im put it in attach file .
Attached Files
File Type: docx ERd.docx (80.7 KB, 13 views)
Reputation Points: 10
Solved Threads: 0
Newbie Poster
huss_584 is offline Offline
7 posts
since Oct 2009
Oct 16th, 2009
0
Re: Help me please
thank you for suggestion
im want to sent erd for to modify it if you can

thank you too much
Attached Files
File Type: docx ERd.docx (80.7 KB, 11 views)
Reputation Points: 10
Solved Threads: 0
Newbie Poster
huss_584 is offline Offline
7 posts
since Oct 2009
Oct 16th, 2009
0
Re: Help me please
yes im see
once more
Attached Thumbnails
Click image for larger version

Name:	untitled.JPG
Views:	14
Size:	46.2 KB
ID:	12153  
Reputation Points: 10
Solved Threads: 0
Newbie Poster
huss_584 is offline Offline
7 posts
since Oct 2009
Oct 16th, 2009
0
Re: Help me please
ouch you use chen model i'll have a look at it and try and make out heads or tails from that doc
Reputation Points: 12
Solved Threads: 14
Junior Poster in Training
baki100 is offline Offline
79 posts
since Apr 2009
Oct 16th, 2009
0
Re: Help me please
thank you very much
Reputation Points: 10
Solved Threads: 0
Newbie Poster
huss_584 is offline Offline
7 posts
since Oct 2009

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: Is this database structure correct? Please help
Next Thread in Database Design Forum Timeline: Basic DBMS Concept





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


Follow us on Twitter


© 2011 DaniWeb® LLC