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

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!