Question: Database Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum,

Database Problem 4: SQL Queries (30 pts) Consider the following relations.

The primary keys are underlined while the foreign keys are in italic.

Database

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type, View, Price) Booking (ID, HNum, GHum, RNum, DateFrom, Date To) Guest (GNum, Fname, Lname, Gender, DOB, City) Write the corresponding SQL queries for the below questions 6. Write an SQL query to show all hotels along with the number of booking in there. Page 7 of 8 CSCI335 Fina 2021 - 2022 7. List the name of guests whose last name contains 'a' 8. List the names of hotels who has no booking in them 9. Find the room number with no booking. 10. Find the highest price and average price of room

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type,...

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, H Num, Type, View,...

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type, View,...

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. User (UId, Username, Password, Profile, Brief, Joindate) Post...

Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type, View, Price) Booking (ID, HNum, GHum,...

Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum , HNum , Type, View, Price) Booking ( ID , HNum, GHum,...

XYZ Corporation is considering purchasing a new piece of equipment for its manufacturing process. The equipment has a purchase price of $200,000 and is expected to have a useful life of 5 years. The...

Introducing a new product requires an immediate investment in plant facilities of $180 000 with a disposal value of $45 000 after seven years. The facilities will require additional capital outlays...

19. Alcohols are an homologous series of organic chemical compounds The table shows some information about different alcohols. (a) What is meant by the term homologous series? [3] (b) (i) Estimate...

Bill sells stock that he bought three years ago for a $ 3 , 0 0 0 loss. He also sells his personal automobile for $ 1 0 , 0 0 0 less than he paid for it . Bill's taxable income before taking into...

KEY QUESTION Suppose a pure monopolist is faced with the demand schedule shown below and the same cost data as the competitive producer discussed in question 4 at the end of Chapter

KEY QUESTION Use the following demand schedule to determine total revenue and marginal revenue for each possible level of sales: a. What can you conclude about the structure of the industry in which...

KEY QUESTION Using diagrams for both the industry and a representative firm, illustrate competitive long-run equilibrium. Assuming constant costs, employ these diagrams to show how ( a ) an increase...