database - Databse 3rd Normal Form -

database - Databse 3rd Normal Form -

can create sure database in 3rd normal form, , if not why? need db have 3 tables. here is:

customer no. (pk) store no. (pk) sale no. (pk) name location client no. (fk) telephone revenue store no. (fk) address total purchases($) paid store no.

here 3 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) client no (fk) store no (fk) total paid_yes_no

if trying track partial payments, etc. through paid column, separate table (and much more complicated database). however, if paid column indicates whether bill has been paid or not, above should work.

perhaps need date field there well?

database forms normalization third-normal-form