Question: Create the following table using a SQL Script; 1. Table Name Students_{YourStudentID} e.g Students_C0697697 Student_ID Varchar(10) FirstName Varchar(50) LastName Varchar(100) Telephone_Number Varchar(10) Age int City
Create the following table using a SQL Script;
1. Table Name Students_{YourStudentID} e.g Students_C0697697
Student_ID
Varchar(10)
FirstName
Varchar(50)
LastName
Varchar(100)
Telephone_Number
Varchar(10)
Age
int
City
Varchar(50)
2. Add a Primary Key Constraint to Student_ID
3. Add a NOT NULL Constraint to LastName
4. Add a UNIQUE Constraint to Telephone_Number
5. Add a CHECK Constraint to Age (> 18)
6. Add a DEFAULT Constraint to City (Default city ‘Toronto’)
Step by Step Solution
There are 3 Steps involved in it
Solution Here is the SQL script to create the table StudentsC0697697 with all the constraints you sp... View full answer
Get step-by-step solutions from verified subject matter experts
