The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory b
Posted: Sat Jul 23, 2022 7:29 pm
The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building.
Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?
A. 1NF
B. 1NF and 2NF
C. 1NF, 2NF and 3NF
D. 1NF, 2NF, 3NF and BCNF
Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?
A. 1NF
B. 1NF and 2NF
C. 1NF, 2NF and 3NF
D. 1NF, 2NF, 3NF and BCNF