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.

2. Write SQL code to create the COURSE table. Add the proper attributes for the course table as needed. Remember to include data type, data size, and if that field is required or not.

3. Write SQL statement to :

Insert at least three rows of fake data (any names, any addresses, so on) into the two tables created above.

Add a column called ExpecGradDate to the STUDENT table.

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 and save them in a new column

Show the first 3 records of data.

Delete the column ExoecGradDate.

Create a VIEW STATEMENT that shows only First Name, Last Name, and Email

Display records of students living in area code 32114.

Delete the table student