IT-330 DDL Exercise

Create the following tables as given. Use given columns and assign appropriate data types.

(CREATE TABLE statements)

STUDENT
StudentId (PK)
LastName
FirstName
Majorid (FK)
State
Gender
CountryCode (FK)

MAJOR
MajorId (PK)
MajorName

COUNTRY
CountryCode (PK)
Name
Capital

Make the following alterations: (ALTER TABLE statements)

• Add birthdate field in STUDENT table.
• Delete state field from STUDENT table.
• Create primary key for STUDENT table.
• Create primary key for MAJOR table.
• Create primary key for COUNTRY table.
• Make Name field unique in COUNTRY table.
• Make MajorName field not null in MAJOR table.
• Create a check constraint for the gender field in STUDENT table.
• Create majorid foreign key in STUDENT table to reference MAJOR table.
• Create countrycode foreign key in STUDENT table to reference COUNTRY table.