Question: Create database in MySQL Workbench 8.0 CE called INFO2312 2. Use the data in the attached image and create these same tables in

Create database in MySQL Workbench 8.0 CE called "INFO2312"
2. Use the data in the attached image and create these same tables in SQL

3. Use the tables and run the queries to answer the following statements

a. Create table titled "dup_hotel" similar to "hotel", with their first and third columns
b. Added comment column to guest table
c. List full details of all hotels
d. List full details of all hotels located in London. Include the query and results in your assignment solution.
e. List the names and addresses of all guests in London, alphabetically ordered by name

4. Include screenshots of queries and results for the assignment solution

*EDIT* - Additional information/attachment/tables/figures: The additional information was the picture below vvvvvvvvvvvvvvv.

These are the tables you must input into SQL to complete the statements.

Hotel Table: hotelNo | H1 | H2 H3 | H4 | H5 R1 | R2 | R3 | R4 Room Table | roomNo | hotel No roomType | price | | Single | Double | Queen | King | hotel Name | Hyatt | Hilton | city | Paris | Paris | Grosvenor | London | Renaissance | London | Ritz-Carlton | Seoul | G1 | G2 Booking Table: 1 hotelNo I guest No dateFrom | H3 | G1 | 1-Jan-2016 H2 G2 | H3 | G2 | H4 | G1 | G3 | G4 H4 H1 H2 H3 Guest Table: + I guest No guestName 25-July-2018 | date To | 6-Jan-2016 | R4 2-Aug-2018 | R6 | 10-May-2017 | R5 | 1-May-2017 | 10-Dec-2016 | 15-Dec-2016 | R1 40 45 | 52 | 50 | + | John Smith Mary Kim Terry Brown | Michael Johnson | roomNo | I guestAddress | 111 Perthshire Rd. London | 456 Main St. Houston | 235 Holleman Dr. Paris | 980 Ball St. New York I +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Create the database CREATE DATABASE INFO2312 Use the database Create the tables based on the provide... View full answer

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

In this exercise we examine in detail how an instruction is executed in a single-cycle datapath. Problems in this exercise refer to a clock cycle in which the processor fetches the following...

What do the combined studies on heritability of intelligence indicate about the contribution of genetic factors to intelligence?

Pls help me with a solutions b. event c. experiment d. union a, intersection 10. It is a subset of the sample space. a. intersection b. event c. experiment d. union 11. It is composed of all outcomes...

Consider the following decompositions for the relation schema R of Exercise 15.24. Determine whether each decomposition has (1) the dependency preservation property, and (2) the lossless join...

When evaluating research reports in health care, a popular tool is the Assessment of Multiple Systematic Reviews (AMSTAR). AMSTAR, which incorporates 11 items (questions), has been widely accepted by...

A new method of evaluating health care research reports. When evaluating research reports in health care, a popular tool is the Assessment of Multiple Systematic Reviews (AMSTAR). AMSTAR, which...

Evaluating health care research reports. When evaluating research reports in health care, a popular tool is the Assessment of Multiple Systematic Reviews (AMSTAR). AMSTAR, which incorporates 11 items...

18. The results for a smaller-the-better saturated experimental design using an OA16 with 15 factors where the factors A, B, c, O are located in columns 1, 2, c, 15, respectively, are as follows: a....

Using the information provided in Exhibit 2; prepare the following statements in proper format including titles, and proper underlining: i) The detailed formal Cost of Goods Manufactured Statement...

Excel File Edit View Insert Format Tools Data Window Help 11 8 ) 75% Tue 10:23 AM QE AutoSave OFF A F ? C ... SMS310 Test 2 - Student File Final Home Insert Draw Page Layout Formulas Data Review View...

A developer filed a breach of contract action against a general contractor in federal district court. If the contract was breached, the general contractor believes the fault was that of the framing...

What would be the approximate current flow in a 120 volt circuit with a 400 watt toaster and an 800 watt microwave oven attached

n Suppose X1,..., X are n iid random variables from the cumulative distribution func- tion F(x). Let Y = X; for i = 1,..., n. We further know that X; and Y; have the same distribution. For 0.5

The following was posted 7:09 AM, MAY 4, 2020, by Fox Television Stations, updated AT 07:16AM, May 4, 2020. LITTLE ROCK, Ark. Walmart paid almost $180 million in cash bonuses to its hourly associates...

Q2. Build a circuit using OR gates, AND gates, and inverters that produces an output of 1 if a decimal digit, encoded using a binary coded decimal expansion, is divided by 3, and an output of...

Activator rod AB exerts on crank BCD a force P directed along line AB. Knowing that P must have a 100-N component perpendicular to arm BC of the crank, determine (a) The magnitude of the force P, (b)...

Describa la jerarqua de las necesidades de Abraham Maslow y ofrezca ejemplos de productos o servicios que podemos comprar para satisfacer cada nivel

For the following exercises, you do not use the Solmaris Condominium database. 1. The DBA asks for your help in planning the data archive for the following Solmaris Condominium database: Location...

For the following exercises, you will address problems and answer questions from the Solmaris Condominium Group staff. You do not use the Solmaris database for any of these exercises. 1. The log...

Toys Galore currently has a credit limit of $7,500. Because Toys Galore has an excellent credit rating, TAL Distributors is increasing the companys credit limit to $10,000. If you run the SQL query...

What is S2 in (7.3) for an SRS? How does it compare with the sample variance s2?

Consider a probability sample S of n observation units from a population U of N observation units. The weights are wi =1/i, where i is the probability that unit I is in the sample. Now let S2 be a...

Gnap (1995) conducted a survey on teacher workload which was used in Exercise 15 of Chapter 5. a. The original survey was intended as a one-stage cluster sample. What was the overall response rate?...