Question: Please answer the question, thank you Answer the following questions based on the relational schema given below: MAINTENANCE (elevator_no, building_no, building_name, elevator_capacity, {staff_no, first_name, last_name,

Please answer the question, thank you
Answer the following questions based on the relational schema given below: MAINTENANCE (elevator_no, building_no, building_name, elevator_capacity, {staff_no, first_name, last_name, maintenance_date}). Notes: Capacity is the total weight an elevator can hold a) State the stage of normalization for the above relational schema and give TWO (2) reasons to justify the answer. (3 marks) b) Identify and list appropriate primary key(s). (2 marks) c) Identify and list the partial and transitive dependencies. (3 marks) d) Normalize the table into 3NF. Show all works for each normalization stage. (7 marks)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
