Subject:

Database Management

1st Normal Form (1NF)

Consider the Students table, with the primary key underlined, and the following data:

Students:

a) Is the Students table in 1NF? Why?

b) If the Students table is not in 1NF, redesign the tables such that all the information currently in the Students table is found in the resulting tables, and the resulting tables are in 1NF. For each of the resulting tables, give the table name, column names, primary keys, and foreign keys.

GradePoints 2,3,3 Students: Alpha Name Email Courses 100111 John Doe doe@usna.edu NN204, S1204, IT221 092244 Matt Smith smith@usna.edu SM223, EE301 113221 Melinda Black black@usna.edu S1204 090112 Tom Johnson Johnson@usna.edu NN204, S1204, 1T221 4,4 3 4,2,3