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)
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)