SQL problem:

1) Update the two records with First Name Sally to have First Name Sal 2) Create a view that holds the CA records only 3) Insert a new record into the view. Does it also appear in the table? 4) Now alter the table to make sure that also First Name cannot be null 5) Now alter the table in order to add a new column named Points 6) Now complete the data of this new column so that everyone has 0 points except for Paul, who has 1 point and Harvey who has 2. Will you INSERT or UPDATE? 7) Create a new view that holds the data with DOB after 1990, this view should include the WITH CHECK OPTION. 8) Now try to insert a new record in this view. Try 1 record that has DOB before 1990 and one that has DOB after 1990.

Driver_Licence SSN First_name Last_Name Birth_Date Hire_Date State AB17893 9820124 Harvey Goldberg 01/01/1982 06/05/2003 OH CD17673 8975382 Paul Maxwell 02/10/1974 07/14/2015 CA GH92641 7394104 Peter Feynman 05/17/2005 09/08/2020 HI VH02378 1325639 Sally Maxwell 07/22/2000 01/01/2020 CA ID820381 1325640 Sally Feynman 09/01/1985 06/03/2008 HI