Imagine we have a student database that records information about

students, classes, and teachers.

Student Table:

$|$ Student ID $|$ Student Name $|$ Class ID $|$ Teacher ID $|$

$|------------|--------------|----------|------------|$

$|1|$ Alice $|101|201|$

$|2|$ Bob $|102|202|$

$|3|$ Carol $|101|201|$

Class Table:

$|$ Class ID $|$ Class Name $|$

$|----------|------------|$

$|101|$ Math $|$

$|102|$ History $|$

Teacher Table:

$|$ Teacher ID $|$ Teacher Name $|$

$|------------|--------------|$

$|201|$ Mr$.$ Smith $|$

$|202|$ Ms$.$ Johnson $|$

How would we put this into $1$NF$?$

Question $13$ options:

It is already in $1$NF

Remove Class ID and Teacher ID from the Student Table

Add Student ID to the Class Table

Combine all fields into one table. Each row will have

a normal primary key.