Question: 1. Write a create table command to create a relation that will hold the following data Driver Licence SSN AB1789:3 First name Last Name Date

 1. Write a create table command to create a relation that

1. Write a create table command to create a relation that will hold the following data Driver Licence SSN AB1789:3 First name Last Name Date of.Birth State 9820124 Harvey Goldberg 01/01/1982 OH Maxwe 02/10/1974 CA Feynman 05/17/2005 HI Maxwell 07/22/2000 CA Feynman 09/01/2013 HI CD1767;3 8975382 Paul GH92641 7394104 Peter VH02378 1325639 Sally ID820381 1325640 Sally You will have to choose the datatype for each column. Also notice that 1. The Last Name cannot be NULL 2. The State column should have UD as default value 3. Driver Licence is the primary key 4. SSN should also be unique 2. Now insert the data 3. Write a command to update the record with Driver's Licence AB17893 to have NY as State 4. Now delete the record with SSN 1325640 5. Now update the two record with First Name Sally to have First Name Sal 6. Create a view that holds the CA records only 7. Insert a new record into the view. Does it also appear in the table? 8. Now alter the table to make sure that also First Name cannot be null 9. Now alter the table in order to add a new column named Points 10. Now complete the data of this new column so that everyone has 0 points except for Peter, who has 1 point and Harvey who has 2. Will you INSERT or UPDATE

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!