What can be said about the following relational database table (key is underlined): (Choose the most correct answer)
StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding
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)
StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding
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 because all entries are atomic, and in Second Normal Form because all non-key attributes are fully functionally dependent on the primary key, StudentID. However, it may not be in Third Normal Form if there are transitive dependencies among non-key attributes.

​What Can Be Said About the Following Relational Database Table

What Can Be Said About the Following Relational Database Table