1. Normalize the following table. Show all work and clearly indicate the primary and foreign

keys.

R(elevator_no,building_no,building_name,capacity, staff_no, first_name, last_name, date_examined)

Functional Dependencies:

1. elevator_no-->building_no,capacity

2. building_no-->building_name

3. staff_no-->first_name,last_name

4. elevator_no,staff_no-->date_examined

Normalize table R up to BCNF. 2. Normalize the following table. Clearly indicate primary keys and foreign keys.

R(project_no, project_title, start_date, manager_no, manager_name, manager_salary, employee_no, employee_name, employee_salary, no_of_hours)

Functional Dependencies:

1. 1- project_no-->project_title, start_date, manager_no

2. 2- employee_no-->employee_name, employee_salary

3. 3- manager_no-->manager_name, manager_salary

4. 4- project_no, employee_no-->no_of_hours

Normalize table R up to BCNF.

3. Normalize table T given below up to 3NF (Third Normal Form). Show your steps and indicate primary and foreign keys clearly.

T (A, B, C, D, E, F, G)

Functional Dependencies:

1. C->D 2. D->E, F

4. Normalize table R given below up to BCNF (Boyce-Codd Normal Form). Show your steps and indicate primary and foreign keys clearly.

R (A, B, C, D, E, F)

Functional Dependencies:

1. A->C 2. C->D 3. E, F->B