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’)

Answer rating: 100% (QA)

Solution Here is the SQL script to create the table StudentsC0697697 with all the constraints you sp... View the full answer