Need help with my database assignment

[Mainframeguy]

BUMP ^^^ Just wondering - did you get my email? And did it help you....

 

[leedogg]

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.

I would set it up with something like:

customer table:
Customer ID + Customer data

Purchase table:
Purchase ID + Customer ID + Product ID + Purchase data


Complaint index:
Complaint ID + Purchase ID

Complaint table:
Complaint ID + Complaint data (including outcome)

Product table:
Product ID + Product data


Anyway thats my stab at it.