Use the modern syntax for creating constraints using the explicit constraint keyword $($the so$-$called out$-$of$-$line syntax$)$

Remember to use the $3-$part column definition for every column

Using foreign key constraints, create the required maximum cardinality. Don't forget the $"$on update" and $"$on delete" clauses. What is the syntax for creating an FK constraint with a compound FK$?$

Use NULL$/$NOT NULL on the FK to create the required minimum cardinality

Note: Do any of the numbers in Assignment$3.$xlsx look like they are an automatically generated sequence of numbers?

Create DML Insert statements in the correct table order. You must use the original data from the Assignment$3.$xslx file.

Include a screenshot of the Database Diagram showing the tables, $3-$part column definition, and relationships. Did you follow instructions on how to configure SSMS to show the $3-$part column definitions in the database diagram?

Include a screenshot of at least some of the content $($rows of data$)$ from each table

You should do this assignment using a real SQL Server database. That way the SSMS will be able to spot problems for you immediately.

Use this normalized data from Assignment $4$

Student: StudentID, FirstName, LastName, PrimaryMajor, Classification

Catalog: CourseID, Title, CreditHours, PreReq

Professor: ProfessorID, ProfName, ProfOffice, ProfPhone

Schedule: Semester, CourseID, Section, ProfessorID, ClassType, RoomNo, Days, StartTime

Grades: Semester, CourseID, Section, StudentID, QuizNum, QuizGrade

Other notes:

Since there are $5$ tables, there will be $5$ Primary Key constraints $($two of which will be a compound key$)$

Since there are $4$ arrows connecting tables on the Visio diagram, there will be $4$ Foreign Key constraints $($one of which will be a compound foreign key$)$

Every Foreign Key should have the $"$on delete" and $"$on update" actions filled out

Make sure that you're using the most modern technique for creating constraints with the explicit "constraint" keyword

On a $1$:M$,$ which side does the Foreign Key go$?$

Since there are $5$ tables, there will be $5$ multi$-$line insert statements $(4$ rows in Catalog, $34$ in Grades, $4$ in Professor, $10$ in Schedule, and $9$ in Student$).$ You must use the original data from the Assignment$3.$xlsx file

Actually doing the inserts into a live database will immediately tell you if there is a problem with your design

Since the order of filling the tables matters, I$\text{'}$d recommend that you start with the strong entities first

Save this database... you will need it again in the next assignment