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

1 Expert Approved Answer
Step: 1 Unlock

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

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 Databases Questions!