Question

Question 14

The above Students is a 1NF but not 2NF table.

Students SID U301 Sherwood Davicd U472 Zimmer U188 Sherwood Christine GPA PassedCourse 3.33 3.74 MAC1105 College Algebra 2.86MAS3105 Linear Algebra Lname Fname MAS3105 Linear Algebra CHM2045 General Chemistry I Gary ECO3703 International Economics CHM2045 General Chemistry l

True

False

Question 15

Without splitting Students of Question 14 to two or more tables, it can be normalized to a table containing

3 rows of data

4 rows of data

5 rows of data

6 rows of data

Answer 1

Question 14:

Answer: False

Explanation: A table to be in 1NF, each column(attribute) of table should contain only single(atomic) values. But in given table, "PassedCourse" column has 2 values in first row and 3 values in third row. So, it is not satisifying 1NF.

Question 15:

Answer: 6 rows of data

Explanation: We can normalize above table by putting each value in "PassedCourse" column in one row.

We can normalize as below

SID	Lname	Fname	GPA	PassedCourse
U301	Sherwood	David	3.33	MAS3105 Linear Algebra
U301	Sherwood	David	3.33	CHM2045 General Chemistry1
U472	Zimmer	Gary	3.74	MAC1105 College Algebra
U188	Sherwood	Christine	2.86	ECO3703 International Economics
U188	Sherwood	Christine	2.86	MAS3105 Linear Algebra
U188	Sherwood	Christine	2.86	CHM2045 General Chemistry1