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...
-
List the errors you find in the following balance sheet. Prepare a corrected balance sheet. Labyrinth Services Co. Balance Sheet For the Year Ended August 31, 2014 Current assets: Current...
-
A 1000-Hz tone from a loudspeaker has an intensity level of 100 dB at a distance of 2.5 m. If the speaker is assumed to be a point source, how far from the speaker will the sound have intensity...
-
Investment bankers must investigate the firms whose securities they sell, simply because, if an issue is overvalued and suffers marked price declines after the issue, the banker will find it...
-
One of the most important operating expenses for the Olde Virginia Brick Company is natural gas, which is used to bake and dry the bricks. Natural gas prices have recently been quite volatile, now...
-
Your company is considering renting an electronic billboard in a stadium to advertise its product. The benefit of renting the billboard is increased sales revenue as a function of the amount of time...
-
Which series has the highest beta. BraveNewCoin Liquid Index for Bitcoin 1D BNC Trading Brave Ne Yellow Green Blue Orange
-
Jackson Corporation has negative 30,000 of accumulated EP and positive 40,000 of current EP. On June 1, Jackson Corporation distributes 40,000 to its shareholder Latoya. On August 1, Jackson...
-
You are a software engineer and you are asked to collect and model the requirements of a training center that offers a set of training courses. The system should save the information of the offered...
-
In America, a criminal trial jury maintains the right of jury nullification, declaring not-guilty despite evidence to the contrary due to disagreements with the law being applied in the case. It is...
-
!!!! 1. (01.03 MC) 01.03 Rational Functions Pre-Calculus v21 (GS) (C-HSPC 13) IS-ORG 243/Module 01: Functions What is the domain of the rational function f(x)=. O (x = R\x0) X* 5 (x R | x + 0,- 1,2)...
-
I'm looking for a short narrative ideas and short Documentary ideas for a video shoot for final project but i need the idea very easy to be able to do it. 2- Please submit either your screenplay for...
-
The Long Term Care Plus Company has two service departments actuarial and premium rating, and two operations departments marketing and sales. The distribution of each service department's efforts to...
-
Anumeticseres Determine $26 for the arithmetic series shown below. 7+ 10.5+14 + 17.5+ 21+....... 94.5 1319.5 98 1365 Question 3 (14.3 points) Arithmetic Series Find the sum of the finite arithmetic...
-
a. Why does the Wi-Fi Alliance release compatibility testing profiles in waves instead of combining the entire standards features initially? 27a1.) An 802.11ac Wi-Fi compatibility testing profile...
-
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.
-
When a product's cost is composed of both fixed and variable costs, what effect does the increase or decrease in production have on total unit cost?
-
Teague Corporation has the following long-term investments: 1. 60 percent of the common stock of Ariel Corporation 2. 13 percent of the common stock of Copper, Inc. 3. 50 percent of the nonvoting...
-
The stockholders equity section of Caritas Corporations balance sheet appeared as follows on December 31: Swanson Manufacturing Company owns 80 percent of Caritass voting stock and paid $11.20 per...
Study smarter with the SolutionInn App