Help me please

Reply

Join Date: Oct 2009
Posts: 7
Reputation: huss_584 is an unknown quantity at this point 
Solved Threads: 0
huss_584 huss_584 is offline Offline
Newbie Poster

Help me please

 
0
  #1
Oct 15th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 56
Reputation: baki100 is an unknown quantity at this point 
Solved Threads: 11
baki100 baki100 is offline Offline
Junior Poster in Training
 
0
  #2
Oct 16th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 7
Reputation: huss_584 is an unknown quantity at this point 
Solved Threads: 0
huss_584 huss_584 is offline Offline
Newbie Poster
 
0
  #3
Oct 16th, 2009
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, 2 views)
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 7
Reputation: huss_584 is an unknown quantity at this point 
Solved Threads: 0
huss_584 huss_584 is offline Offline
Newbie Poster
 
0
  #4
Oct 16th, 2009
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, 1 views)
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 7
Reputation: huss_584 is an unknown quantity at this point 
Solved Threads: 0
huss_584 huss_584 is offline Offline
Newbie Poster
 
0
  #5
Oct 16th, 2009
yes im see
once more
Attached Thumbnails
untitled.JPG  
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 56
Reputation: baki100 is an unknown quantity at this point 
Solved Threads: 11
baki100 baki100 is offline Offline
Junior Poster in Training
 
0
  #6
Oct 16th, 2009
ouch you use chen model i'll have a look at it and try and make out heads or tails from that doc
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 7
Reputation: huss_584 is an unknown quantity at this point 
Solved Threads: 0
huss_584 huss_584 is offline Offline
Newbie Poster
 
0
  #7
Oct 16th, 2009
thank you very much
Reply With Quote Quick reply to this message  
Reply

Message:



Other Threads in the Database Design Forum


Views: 955 | Replies: 6
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