Q2) Consider you have the airport database with the following relations, where the primary keys are underlined: Airplane(plane-code, model, manufacturer, airlines, capacity) Flight(flight-No., plane-code, flight-date, flight-duration, distination-city, airport) Answer the following SQL commands: 1- Increase the capacity of airplanes that manufactured by Boeing by 4. 2- Delete the flights of Heathrow airport to Moscow. 3- Add new two records to airport table. 4- Remove the airplanes that has code between 456 and 987 and has capacity more than 150. 5- Remove the attribute model from the airplane table.

Q2) Consider you have the airport database with the following relations, where the primary keys are underlined: Airplane(plane-code, model, manufacturer, airlines, capacity) Flight(flight-No., plane-code, flight-date, flight-duration, distination-city, airport) Answer the following SQL commands: 1- Increase the capacity of airplanes that manufactured by Boeing by 4. 2- Delete the flights of Heathrow airport to Moscow. 3- Add new two records to airport table. 4- Remove the airplanes that has code between 456 and 987 and has capacity more than 150. 5- Remove the attribute model from the airplane table.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Q3) consider you have the Library database with the following relations, where the primary keys are underlined: Book (bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code) Library (library-name, address, no-of-sections, manager-name, library-code, country) Answer the following SQL queries: 4. Find the books names that have pages between 300 and 600. 5- Find the address and number of sections in the libraries of united states and order them by the manger name.
SQL Queries: Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id) Write SQL queries to answer the following questions: a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018. b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor). c.Find the name of the youngest donor and all the donations made in by that donor in 2020.
The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders(ordernum, orderdate, filled, custnum) orderline(ordernum, productnum, quantity, salesprice) product(productnum, descr, producttype, msrp, onhand) Here is a sample data (assume there are more records)Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions: 1a. What are the names and customer numbers of customers who are from Mississauga? 1b.What are the names of products (descry) and product types of products purchased by customers from brapton?
I need the answer as soon as possible
Please show all work and write it in PL/SQL and copypaste what you have.
Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market_name, city, street, fruit_name) 1- Find the names of all red fruits that has price less than 25 dinars. 2- Find the names of markets that sell banana in Atlanta city. 3- Find the name of fruits that has yellow color and sell in Glasgow market
Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1)List the name and the state of all United States airports. 2)List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 3)Display the number of all carriers and the average of their revenues. 4)Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017? Example: List all airport names. π name Airport More example provided it attached file.
Relational Algebra Questions:Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1. List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers. 4. List the carrier name, the carrierID, the flightNo and the date of all flights. 5. Display the number of airports. 6. Display the number of flights with distances longer than 3000 miles. 7. Display the number of all carriers and the average of their revenues. 8. Display the number of flights leaving from JFK and the total of their distances. 9. Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017?
Consider the following schema: Books(bookID, title, publisher, year, genre)Students(studentID, name, major, age)Borrows(bookID, studentID, date) Express the following queries in SQL. a) Print in descending order the names of all students who borrowed a book on April 1, 2021. b) Find the titles and publishers of all books in the Science Fiction genre that are borrowed by Cybersecurity students. c) Find the majors with average age greater than 20 years old.