1. Write a create table command to create a relation that will hold the following data:

Driver_Licence	SSN	First_name	Last_Name	Date_of_Birth	State
AB17893	9820124	Harvey	Goldberg	01/01/1982	OH
CD17673	8975382	Paul	Maxwell	02/10/1974	CA
GH92641	7394104	Peter	Feynman	05/17/2005	HI
VH02378	1325639	Sally	Maxwell	07/22/2000	CA
lD820381	1325640	Sally	Feynman	09/01/2013	HI

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 Drivers 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?