With the tables created.

(f)Retrieve the names of all junior or senior students majoring in computer science.

(g) Retrieve the names of courses taught by Professor Murphy (assume Professor Murphy is an instructor taught sections in different semesters in the database).

(h) Retrieve the name and transcript of each undergraduate students majoring in computer science. Note: transcript includes course name, course number, credit hours, semester, year, and letter grade.

(i) Retrieve the names and major of all A students.

(j) Retrieve the names and major of the students who do not have any A grade in their courses taken.

Create table Student( Sname VARCHAR (45), Sid NCHAR(9), Sssn NCHAR(9), sex NCHAR(1), Sclassification NCHAR (2), ScurrentAddr VARCHAR (45), SPermAddr VARCHAR (45), SPhoneNo NCHAR (10), SDegProg VARCHAR(5), MajorDcode INT(4) NOT NULL, MinorDcode INT (4), PRIMARY KEY (Sid) Create table Department( Dname VARCHAR (30), Dcode INT(4), DofficeNo VARCHAR (20), CollegeName VARCHAR (30), PRIMARY KEY (Dcode) DROP TABLE IF EXISTS StudentGrade FLUSH TABLES StudentGrade ; Create table studentGrade( Student_Sid NCHAR (9), Scnumber_Scnumber VARCHAR(10), Scnumber_Snumber VARCHAR(3), Scnumber_semester VARCHAR(3), Scnumber_Syear NCHAR (4), LG NCHAR(1), NG DECIMAL(5,2)