Consider a database with the following relations:Hotel(Hotel ID, H_Name, H_Address, H_City, Maximum_Capacity)Guest (Guest ID, G_Name, G_Address, G_City)Room (Hotel ID, Room Number, Type, Price_Per_Night)Booking (Guest ID, Hotel ID, Room Number, From_Date, To_Date,Number_of_Nights) Display available Hotels (by ID, Name, and address) in the City of Chicago with amaximum capacity of 1000 (included) and 1500 (included). Display the results inascending order with respect to the ID.

In this we have to connect 3 tables hotel, guest, booking by using join

Display available Hotels (by ID, Name, and address) in the City of Chicago with a maximum capacity of 1000 (included) and 1500 (included). Display the results in ascending order with respect to the ID.

Display available Hotels (by ID, Name, and address) in the City of Chicago with a maximum capacity of 1000 (included) and 1500 (included). Display the results in ascending order with respect to the ID.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Similar questions

Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
SQL DDL corresponding to this schema (i.e. the CREATE TABLE statements Database Schema:branch ( branch_name, branch_city, assets )customer ( ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( ID, loan_number )account ( account_number, branch_name, balance )depositor ( ID, account_number )
create a database using the following entites and attributes: taxi: (taxi_id PK, registration_no, taxi_model, taxi_year, taxi_type, status, driver_id FK); USER: (Usr_id PK, F_name, L_name, Contat_no, Gender, Address, Taxi_id FK); DRIVER: (Driver_id PK, F_name, L_name, Gender, Conatct_no, Rating, Age); TRIP_DETAILS: (Trip_id PK, Trip_date, Trip_amount, Driver_id FK, Usr_id FK, Taxi_id FK , Strt_time, End_time) BILL_DETAILS: (Bill_no PK, Bill_date, Advance_amount, Advance_amount, Total_amount, Usr_id FK, Trip_id FK (unique)) CUSTOMER_SERVICE: (Emp_id PK, F_name, L_name) FEEDBACK: (Fbk_id PK, Message, Email , Emp_id FK (unique), Usr_id FK , Trip_id FK) owns: (Owner_id PK, number of cars) OWNER_TAXI ( Owner_id PK(FK), Taxi_id PK(FK)); INDIVIDUAL (ssn PK, individual name, owner_id FK); TAXI_SERVICE_COMPANY( Tsc_id PK, Tsc_name, Owner_id FK); NOTE: pk= Primary key, fk= foreign key
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Question 1 A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The…
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
In a database, there are three different kinds of relationships: identifying, non-identifying, and generic?
Consider the following relational database schema: manages (employee_name: char (20), manager_name: char (20)) employee (employee_name: char (20), street: char (30), city: char(30)) works (employee_name: char (20), company name: char (15), salary: Integer) company (company_name: char(15), city: char(30)) Primary Keys are underlined. Foreign Keys are referenced to Primary keys using arrows. Write DDL SQL queries to create the 4 tables of this database. Do not forget to identify referential-integrity constraints that should hold and maintain .
Consider the following schema of hotel reservations database: Hotel (Hotel No, Name, City) Room (Room No, Hotel No, Type, Price) Booking (Hotel No, Guest No, Date From, Date_To, Room No) Guest (Guest_No, Name, City) Write RA queries for the following: a) Get the details (names and price) of all hotels in California. b) Get the average price of a room grouped by city. c) Find the hotel name and city of the hotel with the highest priced room. d) Get the hotel names and room numbers of any hotel rooms that have not been booked.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, CIT 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The…
Create a database 'XYZ_Company' with the following tables: Employees (name, id, position, team, department, team_leader) Administration (name, company_id, sector) Team Leader (name, id, department, team) Department_Head (name, id, department) Based on question 4, list the name, id, position of employees and their team leader's name where team is 'Microservices' and department is 'Engineering' Based on question 4, concat the Team Leader name and department Hea name by joining the two tables, name the column as "Department Info" and use the following format "Department head is and Team Leader is " where names are respectively of department Head name and team leader name

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Enhanced Discovering Computers 2017 (Shelly Cashm…

Computer Science

ISBN:

9781305657458

Author:

Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Enhanced Discovering Computers 2017 (Shelly Cashm…

Computer Science

ISBN:

9781305657458

Author:

Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS