EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 16CATC
To determine
To mention whether total trip price field, which is calculated as total of trip price and other fees multiplies by the number of people taking the trip, should be present in reservation table or not.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
You will be using the Colonial Adventure Tours database. What is the average distance and average maximum group size for each type of trip?
create table queries using sinplified sales table
1. Which manufacturers are located in the city of New York? Show the manufacturer's name, state, postal code, and contact person.
2. Show product information for white shoes in the 'sneakers' category that cost more than $50 and have a product description that begins with the letter "b" or "t". Show only the product name, its composition, and its list price.
3. Show the product name, description, and category for all shoes with a list price of $150 or more and in one of the following categories: sneakers, boots, or sandals. Order the output alphabetically by product name.
4. How many customers do we have with a last name starting with a 'Q' living in each city? Your query should display two columns, one named cust_num and one named city. Sort the results alphabeticaly by city.
5. Show the product name, list price, customer state (call it 'CustState'), and manufacturer state (call it 'ManState') for all products made by manufacturers in…
Chapter 1 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Prob. 5RQCh. 1 - Prob. 6RQCh. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - Prob. 9RQCh. 1 - Prob. 10RQ
Ch. 1 - Prob. 11RQCh. 1 - Prob. 12RQCh. 1 - Prob. 13RQCh. 1 - Prob. 14RQCh. 1 - Prob. 15RQCh. 1 - Prob. 16RQCh. 1 - Prob. 17RQCh. 1 - Prob. 18RQCh. 1 - Prob. 19RQCh. 1 - Prob. 20RQCh. 1 - Prob. 21RQCh. 1 - Prob. 22RQCh. 1 - Prob. 23RQCh. 1 - Prob. 1TDECh. 1 - Prob. 2TDECh. 1 - Prob. 3TDECh. 1 - Prob. 4TDECh. 1 - Prob. 5TDECh. 1 - Prob. 6TDECh. 1 - Prob. 7TDECh. 1 - Prob. 8TDECh. 1 - Prob. 9TDECh. 1 - Prob. 10TDECh. 1 - Prob. 11TDECh. 1 - Prob. 12TDECh. 1 - Prob. 1CATCCh. 1 - Prob. 2CATCCh. 1 - Prob. 3CATCCh. 1 - Prob. 4CATCCh. 1 - Prob. 5CATCCh. 1 - Prob. 6CATCCh. 1 - Prob. 7CATCCh. 1 - Prob. 8CATCCh. 1 - Prob. 9CATCCh. 1 - Prob. 10CATCCh. 1 - Prob. 11CATCCh. 1 - Prob. 12CATCCh. 1 - Prob. 13CATCCh. 1 - Prob. 14CATCCh. 1 - Prob. 15CATCCh. 1 - Prob. 16CATCCh. 1 - Prob. 17CATCCh. 1 - Prob. 1SCGCCh. 1 - Prob. 2SCGCCh. 1 - Prob. 3SCGCCh. 1 - Prob. 4SCGCCh. 1 - Prob. 5SCGCCh. 1 - Prob. 6SCGCCh. 1 - Prob. 7SCGCCh. 1 - Prob. 8SCGCCh. 1 - Prob. 9SCGCCh. 1 - Prob. 10SCGCCh. 1 - Prob. 11SCGCCh. 1 - Prob. 12SCGC
Knowledge Booster
Similar questions
- Note that customerAge and productID are attribute name of the table ORDERS.arrow_forwardUse SQL and TAL Distributors database to complete the following questions:TAL Distributors is running a promotion that is valid for up to 20 days after an order is placed. List the order number, customer number, customer name, and the promotion date for each order. The promotion date is 20 days after the order was placed.arrow_forwardFor each different job_id group in the employee table, show the average salary and job_id for the group whose average salary is greater than 6000 and order records according the average salary attributearrow_forward
- In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.arrow_forwardChange to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productId in table customerOrder equals column id in table product) Update table customerOrder, set column orderStatelId equal to subquery a. (select column id from table orderstate where state equals “Payment received") Alter table customerPayment add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included) Insert into table customerPayment, columns customerOrderId and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query…arrow_forwardShow the list of students (all attributes) who were born after 2000-01-01 and are currently in Active status in the alphabetical order of the last and the first name. Hint: To calculate easily, always use the date format YYYY-MM-DDarrow_forward
- What are the customer IDs and names of all customers, along with the order IDs for all the orders they have placed?arrow_forwardList all products with their highest unit price, i.e. not discounted.the database isarrow_forwardThe Colonial Adventure Tours database will be used. How many bookings have a travel cost of more than $20 but less than $75?arrow_forward
- Show the average salary for each different job_id group in the employee tablearrow_forward7. For each project, display project name, project platform, project cost and total number of student involved. Label the columns as ProjectName, ProjectPlatform, ProjectCost and TotalStudentInvolved respectively. Order the query in ascending order by ProiectName. SQL statements:arrow_forwardCUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr