Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the modern syntax for creating constraints using the explicit constraint keyword ( the so - called out - of - line syntax ) Remember
Use the modern syntax for creating constraints using the explicit constraint keyword the socalled outofline syntax
Remember to use the 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 NULLNOT NULL on the FK to create the required minimum cardinality
Note: Do any of the numbers in Assignmentxlsx 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 Assignmentxslx file.
Include a screenshot of the Database Diagram showing the tables, part column definition, and relationships. Did you follow instructions on how to configure SSMS to show the 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
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 tables, there will be Primary Key constraints two of which will be a compound key
Since there are arrows connecting tables on the Visio diagram, there will be 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 :M which side does the Foreign Key go
Since there are tables, there will be multiline insert statements rows in Catalog, in Grades, in Professor, in Schedule, and in Student You must use the original data from the Assignmentxlsx 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, Id recommend that you start with the strong entities first
Save this database... you will need it again in the next assignment
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started