STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l }
\text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \
\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \
D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \
D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \
D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \
D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }
\end{array}$$
-Table STUDENT is in 3NF.

Question

STUDENT
Observe the table STUDENT:
STUDENT
 $$\begin{array} { l c l l } 
\text { StudentID } & \text { SSN } & \text { Nane } &  { \text { Class } } \
\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \
D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \
D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \
D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \
D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }
\end{array}$$
-Table STUDENT is in 3NF.

Quizplus · Accepted Answer

The table STUDENT does not have any repeating groups or transitive dependencies. Each attribute is dependent on the primary key StudentID. Therefore, it is in 3NF.

STUDENT Observe the Table STUDENT: STUDENT -Table STUDENT Is in 3NF

STUDENT
Observe the Table STUDENT:
STUDENT -Table STUDENT Is in 3NF