If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Evaluate ER diagram

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-30-10, 20:22
wssrpnc wssrpnc is offline
Registered User
 
Join Date: Sep 2010
Posts: 1
Thumbs up Evaluate ER diagram

Hello, community!

I made an er-diagram of an online bookstore(you can see it here: bookstoreEnglishPic.jpg - 4shared.com - photo sharing - download image
)

Bussines rules are very simple:
customers can made many orders, Item(in fact-as mentioned above- is a item in bookshop, mainly books, but it also can be, cd, dvd, e-book, paperback... ), there should probably be also many to many between author and item, but thats not the point probably at the moment.

It's a fact, that im still a begginer in database design, so i joined the community to improve my understanding... I would appeciate any comments, ideas, improvements....

I went through normalization process, i think it should be everything in 3nf.
Maybe there is a problem with the customer payment method.. I dont know how to solve this.

So, thanks for checking, i think there is still much to improve. Any comment is a good comment. Would be gratefull, seeya
Reply With Quote
Reply

Tags
er diagram

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On