I have 35 written questions and 5 SQL assignments.I will provide all three Query languages for the database and the ER Diagram. For the SQL assignments, you must provide both the SQL statement and th

ALTER SESSION SET "_ORACLE_SCRIPT"=true; CREATE USER Colonial IDENTIFIED BY Passw0rd; GRANT ALL PRIVILEGES TO Colonial; CONNECT Colonial/Passw0rd; CREATE TABLE Guide (GuideNum CHAR(4) PRIMARY KEY, LastName varchar2(15), FirstName varchar2(15), Address varchar2(25), City varchar2(25), State CHAR(2), PostalCode CHAR(5), PhoneNum CHAR(12), HireDate DATE ); CREATE TABLE Customer (CustomerNum CHAR(4) PRIMARY KEY, LastName varchar2(30) NOT NULL, FirstName VARCHAR (30), Address varchar2(35), City varchar2(35), State CHAR(2), PostalCode CHAR(5), Phone CHAR(12) ); CREATE TABLE Reservation (ReservationID CHAR(7) PRIMARY KEY, TripID INT, TripDate DATE, NumPersons INT, TripPrice DECIMAL(6,2), OtherFees DECIMAL(6,2), CustomerNum CHAR(4) ); CREATE TABLE Trip (TripID INT PRIMARY KEY, TripName varchar2(75), StartLocation varchar2(50), State CHAR(2), Distance INT, MaxGrpSize INT, Type varchar2(20), Season varchar2(20) ); CREATE TABLE TripGuides (TripID INT, GuideNum CHAR(4), PRIMARY KEY (TripID, GuideNum) ); INSERT INTO Guide VALUES ('AM01','Abrams','Miles','54 Quest Ave.','Williamsburg','MA','01096','617-555-6032',to_date('2012-06-03','YYYY-MM-DD')); INSERT INTO Guide VALUES ('BR01','Boyers','Rita','140 Oakton Rd.','Jaffrey','NH','03452','603-555-2134',to_date('2012-03-04','YYYY-MM-DD')); INSERT INTO Guide VALUES ('DH01','Devon','Harley','25 Old Ranch Rd.','Sunderland','MA','01375','781-555-7767',to_date('2017-01-08','YYYY-MM-DD')); INSERT INTO Guide VALUES ('GZ01','Gregory','Zach','7 Moose Head Rd.','Dummer','NH','03588','603-555-8765',to_date('2013-11-04','YYYY-MM-DD')); INSERT INTO Guide VALUES ('KS01','Kiley','Susan','943 Oakton Rd.','Jaffrey','NH','03452','603-555-1230',to_date('2016-04-08','YYYY-MM-DD')); INSERT INTO Guide VALUES ('KS02','Kelly','Sam','9 Congaree Ave.','Fraconia','NH','03580','603-555-0003',to_date('2016-06-10','YYYY-MM-DD')); INSERT INTO Guide VALUES ('MR01','Marston','Ray','24 Shenandoah Rd.','Springfield','MA','01101','781-555-2323',to_date('2015-09-14','YYYY-MM-DD')); INSERT INTO Guide VALUES ('RH01','Rowan','Hal','12 Heather Rd.','Mount Desert','ME','04660','207-555-9009',to_date('2014-06-02','YYYY-MM-DD')); INSERT INTO Guide VALUES ('SL01','Stevens','Lori','15 Riverton Rd.','Coventry','VT','05825','802-555-3339',to_date('2014-09-05','YYYY-MM-DD')); INSERT INTO Guide VALUES ('UG01','Unser','Glory','342 Pineview St.','Danbury','CT','06810','203-555-8534',to_date('2017-02-02','YYYY-MM-DD')); INSERT INTO Customer VALUES ('101','Northfold','Liam','1985 Highway 17 N.','Londonderry','NH','03053','603-555-7563'); INSERT INTO Customer VALUES ('102','Ocean','Arnold','2332 South St. Apt 3','Springfield','MA','01101','413-555-3212'); INSERT INTO Customer VALUES ('103','Kasuma','Sujata','132 Main St. #1','East Hartford','CT','06108','860-555-0703'); INSERT INTO Customer VALUES ('104','Goff','Ryan','164A South Bend Rd.','Lowell','MA','01854','781-555-8423'); INSERT INTO Customer VALUES ('105','McLean','Kyle','345 Lower Ave.','Wolcott','NY','14590','585-555-5321'); INSERT INTO Customer VALUES ('106','Morontoia','Joseph','156 Scholar St.','Johnston','RI','02919','401-555-4848'); INSERT INTO Customer VALUES ('107','Marchand','Quinn','76 Cross Rd.','Bath','NH','03740','603-555-0456'); INSERT INTO Customer VALUES ('108','Rulf','Uschi','32 Sheep Stop St.','Edinboro','PA','16412','814-555-5521'); INSERT INTO Customer VALUES ('109','Caron','Jean Luc','10 Greenfield St.','Rome','ME','04963','207-555-9643'); INSERT INTO Customer VALUES ('110','Bers','Martha','65 Granite St.','York','NY','14592','585-555-0111'); INSERT INTO Customer VALUES ('112','Jones','Laura','373 Highland Ave.','Somerville','MA','02143','857-555-6258'); INSERT INTO Customer VALUES ('115','Vaccari','Adam','1282 Ocean Walk','Ocean City','NJ','08226','609-555-5231'); INSERT INTO Customer VALUES ('116','Murakami','Iris','7 Cherry Blossom St.','Weymouth','MA','02188','617-555-6665'); INSERT INTO Customer VALUES ('119','Chau','Clement','18 Ark Ledge Ln.','Londonderry','VT','05148','802-555-3096'); INSERT INTO Customer VALUES ('120','Gernowski','Sadie','24 Stump Rd.','Athens','ME','04912','207-555-4507'); INSERT INTO Customer VALUES ('121','Bretton-Borak','Siam','10 Old Main St.','Cambridge','VT','05444','802-555-3443'); INSERT INTO Customer VALUES ('122','Hefferson','Orlagh','132 South St. Apt 27','Manchester','NH','03101','603-555-3476'); INSERT INTO Customer VALUES ('123','Barnett','Larry','25 Stag Rd.','Fairfield','CT','06824','860-555-9876'); INSERT INTO Customer VALUES ('124','Busa','Karen','12 Foster St.','South Windsor','CT','06074','857-555-5532'); INSERT INTO Customer VALUES ('125','Peterson','Becca','51 Fredrick St.','Albion','NY','14411','585-555-0900'); INSERT INTO Customer VALUES ('126','Brown','Brianne','154 Central St.','Vernon','CT','06066','860-555-3234'); INSERT INTO Reservation VALUES ('1800001',40,to_date('2018-03-26','YYYY-MM-DD'),2,55.00,0.00,'101'); INSERT INTO Reservation VALUES ('1800002',21,to_date('2018-06-08','YYYY-MM-DD'),2,95.00,0.00,'101'); INSERT INTO Reservation VALUES ('1800003',28,to_date('2018-09-12','YYYY-MM-DD'),1,35.00,0.00,'103'); INSERT INTO Reservation VALUES ('1800004',26,to_date('2018-10-16','YYYY-MM-DD'),4,45.00,15.00,'104'); INSERT INTO Reservation VALUES ('1800005',39,to_date('2018-06-25','YYYY-MM-DD'),5,55.00,0.00,'105'); INSERT INTO Reservation VALUES ('1800006',32,to_date('2018-06-18','YYYY-MM-DD'),1,80.00,20.00,'106'); INSERT INTO Reservation VALUES ('1800007',22,to_date('2018-07-09','YYYY-MM-DD'),8,75.00,10.00,'107'); INSERT INTO Reservation VALUES ('1800008',28,to_date('2018-09-12','YYYY-MM-DD'),2,35.00,0.00,'108'); INSERT INTO Reservation VALUES ('1800009',38,to_date('2018-09-11','YYYY-MM-DD'),2,90.00,40.00,'109'); INSERT INTO Reservation VALUES ('1800010',2,to_date('2018-05-14','YYYY-MM-DD'),3,25.00,0.00,'102'); INSERT INTO Reservation VALUES ('1800011',3,to_date('2018-09-15','YYYY-MM-DD'),3,25.00,0.00,'102'); INSERT INTO Reservation VALUES ('1800012',1,to_date('2018-06-12','YYYY-MM-DD'),4,15.00,0.00,'115'); INSERT INTO Reservation VALUES ('1800013',8,to_date('2018-07-09','YYYY-MM-DD'),1,20.00,5.00,'116'); INSERT INTO Reservation VALUES ('1800014',12,to_date('2018-10-01','YYYY-MM-DD'),2,40.00,5.00,'119'); INSERT INTO Reservation VALUES ('1800015',10,to_date('2018-07-23','YYYY-MM-DD'),1,20.00,0.00,'120'); INSERT INTO Reservation VALUES ('1800016',11,to_date('2018-07-23','YYYY-MM-DD'),6,75.00,15.00,'121'); INSERT INTO Reservation VALUES ('1800017',39,to_date('2018-06-18','YYYY-MM-DD'),3,20.00,5.00,'122'); INSERT INTO Reservation VALUES ('1800018',38,to_date('2018-09-18','YYYY-MM-DD'),4,85.00,15.00,'126'); INSERT INTO Reservation VALUES ('1800019',25,to_date('2018-08-29','YYYY-MM-DD'),2,110.00,25.00,'124'); INSERT INTO Reservation VALUES ('1800020',28,to_date('2018-08-27','YYYY-MM-DD'),2,35.00,10.00,'124'); INSERT INTO Reservation VALUES ('1800021',32,to_date('2018-06-11','YYYY-MM-DD'),3,90.00,20.00,'112'); INSERT INTO Reservation VALUES ('1800022',21,to_date('2018-06-08','YYYY-MM-DD'),1,95.00,25.00,'119'); INSERT INTO Reservation VALUES ('1800024',38,to_date('2018-09-11','YYYY-MM-DD'),1,70.00,30.00,'121'); INSERT INTO Reservation VALUES ('1800025',38,to_date('2018-09-11','YYYY-MM-DD'),2,70.00,45.00,'125'); INSERT INTO Reservation VALUES ('1800026',12,to_date('2018-10-01','YYYY-MM-DD'),2,40.00,0.00,'126'); INSERT INTO Reservation VALUES ('1800029',4,to_date('2018-09-19','YYYY-MM-DD'),4,105.00,25.00,'120'); INSERT INTO Reservation VALUES ('1800030',15,to_date('2018-07-25','YYYY-MM-DD'),6,60.00,15.00,'104'); INSERT INTO Trip VALUES (1,'Arethusa Falls ','Harts Location','NH',5,10,'Hiking','Summer'); INSERT INTO Trip VALUES (2,'Mt Ascutney - North Peak','Weathersfield','VT',5,6,'Hiking','Late Spring'); INSERT INTO Trip VALUES (3,'Mt Ascutney - West Peak','Weathersfield','VT',6,10,'Hiking','Early Fall'); INSERT INTO Trip VALUES (4,'Bradbury Mountain Ride','Lewiston-Auburn','ME',25,8,'Biking','Early Fall'); INSERT INTO Trip VALUES (5,'Baldpate Mountain ','North Newry','ME',6,10,'Hiking','Late Spring'); INSERT INTO Trip VALUES (6,'Blueberry Mountain','Batchelders Grant','ME',8,8,'Hiking','Early Fall'); INSERT INTO Trip VALUES (7,'Bloomfield - Maidstone','Bloomfield','CT',10,6,'Paddling','Late Spring'); INSERT INTO Trip VALUES (8,'Black Pond','Lincoln','NH',8,12,'Hiking','Summer'); INSERT INTO Trip VALUES (9,'Big Rock Cave','Tamworth','NH',6,10,'Hiking','Summer'); INSERT INTO Trip VALUES (10,'Mt. Cardigan - Firescrew','Orange','NH',7,8,'Hiking','Summer'); INSERT INTO Trip VALUES (11,'Chocorua Lake Tour','Tamworth','NH',12,15,'Paddling','Summer'); INSERT INTO Trip VALUES (12,'Cadillac Mountain Ride','Bar Harbor','ME',8,16,'Biking','Early Fall'); INSERT INTO Trip VALUES (13,'Cadillac Mountain','Bar Harbor','ME',7,8,'Hiking','Late Spring'); INSERT INTO Trip VALUES (14,'Cannon Mtn','Franconia','NH',6,6,'Hiking','Early Fall'); INSERT INTO Trip VALUES (15,'Crawford Path Presidentials Hike','Crawford Notch','NH',16,4,'Hiking','Summer'); INSERT INTO Trip VALUES (16,'Cherry Pond','Whitefield','NH',6,16,'Hiking','Spring'); INSERT INTO Trip VALUES (17,'Huguenot Head Hike','Bar Harbor','ME',5,10,'Hiking','Early Fall'); INSERT INTO Trip VALUES (18,'Low Bald Spot Hike','Pinkam Notch','NH',8,6,'Hiking','Early Fall'); INSERT INTO Trip VALUES (19,'Masons Farm ','North Stratford','CT',12,7,'Paddling','Late Spring'); INSERT INTO Trip VALUES (20,'Lake Mephremagog Tour','Newport','VT',8,15,'Paddling','Late Spring'); INSERT INTO Trip VALUES (21,'Long Pond','Rutland','MA',8,12,'Hiking','Summer'); INSERT INTO Trip VALUES (22,'Long Pond Tour','Greenville','ME',12,10,'Paddling','Summer'); INSERT INTO Trip VALUES (23,'Lower Pond Tour','Poland','ME',8,15,'Paddling','Late Spring'); INSERT INTO Trip VALUES (24,'Mt Adams ','Randolph','NH',9,6,'Hiking','Summer'); INSERT INTO Trip VALUES (25,'Mount Battie Ride','Camden','ME',20,8,'Biking','Early Fall'); INSERT INTO Trip VALUES (26,'Mount Cardigan Hike','Cardigan','NH',4,16,'Hiking','Late Fall'); INSERT INTO Trip VALUES (27,'Mt. Chocorua','Albany','NH',6,10,'Hiking','Spring'); INSERT INTO Trip VALUES (28,'Mount Garfield Hike','Woodstock','NH',5,10,'Hiking','Early Fall'); INSERT INTO Trip VALUES (29,'Metacomet-Monadnock Trail Hike','Pelham','MA',10,12,'Hiking','Late Spring'); INSERT INTO Trip VALUES (30,'McLennan Reservation Hike','Tyringham','MA',6,16,'Hiking','Summer'); INSERT INTO Trip VALUES (31,'Missisquoi River - VT','Lowell','VT',12,10,'Paddling','Summer'); INSERT INTO Trip VALUES (32,'Northern Forest Canoe Trail','Stark','NH',15,10,'Paddling','Summer'); INSERT INTO Trip VALUES (33,'Park Loop Ride','Mount Desert Island','ME',27,8,'Biking','Late Spring'); INSERT INTO Trip VALUES (34,'Pontook Reservoir Tour','Dummer','NH',15,14,'Paddling','Late Spring'); INSERT INTO Trip VALUES (35,'Pisgah State Park Ride','Northborough','NH',12,10,'Biking','Summer'); INSERT INTO Trip VALUES (36,'Pondicherry Trail Ride','White Mountains','NH',15,16,'Biking','Late Spring'); INSERT INTO Trip VALUES (37,'Seal Beach Harbor','Bar Harbor','ME',5,16,'Hiking','Early Spring'); INSERT INTO Trip VALUES (38,'Sawyer River Ride','Mount Carrigain','NH',10,18,'Biking','Early Fall'); INSERT INTO Trip VALUES (39,'Welch and Dickey Mountains Hike','Thorton','NH',5,10,'Hiking','Summer'); INSERT INTO Trip VALUES (40,'Wachusett Mountain','Princeton','MA',8,8,'Hiking','Early Spring'); INSERT INTO Trip VALUES (41,'Westfield River Loop','Fort Fairfield','ME',20,10,'Biking','Late Spring'); INSERT INTO TripGuides VALUES (1,'GZ01'); INSERT INTO TripGuides VALUES (1,'RH01'); INSERT INTO TripGuides VALUES (2,'AM01'); INSERT INTO TripGuides VALUES (2,'SL01'); INSERT INTO TripGuides VALUES (3,'SL01'); INSERT INTO TripGuides VALUES (4,'BR01'); INSERT INTO TripGuides VALUES (4,'GZ01'); INSERT INTO TripGuides VALUES (5,'KS01'); INSERT INTO TripGuides VALUES (5,'UG01'); INSERT INTO TripGuides VALUES (6,'RH01'); INSERT INTO TripGuides VALUES (7,'SL01'); INSERT INTO TripGuides VALUES (8,'BR01'); INSERT INTO TripGuides VALUES (9,'BR01'); INSERT INTO TripGuides VALUES (10,'GZ01'); INSERT INTO TripGuides VALUES (11,'DH01'); INSERT INTO TripGuides VALUES (11,'KS01'); INSERT INTO TripGuides VALUES (11,'UG01'); INSERT INTO TripGuides VALUES (12,'BR01'); INSERT INTO TripGuides VALUES (13,'RH01'); INSERT INTO TripGuides VALUES (14,'KS02'); INSERT INTO TripGuides VALUES (15,'GZ01'); INSERT INTO TripGuides VALUES (16,'KS02'); INSERT INTO TripGuides VALUES (17,'RH01'); INSERT INTO TripGuides VALUES (18,'KS02'); INSERT INTO TripGuides VALUES (19,'DH01'); INSERT INTO TripGuides VALUES (20,'SL01'); INSERT INTO TripGuides VALUES (21,'AM01'); INSERT INTO TripGuides VALUES (22,'UG01'); INSERT INTO TripGuides VALUES (23,'DH01'); INSERT INTO TripGuides VALUES (23,'SL01'); INSERT INTO TripGuides VALUES (24,'BR01'); INSERT INTO TripGuides VALUES (25,'BR01'); INSERT INTO TripGuides VALUES (26,'GZ01'); INSERT INTO TripGuides VALUES (27,'GZ01'); INSERT INTO TripGuides VALUES (28,'BR01'); INSERT INTO TripGuides VALUES (29,'DH01'); INSERT INTO TripGuides VALUES (30,'AM01'); INSERT INTO TripGuides VALUES (31,'SL01'); INSERT INTO TripGuides VALUES (32,'KS01'); INSERT INTO TripGuides VALUES (33,'UG01'); INSERT INTO TripGuides VALUES (34,'KS01'); INSERT INTO TripGuides VALUES (35,'GZ01'); INSERT INTO TripGuides VALUES (36,'KS02'); INSERT INTO TripGuides VALUES (37,'RH01'); INSERT INTO TripGuides VALUES (38,'KS02'); INSERT INTO TripGuides VALUES (39,'BR01'); INSERT INTO TripGuides VALUES (40,'DH01'); INSERT INTO TripGuides VALUES (41,'BR01');