The Exhibit Shows a Table Called Housing Relation That Relates

Multiple Choice

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