Consider your previous Student Database.

Add a new table named Department.

Make primary and foreign key relationships between StudentInfo and the Department table. Note that, it is a one$-$to$-$many relationship.

Make primary and foreign key relationships between StudentInfo and Course table. Note that, it is many$-$to$-$many relationships.

Insert $4/5$ Departments to the Department table,

Insert $4/5$ Courses to the Course Table

Insert $8/10$ Student information into the StudentInfo table