PERSON

Column	Data Type	Mandatory
PERSON_ID	Integer	Primary Key
fname	varchar(20)	Yes
lname	varchar(20)	Yes
Program	varchar(10)

Grade

Column	Data Type	Mandatory
course_id	varchar(10)	Primary Key
section_id	varchar(5)	Primary key
person_id	integer	Primary key, foreign key
year	integer	Yes
grade	numeric(4,1)

A) Alter the person table to add a new column.

YEAROFSTUDY varchar(5) DEFAULT 'FROSH'

Insert the following into the Person table:

Note: if you have trouble with Bob Loblaw, try specifying column names on the INSERT

101, Gob, Bluth, ARTS, SOPH 102, Sally, Jenkins, BCOM, SNR 103, Artis, Gilmore, SCI, JNR 104, Bob, Loblaw, ARTS

B) Insert the following into the Grades table

C001, S001, 101, 2017, 56.3 C001, S001, 103, 2017, 91 C001, S001, 104, 2017, 76.1 C002, S001, 103, 2017, 66 C002, S001, 101, 2017, 89 C003, S001, 102, 2017, 70 C003, S001, 104, 2017, 78.7

C)

Modify all of the grades in the Grades table by increasing them by 4%

Paste UPDATE command

D)

Modify the grade for Artis Gilmore in C002 to 84

Paste UPDATE command here

E)

Delete all of the grades for Gob Bluth

Paste your statement here

F)

Create a query to list Student fname, lname, program, year of study, courseID, section ID and grade. Note: JOIN

Paste your SQL here

\