Can somebody make sure my database is in the 3rd normal form, and if not, explain why not? I need the DB to only have 3 tables. So here it is:
Customer No. (PK) Store No. (PK) Sale No. (PK)
Name Location Customer No. (FK)
Telephone Revenue Store No. (FK)
Address Total
Purchases($) Paid
Store No.
Here are what your three tables should be: Table 1: Customer
Customer No. (PK)
Name
Telephone
Address
then Table 2: Store
Store no. (PK)
Location
then Table 3: Sale
Sale No. (PK)
Customer No (FK)
Store No (FK)
Total
Paid_yes_no
If you are trying to track partial payments, etc. through the Paid
column, then it would be a separate table (and a much more complicated database). However, if your Paid
column just indicates whether the bill has been paid or not, the above should work.
Perhaps you need a Date
field there as well?