Tutor HuntQuestions

Tutor Hunt Questions

Normalize the table into 3NF: Inspections (PropertyNo, Property_Address, Inspection_Date, Inspection_Time, Comments, StaffNo, Staff_Name)
4 years ago

Database Question asked by Garren

Know the Answer?

Please enter your response to the question below. The student will get a notification as soon your response has been approved by our moderation team.

Submit Answer

1 Answer

We need to identify the independent functional entities, in this case Property, Staff and Inspection are so

With the following three tables, we can achieve 3NF.

Property Table: Property Id, Property No, Property Address

Staff Table: Staff Id, Staff No, Staff Name

Inspection Table: Inspection Id, Property Id, Staff Id, Inspection Date, Inspection Time, Comments

If you need more explanation, let me know.

Thanks
Vamsi
Answered by Vamsi Krishna | 4 years ago
+ 2    Rate Up  Rate Down