What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID,StudentID,Grade,StudentName
A)Not in any valid normal form
B)In First Normal Form
C)In First and Second Normal Form
D)In First, Second, and Third Normal Form

Question

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)​ CourseSectionID,StudentID,Grade,StudentName
A)Not in any valid normal form
B)​In First Normal Form
C)In First and Second Normal Form
D)​​In First, Second, and Third Normal Form

Quizplus · Accepted Answer

The table is in First Normal Form as it has a primary key - CourseSectionID and StudentID - and each column contains atomic values. However, it may not be in Second or Third Normal Form without further information about the functional dependencies between the columns.

What Can Be Said About the Following Relational Database Table