Use the following Database structure to answer questions. The PK in each table is labeled with...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following Database structure to answer questions. The PK in each table is labeled with a key icon. The tables are linked via the FK-PK relationship. 1 and infinity indicate 1 to many relationship. For each question, you have to select a single best answer. Customer Customer D LastName FirstName Age Gender Address City State Zip Phone Credit CardType Credit CardNumber ExpirationDate Booking Booking D Customer D GuidelD BookingDate Hours 00 BookingDetail DetaillD BookingID ProductID Guide GuidelD LastName FirstName Age Gender Address City State Zip Phone 00 Product ProductID ProdName Category Supplier D HourlyRate UnitsinStock Supplier Supplier D Company Address City State Zip Phone Question 1 We want to know how many bookings for each product. What tables will appear in the FROM clause of the query? BookingDetail, Product, Guide BookingDetail, Product, Guide, Supplier Customer, Booking Detail, Product O O BookingDetail, Product Question 2 We want to know how many bookings for each product. How many conditions appear in the WHERE clause? 2 T 1 pts A 1 pts Question 3 We want to know how many bookings for each customer who is female. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Customer, Booking, Product O BookingDetail, Booking, Customer Question 4 O Customer, Booking We want to know how many bookings for each customer who is female. How many conditions appear in the WHERE clause? 2 3 1 pts 4 1 1 pts Question 5 We want to list all female guides whose trips have been booked more than 5 times. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Booking Details, Booking, Guide O Customer, Guide Question 6 O Guide, Booking We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the WHERE clause? 4 2 1 pts 3 1 1 pts Question 7 We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the HAVING clause? Question 8 2 We are interested in: for each supplier, how many customers are located in same city (Assuming the city attribute is enough to differentiate one city from another). How many tables do we need for this query? O O 2 1 pts 4 1 pts Question 9 We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). How many conditions appear in the WHERE clause? 3 N 1 Question 10 group by CustomerID We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). Which condition will appear in the GROUP BY clause? group by City 1 pts group by ProductID group by Supplier D 1 pts Use the following Database structure to answer questions. The PK in each table is labeled with a key icon. The tables are linked via the FK-PK relationship. 1 and infinity indicate 1 to many relationship. For each question, you have to select a single best answer. Customer Customer D LastName FirstName Age Gender Address City State Zip Phone Credit CardType Credit CardNumber ExpirationDate Booking Booking D Customer D GuidelD BookingDate Hours 00 BookingDetail DetaillD BookingID ProductID Guide GuidelD LastName FirstName Age Gender Address City State Zip Phone 00 Product ProductID ProdName Category Supplier D HourlyRate UnitsinStock Supplier Supplier D Company Address City State Zip Phone Question 1 We want to know how many bookings for each product. What tables will appear in the FROM clause of the query? BookingDetail, Product, Guide BookingDetail, Product, Guide, Supplier Customer, Booking Detail, Product O O BookingDetail, Product Question 2 We want to know how many bookings for each product. How many conditions appear in the WHERE clause? 2 T 1 pts A 1 pts Question 3 We want to know how many bookings for each customer who is female. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Customer, Booking, Product O BookingDetail, Booking, Customer Question 4 O Customer, Booking We want to know how many bookings for each customer who is female. How many conditions appear in the WHERE clause? 2 3 1 pts 4 1 1 pts Question 5 We want to list all female guides whose trips have been booked more than 5 times. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Booking Details, Booking, Guide O Customer, Guide Question 6 O Guide, Booking We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the WHERE clause? 4 2 1 pts 3 1 1 pts Question 7 We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the HAVING clause? Question 8 2 We are interested in: for each supplier, how many customers are located in same city (Assuming the city attribute is enough to differentiate one city from another). How many tables do we need for this query? O O 2 1 pts 4 1 pts Question 9 We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). How many conditions appear in the WHERE clause? 3 N 1 Question 10 group by CustomerID We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). Which condition will appear in the GROUP BY clause? group by City 1 pts group by ProductID group by Supplier D 1 pts
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 Question 1 Answer BookingDetail Product Explanation To know how many bookings for each product you would primarily consider two tables BookingDetail table It contains the ProductID an... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these programming questions
-
how can we test a class using junit 5 testing in Eclipse IDE . The class called read class has the following method LinkedListreadallquestions ( String CSVPath ) ; the CSV file has a 1 0 rows, 3...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
The normalization process was shown for just the BOOKS table. The other tables in the Just Lee Books database are shown after normalization. Because the database needs to contain data for each...
-
Calculate the heat required to raise 50 kg of solid sodium carbonate (Na2CO3) from 10C to 50C at 1atm using (a) The true heat capacity of Na2CO3, which is 1.14 kJ / (kg C). (b) A heat capacity...
-
Airflow at Ma = 2.2 takes a compression turn of 12° and then another turn of angle θ in Fig. P9.139. What is the maximum value of θ for the second shock to be attached? Will the two...
-
When a Cobb-Douglas function with at least two inputs shows the existence of constant returns to scale, it implies that the marginal product of each input is diminishing. True or false? Explain.
-
This assignment begins with a completed simulation of the toluene hydrodealkylation process in Figure 17.1 and involves the completion of an economic evaluation. Note that the simulation results for...
-
Accounting for Pollution Expenditure Counting Crows Company operates several plants at which limestone is processed into quicklime and hydrated lime. The Eagle Ridge plant, where most of the...
-
On April 30, 2025, the market price of Seabury Occupational Therapy, Inc.'s common stock was $13 per share and the company declared a 5% stock dividend. The stock was distributed on May 15. Read the...
-
The sector rotates with the indicated angular quantities about a fixed axis through point B. Simultaneously, the particle A moves in the curved slot with constant speed u relative to the sector....
-
Completely answer in three (3) paragraphs, with each paragraph containing no less than three (3) full and complete sentences, For Your Original response(s) to the following issues : 1. How does the...
-
How do urban planners and policymakers grapple with the challenges posed by rapid urbanization, such as infrastructural strain, housing shortages, and equitable access to resources and opportunities ?
-
Rinaldo informs you that the first transaction that you will have to record is a cash payment transaction. On May 1, 2017, Check No. 4041 was issued to 'Office Supplies Warehouse' for the cash...
-
A company has fixed costs of $10,000 and it profits $42,250 off of 2,750 items. Find the linear profit function, P(x) P(x) =
-
Short strangle options trading strategy consists of writing a call and a put option at different exercise prices. Construct a profit/loss diagram for this option strategy given the following...
-
identify an innovation or change in the Financial Services industry, which has changed the way the industry does business in this area of financial services
-
Normal functioning ovaries are seen in which of the following condition? a) Rokitansky-Kuster-Hauser syndrome b) Turner syndrome c) Sawyer syndrome d) Adnrogen insensitivity syndrome
-
Suppose the index goes to 18 percent in year 5. What is the effective cost of the unrestricted ARM?
-
What is the difference between reverse engineering and reengineering tools?
-
Change the discount rate for Problem and Exercise 5-35 to 10 percent and redo the analysis. Problem and Exercise 5-35. Consider your use of a PC at either home or work and list tangible benefits from...
-
Prepare a testing strategy or plan for PVFs Purchasing Fulfillment System.
-
Exercise 4.119 on page 303 revealed an association between owning a cat as a child and developing schizophrenia later in life. Many people enjoy cats as pets, so this conclusion has profound...
-
800 tests using a significance level of \(5 \%\). We are conducting many hypothesis tests to test a claim. In every case, assume that the null hypothesis is true. Approximately how many of the tests...
-
300 tests using a significance level of \(1 \%\). We are conducting many hypothesis tests to test a claim. In every case, assume that the null hypothesis is true. Approximately how many of the tests...
Study smarter with the SolutionInn App