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

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

1 Expert Approved Answer
Step: 1 Unlock 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!