A portion of the requirements are copied below.
****THE REQUIRED submissions MUST be in the zipped file format – not RAR nor any other format. The contents MUST be the actual SQL file and the Word document.
******The Word document must contain full screen captures – not a cut and paste of only a section- but the entire screen demonstrating the execution of each step listed in the assignment.
Please try to follow the listed naming convention of the files. This may seen minor but following requirements exactly is critical.
You MUST use the naming convention listed – YourLastName – really does mean to replace those words with your actual last name. Example – my submission would be MCMAHON_Project_Ph1_Output as one example.
If these instructions are not followed – 0 points will be earned. *****
DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS CAMPUS;
DROP TABLE IF EXISTS SEMESTER;
DROP TABLE IF EXISTS ROOM;
DROP TABLE IF EXISTS GRADES;
DROP TABLE IF EXISTS COURSE;
DROP TABLE IF EXISTS INSTRUCTOR;
DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
DROP TABLE IF EXISTS CLASS;
DROP TABLE IF EXISTS STUDENT_GRADE;
CREATE TABLE STUDENT(
STUDENT_ID INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
Last_Name VARCHAR(30),
First_Name VARCHAR(30),
Address VARCHAR(40),
ZIP VARCHAR(10),
MAJOR VARCHAR(20),
CLASS int(2),
STATUS VARCHAR(20));
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Morote’,’Italo’,’P.O. Box 619, 5808 Semper St.’,’32828′,’MATHEMATICS’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Martin’,’Yacky’,’313-6948 Nunc, Ave’,’36702′,’SPANISH’,3,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Yostin’,’Duglas’,’Ap #593-8291 Id St.’,’26151′,’BUSINESS’,1,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Dasti’,’Cosimel’,’328-4572 Elit Rd.’,’95886′,’SPANISH’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Dixon’,’Steve’,’Ap #547-7314 Feugiat. Street’,’42756′,’PHIL’,1,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Alfaro’,’Patricia’,’P.O. Box 977, 6922 Sed Street’,’52838′,’ENGLISH’,1,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Farruco’,’Rose’,’Ap #179-4485 Lectus Road’,’10816′,’ENGLISH’,3,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Pope’,’Vector’,’Ap #878-2252 Curabitur Av.’,’53175′,’PHYSICS’,3,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Los’,’Angeles’,’Ap #552-758 Convallis St.’,’56968′,’FINANCE’,3,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Diaz’,’Cameron’,’Ap #145-1961 Sed Street’,’63397′,’BUSINESS’,3,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Gonzalez’,’Andew’,’Ap #141-9425 In Road’,’87521′,’BUSINESS’,4,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Michael’,’Jordan’,’Ap #412-5802 Venenatis Rd.’,’77696′,’MARKETING’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Chelerson’,’Scholy’,’911-8666 A Rd.’,’32829′,’CIS’,2,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Payton’,’Tanya’,’5759 Nec, Street’,’23461′,’SPANISH’,3,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Jorge’,’Michael’,’Ap #642-7393 Ut, Ave’,’33186′,’PHIL’,1,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Cretiza’,’Noitus’,’8659 Arcu. Avenue’,’91267′,’PHYSICS’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Delami’,’Oscar’,’3512 Pellentesque. St.’,’33481′,’MATHEMATICS’,4,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Francisco’,’Zoeter’,’285-9157 Proin Road’,’98674′,’CS’,1,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Cohen’,’Aurora’,’P.O. Box 957, 9450 Arcu Street’,’30350′,’PHIL’,3,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Black’,’Joshua’,’3655 Sed St.’,’95684′,’FRENCH’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Barber’,’Michael’,’875-9349 Magnis St.’,’66498′,’PSY’,4,’SATISFACTORY’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Preston’,’Inez’,’Ap #829-845 Nisi Av.’,’27404′,’PSY’,1,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Direz’,’Blaster’,’439-1369 Cursus Av.’,’60644′,’MARKETING’,2,’FAILING’);
INSERT INTO STUDENT (Last_Name, First_Name, Address, ZIP, MAJOR, CLASS, STATUS)
VALUES(‘Aiton’,’Valeria’,’7513 Vitae Street’,’61245′,’MARKETING’,2,’FAILING’);
CREATE TABLE CAMPUS
(
CAMPUS_NAME VARCHAR(45) NOT NULL,
Address VARCHAR(40),
ZIP VARCHAR(10),
PHONE_NO VARCHAR(20),
UNIQUE(CAMPUS_NAME),
PRIMARY KEY(CAMPUS_NAME));
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘New York Campus’,’405-6298 In Street’,’62840′,’1-639-674-3520′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Chicago’,’820-7808 Risus, Rd.’,’51852′,’1-824-430-8362′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘San Francisco Campus’,’505-182 Luctus, Ave’,’21345′,’1-460-439-2331′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Seattle Campus’,’P.O. Box 215, 1469 Eu Rd.’,’52681′,’1-448-789-7971′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Washington Campus’,’631-5139 Leo. St.’,’29402′,’1-282-625-5720′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Los Angeles Campus’,’6161 Nostra, Road’,’83643′,’1-547-459-9473′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Denver Campus’,’9309 Cras Road’,’23421′,’1-680-673-7298′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Austin Campus’,’P.O. Box 878, 7621 Donec Road’,’73261′,’1-755-573-0468′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Houston Campus’,’P.O. Box 406, 9600 Odio Ave’,’32802′,’1-721-423-4315′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Detroit Campus’,’7574 Semper St.’,’21211′,’1-583-233-9026′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘San Diego Campus’,’6939 Ligula. St.’,’75022′,’1-941-394-7241′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘San Antonio Campus’,’7422 Vel Avenue’,’63763′,’1-604-359-7505′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Memphis Campus’,’P.O. Box 328, 5280 Donec Rd.’,’75068′,’1-865-208-5487′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Portland Campus’,’788-7924 Tellus. Street’,’75088′,’1-260-552-0600′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Miami Campus’,’518-7627 Ac Avenue’,’89090′,’1-262-155-0231′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Phoenix Campus’,’921-4825 Nullam Rd.’,’23117′,’1-324-211-7180′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Dallas Campus’,’Ap #202-6418 Eleifend Ave’,’54674′,’1-663-374-3235′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Atlanta Campus’,’927-3569 Id Road’,’71661′,’1-315-710-9509′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘San Jose Campus’,’8637 Ullamcorper Rd.’,’10001′,’1-224-161-4524′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Las Vegas Campus’,’P.O. Box 169, 7139 Arcu Rd.’,’83588′,’1-789-125-9687′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Indianapolis Campus’,’744-3904 Vulputate, Road’,’37762′,’1-640-455-9785′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Baltimore Campus’,’2849 At Ave’,’40882′,’1-299-696-4483′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Cleveland Campus’,’P.O. Box 785, 7330 Urna. St.’,’55794′,’1-789-114-1794′);
INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO)
VALUES(‘Oklahoma Campus’,’172-3924 At Ave’,’31619′,’1-111-206-2900′);
CREATE TABLE SEMESTER
(
SEMESTER_NAME ENUM(‘FALL’, ‘SPRING’, ‘SUMMER’));
DROP TABLE IF EXISTS ROOM CASCADE;
CREATE TABLE STUDENT_GRADE
(
Student_ID MEDIUMINT NOT NULL AUTO_INCREMENT,
Class_ID VARCHAR(10),
Student_Grade ENUM(‘A’,’B’,’C’,’D’,’F’,’I’,’W’),
PRIMARY KEY(Student_ID)
);
Commit;
SHOW TABLES;