OK. Haven't had time to come on forum coz i had other assignments to do.
I only go up to 3NF on this database thing, nothing further than this.
Mainframe, Geffy. I see the following headings under four tables. I can get to 3NF for the first two, but have not included anything else from the other two. I know I'm missing something but not sure exactly what they are or where they go for that matter. Can you guide me please?
Remember these are only the headings in each table.
Table 1: Customer Details
>Customer Number
>Customer Name
>Address
>Customer Telephone
>Returning Customer? (Yes/No)
>Notes
Table 2: Purchases
>Product Code
>Product Name
>Product Type Code
>Product Type
Table 3: Complaint Record
>Customer Number
>Product Code
>Complaint
>Outcome
Table 4: Compatibility of Products and Outcome
>Product type
>Valid Outcomes.
Obviously there are repeating stuff here, but I'm more concerned about getting the 'Complaint' bit included in the Normalisation.
Thanks in advance for any help you can provide me.