Question: Following the ERD below, write the create file using the correct name and data type for each entity, and attribute. Follow the recommendations below. The
Following the ERD below, write the create file using the correct name and data type for each entity, and attribute. Follow the recommendations below.
The database should be called "CollegeHW".
All IDs should be set to autoincrement.
Make sure to add the constraints of primary keys and foreign keys for each table using the ALTER TABLE statement.
The student level and class level is a nvarchar field.
The GPA and the Final Grade Num should accept two decimal cases.
The Final Grade Letter should be a twocharacter field.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
