Table: StudentCourses

$|$ StudentID $|$ StudentName $|$ CourseID $|$ CourseName $|$ InstructorID $|$ InstructorName $|$ InstructorPhone $|$

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

$|101|$ Alice $|$ CSE$101|$ Databases $|501|$ Dr$.$ Smith $|123-456-7890|$

$|102|$ Bob $|$ CSE$101|$ Databases $|501|$ Dr$.$ Smith $|123-456-7890|$

$|101|$ Alice $|$ CSE$102|$ Algorithms $|502|$ Dr$.$ Jones $|987-654-3210|$

$|103|$ Charlie $|$ CSE$101|$ Databases $|501|$ Dr$.$ Smith $|123-456-7890|$

a$.$ Identify and explain the anomalies that exist in the current unnormalized table.

$-$ Consider how inserting, updating, and deleting data might lead to issues.

b$.$ Normalize the table to the Third Normal Form $(3$NF$)$

$-$ Demonstrate each step of the normalization process:

$-1$NF $($First Normal Form$)$:$**$ Ensure there are no repeating groups or arrays.

$-2$NF $($Second Normal Form$)$:$**$ Ensure that all non$-$key attributes are fully dependent on the primary key.

$-3$NF $($Third Normal Form$)$:$**$ Ensure that there are no transitive dependencies, where non$-$key attributes depend on other non$-$key attributes.

c$.$ Provide the final table structures after normalizing to $3$NF$.$

$-$ Clearly define the tables and their relationships.

$-$ Specify the primary and foreign keys for each table.