Database Fundamental (TIS 1101 Tutorial 8: Staff - ID Staff - Name Staff - Age Course - Type Hourly - Fees
Database Fundamental (TIS 1101 Tutorial 8: Staff - ID Staff - Name Staff - Age Course - Type Hourly - Fees
Database Fundamental (TIS 1101 Tutorial 8: Staff - ID Staff - Name Staff - Age Course - Type Hourly - Fees
Tutorial 8
2. What is the normal form for the following table? Explain your answer.
.The table is in second normal form (2NF), because there are no partial dependencies
However, it is not in third normal form (3NF) since it exhibits transitive dependency,
where by a nonkey attribute (Course_Type) is dependent on a nonkey attribute
.((Hourly_Fees
A B C D E F G H
(Step 1: Convert to 2NF (remove Partial Dependency
A B C
D E
A D F G H
A B C
D E
G H
A D F G