A.Write a SELECT statement to list each city and zip code in New York or Connecticut. Sort the result in ascending order by zip code.B.Write a SELECT statement to determine how many courses do not have prerequisite. tables.pdf4 / 580%+Student Banner databaseCOURSECOURSE_NO DESCRIPTION COST PREREQUISITE CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED_DATESTUDENTZ PHI ONSALUT FIRSTEMPLREGISTRATI CREATED BYSTUDELAST_ STREET_ACREATEMODIFIMODIFIENT IDATIONNAMENAMEDDRESSΟΥERON_DATED DATEED_BYD_DATEEENROLLMENT3STUDENT_I SECTION_I ENROLL_DAT FINAL_GRAD CREATED_B CREATED_DAT MODIFIED_B MODIFIED_DATDDEEYEYESECTIONSECTIO COURSE SECTIO START DATE LOCAT INSTRUCT CAPAC CREATE CREATEDN IDMODIFIE MODIFIEDD BYNON_NOTIMEIONOR_IDITYD BYDATEDATEZIPCODEZIPCITYSTATECREATED BYCREATED DATEMODIFIED BYMODIFIED DATEINSTRUCTORINSTRUCTO SALUTAT FIRST N LAST N STREET ADD ZI PHo CREATED CREATEDR IDMODIFIEMODIFIEDIONAMEAMERESSPNEBYDATED BYDATE4GRADESTUDENSECTIOGRA GRADE CODE OCC NUMERIC G COMME CREATE CREATED MODIFIE MODIFIEDT IDN IDDEURRENCERADENTSD BYDATED BYDATE2:10 PM2 Type here to search69°F5/5/20222...II

The Database is : Student Banne It has 7 Relations/Tables COURSE, STUDENT, ENROLLMENT, SECTION,…

A.Write a SELECT statement to list each city and zip code in New York or Connecticut. Sort the result in ascending order by zip code. B.Write a SELECT statement to determine how many courses do not have prerequisite.

A.Write a SELECT statement to list each city and zip code in New York or Connecticut. Sort the result in ascending order by zip code. B.Write a SELECT statement to determine how many courses do not have prerequisite.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
Open MS Access, create a database named “orderManagement” and perform the following task: - Create a table named “Employee” having the following structure. Field Name Date type employeeID Auto Number employeeLName Text employeeFName Text employeeAddress Text employeeHireDate Date/Time employeePHone Text Notes ✓ Set the field employeeID as the primary key. ✓ Set the Field Size field property of the fields employeeLName and employeeFName and employeeAddress to 50.
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);
create Database CTU_YOURICASNOGOUSE CTU_YOURICASNO;GOCREATE TABLE Course( CourseID int PRIMARY KEY, CourseName varchar(255), CourseDesc varchar(255),);CREATE TABLE Students( ICASNo int Primary Key, StudentName varchar (255)NOT NULL, StudentSurname varchar (255)NOT NULL, StudentContact varchar (255)NOT NULL, StudentEmail varchar(255)NOT NULL, HighSchoolAttended varchar(255)NOT NULL, courseID int,);CREATE TABLE Semester( SemesterID int Primary Key, SemesterStartDate varchar(255)NOT NULL, SemesterEndDate varchar(255)NOT NULL, ICASNo varchar(255),);CREATE TABLE Facilitator( FacilitatorID int Primary Key, FacilitatorName varchar(255) Not Null, FacilitatorContact varchar(255)Not Null, FacilitatorEmail varchar(255)Not Null, ICASNo varchar(255)Not Null, ); CREATE TABLE Module( ModuleID int Primary Key, ModuelName varchar(255)Not Null, ModuleDuration varchar(255)Not Null, FacilitatorID varchar(255)Not Null,); Using the…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of every passenger together with their flight number and the associated company. Retrieve all flights departed from all airports in London. Retrieve the ticket numbers…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers.4. Retrieve the flight number, departure and arrival airports of all British Airways.5. Retrieve the name of every passenger together with their…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers. Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: please if you could give all the sql statements needed i will appreciate that, and i promise to put thump up Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers.…
9. Create a table client master with the following field’s client_no, name, address1, address2, city, state, pin_code, remarks, and balance due and add the constraints? • Create a primary key constraint on the column client_no.? • create the following check constraints Data values being inserted into the column client_no must start with ‘c’. Data values being inserted into the column name should be allowed in upper case only? a) Insert five rows in the table client master? b) Show all rows of client master? c) Add a new column in your table : AGE ? d) Update the table client master ? e) Delete a row from client master where age is greater than 60?
ASAP!! Create a New ASP.NET MVC Web application. Create a New Database in App_Data FolderWPLTASKDB. Create Three Tables in your DatabaseCustomer ->ID (PK), Name, DOB,EmailProduct->Id(PK),Price, ExpiryDateOrder -> ID (PK), Date, CustomerIdOrderDetails - > OrderId(PK), ProductID(PK), OrderedQuantityCreate Three Controller in your Website,• Customer Controller your Application should be able to Add, Update, Delete and View All Customer • Product Controller your Application should be able to Add, Update, Delete and View AllProduct• Order Controller your Application should be able to Add, Update, Delete and View AllOrders.
Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date
Open MS Access, create a database named “orderManagement” and perform the following task: - Create a table named “Order” having the following structure. Field Name Date type orderID Auto Number customerID Number employeeID Number orderDate Date/Time orderAmount Currency Notes ✓ Set the field orderID as the primary key.