I'm sure this thread will get moved to the technology area but more people look here then there so that's why I posted here..
I am taking a database class, we are using access 2007.
I understand a little about normalization but an stumped on the assignment we have. We need to put this into 3NF.
I have three tables, tblCustomer, tblContract and tblInvoice.
the fields in each, are;
tblCustomer
customerID (Primary Key)
company
firstname
lastname
phone
address
city
state
zip
email
comments
tblContracts
contractNum (PK)
customerID (FK)
contractType
signingDate
startDate
tblInvoice
InvoiceNum (PK)
contractNum (FK)
invoiceDate
InvoiceItem
InvoiceAmt
InvoicePaid
I don't see any fields that don't seem to fit the table they are in...
what am I missing?
I am taking a database class, we are using access 2007.
I understand a little about normalization but an stumped on the assignment we have. We need to put this into 3NF.
I have three tables, tblCustomer, tblContract and tblInvoice.
the fields in each, are;
tblCustomer
customerID (Primary Key)
company
firstname
lastname
phone
address
city
state
zip
comments
tblContracts
contractNum (PK)
customerID (FK)
contractType
signingDate
startDate
tblInvoice
InvoiceNum (PK)
contractNum (FK)
invoiceDate
InvoiceItem
InvoiceAmt
InvoicePaid
I don't see any fields that don't seem to fit the table they are in...
what am I missing?
Last edited: