Question: Perform the following operations using SQL Script and provide relevant screen shots in each case ( use Oracle/Oracle Live) Create the following table using a
Perform the following operations using SQL Script and provide relevant screen shots in each case ( use Oracle/Oracle Live) Create the following table using a SQL Script; 1. Table Name Students_\{YourStudentID } e.g Students_C0697697 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') Note: Apply these constraints one by one (not all at once). Enter some data to prove that constraints were applied correctly. Provide relevant screen shots for each case
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
