Help getting in 3NF

Intense_SS

New member
Local time
Today, 06:44
Joined
Sep 5, 2012
Messages
3
I thought I already had this in 3NF but was told that I may have a Primary Key consisting of one or more fields. What does that mean?
I was told to check my functional dependecies. Again a bit lost. Any help you could provide so I can get this database going would be greatly appreciated. Below is where I am at:

Problem #1:

Patient (Patient Num, Patient Name, Household Num, Balance)
Household (Household Num, Household Name)
Contact Information (Patient Num, Street, City, Zip, State)
Service (Service Code, Description, Fee, Date)

Problem #2:

Customer (CustomerNum, Last Name, First Name)
Part (PartNum, Description, ONHAND, CLASS, WAREHOUSE, PRICE)
Invoice (OrderNum, OrderDate, Number Ordered, Quoted Price)
Rep ( RepNum, Customer Name)
 
Are these your tables and their fields?

You have Patient with a Patient Num then a Contact Information with a Patient Num this may be it?

Also for your fields take the spaces out of them for best practice purposes.

We need more detail?
 
Yes these are my tables and fields.
 
And were do you get this error? We need more info?

What are you trying to do?
 
Problem one

patient/household/contact info - not sure why youve got these in different tables, they would be one to one relations and would serve no purpose really.
 

Users who are viewing this thread

Back
Top Bottom