Create a database in MySQL using the attached mysqluniversity.sql file. Use the command: mysql $-$u username $-$p $$ mysqluniversity.sql $,$ where username may be root or other user that you have configured in your MySQL installation.

Write SQL DDL statements that implement the following queries. Test each statement to make sure it is producing the correct output.

Find all CS students who live in Edinburg.

Find all possible pairs $($combinations$)$ of students and professors.

Find all possible pairs $($combinations$)$ of CS and CE students.

Find identifiers of all courses taken by the student named Nathan.

Find titles of all courses taken by the student named Nathan.

Find course titles and professor names for courses taken by the student named Nathan.

Find names of students who took a course taught by Artem.

Find names of professors who taught a course.

Find all CS and all IT students

Find the total number of credits completed by student with id $101.$

Take a screenshot for each query. Provide ten screenshots.

Provide the Q$3.$sql file that contains all your source code. Here is the CREATE DATABASE University;

USE University;

CREATE TABLE Student $($

sid INT PRIMARY KEY,

name VARCHAR$(20)$ NOT NULL,

address VARCHAR$(20)$ NOT NULL,

major CHAR$(2)$

$)$;

CREATE TABLE Professor $($

pid INT PRIMARY KEY,

name VARCHAR$(20)$ NOT NULL,

department VARCHAR$(10)$ NOT NULL

$)$;

CREATE TABLE Course $($

cid INT PRIMARY KEY,

title VARCHAR$(20)$ NOT NULL UNIQUE,

credits INT NOT NULL,

area VARCHAR$(5)$ NOT NULL

$)$;

CREATE TABLE Transcript $($

sid INT,

cid INT,

pid INT,

semester VARCHAR$(9),$

year YEAR,

grade CHAR$(1)$ NOT NULL,

PRIMARY KEY $($sid$,$ cid, semester, year$),$

FOREIGN KEY $($sid$)$ REFERENCES Student $($sid$),$

FOREIGN KEY $($cid$)$ REFERENCES Course $($cid$),$

FOREIGN KEY $($pid$)$ REFERENCES Professor $($pid$)$

$)$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(101,$ 'Nathan', 'Edinburg', $\text{'}$CS$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(105,$ 'Hussein', 'Edinburg', $\text{'}$IT$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(103,$ 'Jose', 'McAllen', $\text{'}$CE$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(102,$ 'Wendy', 'Mission', $\text{'}$CS$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(104,$ 'Maria', 'Pharr', $\text{'}$CS$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(106,$ 'Mike', 'Edinburg', $\text{'}$CE$\text{'})$;

INSERT INTO Student $($sid$,$ name, address, major$)$ VALUES $(107,$ 'Lily', 'McAllen', NULL$)$;

INSERT INTO Professor $($pid$,$ name, department$)$ VALUES $(201,$ 'Artem', $\text{'}$CS$\text{'})$;

INSERT INTO Professor $($pid$,$ name, department$)$ VALUES $(203,$ 'John', $\text{'}$CS$\text{'})$;

INSERT INTO Professor $($pid$,$ name, department$)$ VALUES $(202,$ 'Virgil', 'MATH'$)$;

INSERT INTO Professor $($pid$,$ name, department$)$ VALUES $(204,$ 'Pearl', $\text{'}$CS$\text{'})$;

INSERT INTO Professor $($pid$,$ name, department$)$ VALUES $(205,$ 'Christine', $\text{'}$CS$\text{'})$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(4333,$ 'Database', $3,\text{'}$DB$\text{'})$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(1201,$ 'Comp literacy', $2,$ 'INTRO'$)$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(6333,$ 'Advanced Database', $3,\text{'}$DB$\text{'})$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(6315,$ 'Applied Database', $3,\text{'}$DB$\text{'})$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(3326,$ 'Java', $3,\text{'}$PL$\text{'})$;

INSERT INTO Course $($cid$,$ title, credits, area$)$ VALUES $(1370,\text{'}$CS I$\text{'},4,$ 'INTRO'$)$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(101,4333,201,$ 'Spring', $\text{'}2009\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(101,6333,201,$ 'Fall', $\text{'}2009\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(101,6315,201,$ 'Fall', $\text{'}2009\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(103,4333,203,$ 'Summer I$\text{'},\text{'}2010\text{'},\text{'}$B$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(102,4333,201,$ 'Fall', $\text{'}2009\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(103,3326,204,$ 'Spring', $\text{'}2008\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(104,1201,205,$ 'Fall', $\text{'}2009\text{'},\text{'}$B$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(104,1370,203,$ 'Summer II$\text{'},\text{'}2010\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(106,1201,205,$ 'Fall', $\text{'}2009\text{'},\text{'}$C$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(106,1370,203,$ 'Summer II$\text{'},\text{'}2010\text{'},\text{'}$C$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(105,3326,204,$ 'Spring', $\text{'}2001\text{'},\text{'}$A$\text{'})$;

INSERT INTO Transcript $($sid$,$ cid, pid, semester, year, grade$)$ VALUES $(105,6315,203,$ 'Fall', $\text{'}2008\text{'},\text{'}$A$\text{'})$;