Sign Up
Tutor Hunt on twitter Tutor Hunt on facebook

Tutor HuntQuestions

Tutor Hunt Questions

Normalize the table into 3NF: Inspections (PropertyNo, Property_Address, Inspection_Date, Inspection_Time, Comments, StaffNo, Staff_Name)
22 months 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 | 22 months ago
+ 1    Rate Up  Rate Down     
Ask an Academic Question
Popular Links
© 2005-2017 Tutor Hunt - All Rights Reserved

Privacy | Copyright | Terms of Service
loaded in 0.063 seconds
twitter    facebook