3303%20Relational%203NF%20example%203

3303%20Relational%203NF%20example%203 - Normalizing a...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Normalizing a Database example Original Worksheet invoice # date cust # Cust name Cust street Cust city Cust St Cust zip Item # Qty Descn Price Item # Qty Descn Price 2294 24-Dec 841 waren 1978 mich Chicago IL 23589 4733 10 paper 12.50 6211 50 pads 0.95 2295 25-Dec 256 usc trousdale LA CA 90089 8546 12 fax roll paper 3.00 4733 5 paper 12.50 2296 26-Dec 841 waren 1978 mich Chicago IL 23589 4733 10 paper 12.50 6211 50 pads 0.95 2297 27-Dec 256 usc trousdale LA CA 90089 8843 2 time cards 5.00 5302 5 invoice fo 8.00 2298 28-Dec 841 waren 1978 mich Chicago IL 23589 8546 12 fax roll paper 3.00 4733 10 paper 12.50 2299 29-Dec 256 usc trousdale LA CA 90089 6211 50 pads 0.95 8843 2 time cards 5.00 2300 30-Dec 841 waren 1978 mich Chicago IL 23589 5302 5 invoice forms 8.00 2301 31-Dec 256 usc trousdale LA CA 90089 8546 12 fax roll paper 3.00 2302 1-Jan 841 waren 1978 mich Chicago IL 23589 4733 5 paper 12.50 9 rows x 25 (or more) columns 225 or more cells 1NF - no repeating groups of fields-Primary key is composite of 2 fields: Invoice #, Item # (i.e. Invoice line) invoice # date cust # Cust name Cust street Cust city Cust St Cust zip Item # Qty Descn Price Extension 2294 24-Dec 841 waren 1978 mich Chicago IL 23589 4733 10 paper 12.50 125.00 2294 24-Dec 841 waren
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

3303%20Relational%203NF%20example%203 - Normalizing a...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online