Checking normalisation

From: Dag2070 <member25280_at_dbforums.com>
Date: Thu, 20 Feb 2003 13:12:12 +0000
Message-ID: <2552896.1045746732@dbforums.com>

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

--
Posted via http://dbforums.com

Received on Thu Feb 20 2003 - 07:12:12 CST