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.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section: Chapter Questions

Problem 14SAT

See similar textbooks

Similar questions

The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.
Suppose we have a database for an university. The requirements are as follows: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. • Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s co-investigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. The FDs for the above requirements are given as, • PSSN →…
Suppose we have a relational database with five tables. table key Attributes S(sid, A) Sid T(tid, B) Tid U(uid, C) Uid R(sid, tid, D) sid, tid Q(tid, uid, E) tid, uid Here R implements a many-to-many relationship between the entities implemented with tables S and T, and Q implements a many-to-many relationship between the entities implemented with tables T and U. A. Write an SQL query that returns all records of the form sid, uid where sid is the key of an S- record and uid is the key of a U-record and these two records are related through the relations R and Q. Use SELECT and not SELECT DISTINCT in your query. B. Write an SQL query that returns records of the form A, C where the A-value is from an S- record and the C-value is from a U-record and these two records are related through the relations R and Q. Use SELECT and not SELECT DISTINCT in your query. C. Could one of your queries from parts (a) and (b) return more records than the other? If so, which one? Justify your answer. D.…
Suppose we have a relational database with five tables. table key Attributes S(sid, A) Sid T(tid, B) Tid U(uid, C) Uid R(sid, tid, D) sid, tid Q(tid, uid, E) tid, uid Here R implements a many-to-many relationship between the entities implemented with tables S and T, and Q implements a many-to-many relationship between the entities implemented with tables T and U. A. Write an SQL query that returns all records of the form sid, uid where sid is the key of an Srecord and uid is the key of a U-record and these two records are related through the relations R and Q. Use SELECT and not SELECT DISTINCT in your query. B. Write an SQL query that returns records of the form A, C where the A-value is from an Srecord and the C-value is from a U-record and these two records are related through the relations R and Q. Use SELECT and not SELECT DISTINCT in your query. C. Could one of your queries from parts (a) and (b) return…
Give a relational database schema for the following: EMPLOYEE (Fname, Minit, Lname, SSN, Bdate, Address, Sex, Salary, Super_ssn, Dno) PK= Ssn FK= Super_ssn DEPARTMENT ( Dnamc, Dnumbcr, Mgr_ssn, Mgr_start_datc) PK= Dnumbcr FK= Dno DEPT_LOCATIONS (Dnumber, Dlocation) PK= Dnumber FK= Dnumbcr PROJECT (Pname, Pnumber, Plocation, Dnum) PK= Pnumber FK= Pno WORKS_ON (Essn, Pno, Hours) PK= Pno FK= ssn DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship) PK= Essn FK= Ssn
Take, for example, a database that is used by a large airline and in which the underlying database management system utilises snapshot isolation. In spite of the fact that the airline would prefer a serializable execution, it could be ready to tolerate a non serializable execution if it means that the process would be completed more quickly overall.
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. Design an Entity-Relationship diagram for the above environment. Please indicate Cardinality Constraints and Participation Constraints
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. Design an Entity-Relationship diagram for the above environment.
Imagine a database that stores records of what students are enrolled in what class, and what teachers are teaching those class. Just in words, Give an example of one to one relationship in the context of a student class database.
Take a database, having FDs as: DOB->Age; Age->Eligibility; Name->RollNo; RollNo->Name; CourseNo->CourseName; CourseNo->Teacher; (RollNo, CourseName)->Marks. The relation (RollNo, Name, DOB, Age) is in which Normal Form?

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

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

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

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