Re: Checking normalisation

From: Guillermo Andrés Labatte <labatteg_at_yahoo.com>
Date: Thu, 20 Feb 2003 11:06:10 -0300
Message-ID: <b32n0e$1gk2d6$1@ID-178082.news.dfncis.de>

Discussing normalization without mentioning the set of functional dependencies among attributes is meaningless.

For instance, if this functional dependence existed:

Postcode -> City

then Customer relation would not be in third normal form.

Dag2070 wrote:
> 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 - 08:06:10 CST