Update the datatype for your attributes


For each entity listed in the Solution file, create a table in Access. 
Add primary keys for each table. 
Update the datatype for your attributes to enforce the domain constraints of the data. 

Dates should have a date datatype. 
Surrogate keys should be auto-number. 
Numeric should have a numeric datatype. 
Character data should have a character datatype. 
Under Database Tools, create the relationships as appropriate. 
All relationships should have referential integrity and cascade update enabled. 
Add column constraints as indicated below. 
Campus name should be NORTH OR SOUTH. 
Student name shall be not null. 
Course credit hours must be between 1 and 4. 
Course name must be unique and not null. 
Instructor last name and first name shall be not null. 
Grade shall be one of these values, A, B, C, D, F, I, W, or E (Enrolled). 
Add several rows of data for each table.

Request for Solution File

Ask an Expert for Answer!!
Programming Languages: Update the datatype for your attributes
Reference No:- TGS0117398

Expected delivery within 24 Hours