need to create this table and insert the information into it

Attendance Item 11 & 12

1. Create a new table in the HR schema called Student using the specification below:

student_id NUMBER(1) NOT NULL CONSTRAINT std_pk PRIMARY KEY,

first_name VARCHAR(15) NOT NULL,

last_name VARCHAR(25) NOT NULL,

email VARCHAR(60) NULL,

street VARCHAR(50) NOT NULL,

city VARCHAR(40) NOT NULL,

state CHAR(2) NOT NULL,

zip CHAR(5) NOT NULL,

phone VARCHAR(20) NOT NULL,

birth_date DATE NOT NULL,

sex VARCHAR(6) NOT NULL,

date_entered DATE,

lunch_cost FLOAT NULL);

2. Next create a second table called Grade

Note that all fields listed below are required and cannot be blank.

grade_id number(1) PK

student_id number(1) integer

course_number text 6

semester text 6

year number(1)

credits number(1)

grade text 2

3. Enter data into tables from the School Data worksheet into the database.

4. When finished, submit the SQL textfile to the dropbox

School Data Worksheet.xlsx