Checking normalisation
From: Dag2070 <member25280_at_dbforums.com>
Date: Thu, 20 Feb 2003 13:12:12 +0000
Message-ID: <2552896.1045746732_at_dbforums.com>
Date: Thu, 20 Feb 2003 13:12:12 +0000
Message-ID: <2552896.1045746732_at_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,
Level]
Normalisation has to be upto 3rd normal form
thanks in advance for any help
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
--
Posted via http://dbforums.com
Received on Thu Feb 20 2003 - 14:12:12 CET