Objective: In this assignment, you will practice normalizing a relational database schema to reduce redundancy and improve data integrity. You will perform normalization from $1$st Normal Form $(1$ NF $)$ to $3$rd Normal Form $(3$ NF $),$ ensuring that all tables are appropriately structured.

Unnormalized Table $($UNF$)$:

Course Table

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline StudentID & StudentName & StudentPhone & CourseID & CourseName & InstructorID & InstructorDetails & EnrollmentDate & Grades $\backslash \backslash$

$\backslash$hline $101$ & Alice & $\backslash$begin$\{$tabular$\}\{$l$\}$

$\backslash (555-1234\backslash ),\backslash \backslash$

$\backslash (555-5678\backslash )$

$\backslash$end$\{$tabular$\}$ & CSE$101$ & Databases & $201$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Prof. Smith, $\backslash \backslash$

Room $202$

$\backslash$end$\{$tabular$\}$ & $\backslash (2023-09-01\backslash )$ & A$,$ B $\backslash \backslash$

$\backslash$hline $102$ & Bob & $\backslash (555-9876\backslash )$ & CSE$101$ & Databases & $201$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Prof. Smith, $\backslash \backslash$

Room $202$

$\backslash$end$\{$tabular$\}$ & $\backslash (2023-09-01\backslash )$ & B $\backslash \backslash$

$\backslash$hline $101$ & Alice & $\backslash$begin$\{$tabular$\}\{$l$\}$

$\backslash (555-1234\backslash ),\backslash \backslash$

$\backslash (555-5678\backslash )$

$\backslash$end$\{$tabular$\}$ & MAT$101$ & Calculus & $202$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Prof. Jones, $\backslash \backslash$

Room $303$

$\backslash$end$\{$tabular$\}$ & $\backslash (2023-09-02\backslash )$ & B $\backslash \backslash$

$\backslash$hline $103$ & Charlie & $\backslash (555-8765\backslash )$ & MAT$101$ & Calculus & $202$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Prof. Jones, $\backslash \backslash$

Room $303$

$\backslash$end$\{$tabular$\}$ & $\backslash (2023-09-02\backslash )$ & A $\backslash \backslash$

$\backslash$hline $101$ & Alice & $\backslash$begin$\{$tabular$\}\{$l$\}$

$\backslash (555-1234\backslash ),\backslash \backslash$

$\backslash (555-5678\backslash )$

$\backslash$end$\{$tabular$\}$ & PHY$101$ & Physics & $203$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Prof. Brown, $\backslash \backslash$

Room $101$

$\backslash$end$\{$tabular$\}$ & $\backslash (2023-09-03\backslash )$ & A $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Step $1$: $1$st Normal Form $(1$NF$)$

$-$ In the first step, ensure that all the data is atomic $($each cell contains a single value$)$ and that the table has no repeating groups.

$-$ Task: Convert the unnormalized table into $\backslash (1$ N F $\backslash ).$ List any issues found in the table and how you fixed them.

Step $2$: $2$nd Normal Form $(2$NF$)$

$-$ Identify the primary key of the table $($a composite key may be necessary$).$ Check for partial dependencies, where non$-$key attributes depend on part of a composite key.

$-$ Task: Decompose the $1$ NF table into $2$NF by removing partial dependencies. Create new tables if necessary and provide a new schema.

Step $3$: $3$rd Normal Form $(3$NF$)$

$-$ In this step, you will remove transitive dependencies, where non$-$key attributes are dependent on other non$-$key attributes.

$-$ Task: Decompose the $2$NF table into $3$NF by eliminating transitive dependencies. Create new tables if necessary and provide a new schema.