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

Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Computer Science provide SQL code (Use the EBOOKS database) When a course is offered in several sections taught by more than one instructor, students have the ability to choose an instructor, otherwise they have no choice. The deans of each college would like to know how many courses have only one section in the schedule, how many courses have more than 1 section, but taught by the same instructor, how many courses have sections taught by more than one instructor. Sort the results alphabetically by College ID as shown below: COLLEGE SINGLE_SECTION MULTISECTION_ONE_INSTRUCTOR MULTIPLE_INSTRUCTORS CAS 83 21 22 CED 76 8 39 COB 72 16 13
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
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.