Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 20th, 2003, 07:31 AM
DaG2070 DaG2070 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2003
Posts: 1 DaG2070 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
checking normalisation

the database is a college project for a warehouse business who sell many items. i am very new at normalisation, so i was wondering if someone can check and suggest any changes.

Customer [CustomerID, Customer Name, Business Name, Address1,
Address2, City, Postcode, Delivery Address1, Delivery
Address2, Delivery City, Delivery Postcode, Telephone]
Order Info [OrderID, CustomerID, Order Date, Delivered Date]
Order Items [OrderID, ItemID, Quantity, Selling Price]
Item [ItemID, Item Name, Description, Quantity, Actual Price, Stock
Level]

Normalisation has to be upto 3rd normal form
thanks in advance for any help

Reply With Quote
  #2  
Old February 20th, 2003, 10:35 PM
dkj083063 dkj083063 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2003
Posts: 4 dkj083063 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
You might consider adding an 'Address Type' field to your customers table. Then you could drop the additional 'delivery address' fields. Address types could be 'Contact, Delivery, Both' or something like that. For everyone that uses the same address for both purposes, you save space, plus your data will be easier to search and maintain. You would probably want to add a table to hold legit values for Address Type and establish referential integrity with your addresses table. This would allow your customer to have as many addresses / address types as they wanted.

As a practical matter, a lot places have more than one phone number too. Another table for phone numbers and types, maybe? If needed...

Other tables look pretty normal! Good luck.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > checking normalisation


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway