Tutor Hunt Questions
“Normalize the table into 3NF: Inspections (PropertyNo, Property_Address, Inspection_Date, Inspection_Time, Comments, StaffNo, Staff_Name)
7 years ago
Database Question asked by Garren
Add a CommentKnow 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.
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
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
