1. Write SQL code to create a STUDENT table that includes the following attributes:
• Student ID
• First Name
• Last Name
• Street Address
• City
• State
• Zip Code
• Phone
• Email
In the code remember to include data type, data size, and if that field is required or not. The selected data types and data size should be logical. For example you cannot use Char (10) for street address; size 10 is very small compared to many long street addresses that we deal with every day. Having a short size data will create error messages.
1. Create table STUDENT (
StudentID Number (1,1) not null,
FirstName Char(30) not null,
LastName Char(30) not null,
StreetAddress Char(50) not null,
City Char(30) not null,
State Char (15) not null,
ZipCode Number(5,0) not null,
Phone Char(12) not null,
Email Char(100) not null,
Primary Key (StudentID));

2. Write SQL statement to :
• Insert at least three rows of fake data (any names, any addresses,…) into the table above.
• Add a column called StudentStatus to the table above.
• Add a new constraint to limit the student zip code to be within the following group (32117, 32116, 32115, 32114)
• Count the number of rows in the table
• Show the first 3 records of data.
• Delete the column StudentStatus.
• Create a view that shows only First Name, Last Name, and Email
• View records of students living in area code 32116.
• Delete the table student

2.
1. Insert into STUDENT values (
‘1’, ‘Frank’, ‘Redman’, ‘18 RidgeWood ave’, ‘Ormond Beach’, ‘FL’, ‘32174’, ‘234-343-2134’, ‘RedmanF@gmail.com’);
2. Insert into STUDENT values (
'2', 'James', 'Richard', ’23 conqunia ridge way’, Ormond Beach’, ‘FL’, ‘23145’, '555-537-7654', 'Richard.James@somewhere.com');
3. Insert into STUDENT values (
'3', 'Frier', 'Liz', ’65 seaton valley’, ‘Palm Coast’, ‘FL’, ‘23342’, '555-537-6543', 'Liz.Frier@somewhere.com');
4.