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 auto-increment.
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 two-character field.
Following the ERD below, write the create file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!