in sql server

+ Automatic Zoom 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 8041 8715 6485 7614 6745 FNAME Bugs Daffy Elmer Tweedy Sylvester LNAME Bunny Duck Fudd Bird Cat BIRTHDATE October 23, 1954 April13, 1943 May 5, 1946 August 31, 1951 February 19. 1949 4. Insert the following data into the PHONE table. PID 1 STUDENTID 6485 7614 8041 8041 8715 PHONENUMBER 920-551-1524 920-457-3251 925-457-6658 925-474-6854 928-451-6632 PHONETYPE MOBILE HOME HOME MOBILE OFFICE 3 4 5 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 Bugs Tweedy Elmer OLD VALUE NULL NULL NULL NEW VALUE 3.984 3.899 2.951