b_book1.gif (162 bytes)Info engineering | Database
Selecting

IE: Design. Normalisation Exercise1

 nex1-1

  1. Using the following Goods Inwards User View, prepare a normalised set of data to 3NF.

  2. Using your 3NF normalised data structures for the Kauri Furniture Company Invoice and Goods Inwards combine these two structures to produce ONE normalised set of Data structures for the Kauri Furniture Company.

Un-normalised form (User view).

Kauri Furniture Company
21 Cameron Road, Tauranga
Goods Inwards
   No:    12244
   Date: 10 February 1999
Product Number 13425
Description Bedside cabinet
Quantity Received 100
Unit of Sale Single
Unit Price 90.00
Suggested Retail Price 150.00
Supplier Number 322009
Supplier Name Bentwood Manufacturers

 

 Listed Data: (with initial type & notes)
Data item Type Notes
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     

 

Ack: K. Allpress Unitec99: [Rev 17/05/99] 16/5/99 ©1999 V/2-Com (Verhaart), Box 8415, Havelock North, New Zealand.