Subject SQL Thank you

1. Write to code to create the Table STUDENT. Use the following column names and date type: STUDENTID Seven Digits, FNAME 20 alphabetic characters, LNAME 30 alphabetic characters, BIRTHDATE Date.

2. Write to code to create the Table PHONE. Use the following column names and date type: PID Numeric Five digits, STUDENTID Seven Digits, PHONENUMBER 12 Alphanumeric characters, PONETYPE 15 Alphanumeric characters.

3. Insert the following data into the STUDENT table. STUDENTID | FNAME | LNAME | BIRTHDATE 8041 | Bugs Bunny | October 23, | 1954 8715 | Daffy Duck | April13, | 1943 6485 | Elmer Fudd | May 5, | 1946 7614 | Tweedy Bird | August 31, | 1951 6745 | Sylvester Cat | February 19 , | 1949

4. Insert the following data into the PHONE table. PID | STUDENTID | PHONENUMBER | PHONETYPE 1 | 6485 | 920-551-1524 | MOBILE 2 | 7614 | 920-457-3251 | HOME 3 | 8041 | 925-457-6658 | HOME 4 | 8041 | 925-474-6854 | MOBILE 5 | 8715 | 928-451-6632 | OFFICE

5. Add the following column to the STUDENT table. GPA 4 numeric digits with 3 decimal positions.

6. Update the GPA in the STUDENT table for the following records. STUDENT | OLD VALUE | NEW VALUE Bugs | NULL | 3.984 Tweedy | NULL | 3.899 Elmer | NULL | 2.951

7. Delete all the records from the STUDENT table where the last digit in the student id is a 5.

8. Update all the GPAs in the STUDENT table with a 1% increase.