List all four tables with columns and primary keys using shorthand notation. Use your answers from exercises 2 and 3 to complete this student database.

In the Student Course table, multiple students can enroll the same course. Therefore, update anomalies can occur when there is a change in CourseDescription. Solve the problem by creating a new table called Course table. List your Course table with its columns and primary key using shorthand notation.

We have normalized the original Student table to avoid repeating groups and created new tables to solve the update anomalies. We now have a good design of our student database which consists of four tables below. All tables are normalized and do not have update anomalies.

Advisor

StudentCourse

Course

List all four tables with columns and primary keys using shorthand notation. Use your answers from exercises 2 and 3 to complete this student database. Note that Student and Student Course tables should be listed as shown. Since Term and Grade columns are already in the Student Course table, they should not be in the Course table.
To understand how your work will be assessed, view the Scoring Rubric. Click for more options
Click on the assignment title link above to submit your completed assignment.