For each of following relations with no repeating group, normalize to fifth normal form. Indicate primary key with a single underline, foreign key with a double underline and candidate key with a circle around it for the final set of normalized relations.

1. Contract (ConsultantID, ConsultantName, EmployeeID, ContractDescription, EmployeeName, ContractBudget, , ContractID)

Assumptions:

1. A consultant can work on more than one contract;
2. An employee can work on more than one contract; and
3. A contract can only have one employee and one consultant.

2. Instruction (InstructorID, StudentID, CourseID)

Assumptions:

1. A course can be given by many instructor;
2. A student can have more than one course;
3. A student always has the same instructor for the same course; and
4. An instructor only teach one specific course.

c. Sport (StudentID, StudentName, SportID, SportFee)

Assumptions:

1. A student can only play one sport; and
2. A sport has only one fee.

d. Account (AccountType, CustomerID, BankID)

Assumptions:

(1) A customer can have more than one bank;

(2) A customer can have more than one account type with a bank; and

(3) A bank can offer more than one account type.

5. Sales (UnitPrice, SalesAmount, SalesID, Quantity)

Assumption: Common Sense