Question: A restaurant database has the following tables: Order(OrderID, DateTime, DeliveryType, Discount) Dish(DishID, Name, Type, Price) Order Dish(OrderID(FK), DishID(FK), Quantity) (a) Write an SQL query that

A restaurant database has the following tables: Order(OrderID, DateTime, DeliveryType, Discount) Dish(DishID, Name, Type, Price) Order Dish(OrderID(FK), DishID(FK), Quantity) (a) Write an SQL query that show dishes with type "Soup" and that between 5 and 10 euro. (5 marks) (b) Write an SQL query that calculates the total number of items (the sum of all quantities) in an order with OrderID 187. (6 marks) (c) Write an SQL query that shows details of Orders that have a dish named "Aromatic Duck" (7 marks) (d) Write an SQL query that removes all items of type "Beverage" from an Order with OrderID 251. (7 marks) Total (25 marks)

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!

Calculating by using queries 21? Updating records by using queries As you use a database and as it grows, you might discover that errors creep in or that some information becomes out of date. You can...

The assignment is designed to be done on your own. The assignment must be your own work, not copied from others or any other course, textbook, or website. If plagiarism is detected, appropriate...

IDS 410: Business Database Technology Lambs-Are-Us Restaurant IDS 410: Business Database Technology Spring 2017 Individual Assignment #1 (database analysis) E-R Modeling of Lambs-Are-Us Restaurant...

Database System Questions It should be noted that in these questions they are related to each other. AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers....

Detailed Specification: A web Application Design &Development for a fictional restaurant company known as London Restaurant. This coursework is to be carried out individually The London Restaurant...

Database System Questions It should be noted that in these questions they are related to each other AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All...

Using the project that you have been assigned for ( U - University Restaurant, U - University Library, Voting application ) , please do the following: 1 . Determine all the use cases of your...

Preface This is a fictional case study to serve as the basis for an educational service-development exercise. Even though the inspiration for features of the case can be mapped in part to the current...

Resources: Pastas R Us, Inc. Database & Microsoft Excel, Wk 1: Descriptive Statistics Analysis Assignment Purpose This assignment is intended to help you learn how to apply statistical methods when...

The supplies account for a company has a $1,000 debit balance at the beginning of the year. Supplies of $2,000 were purchased during the year and debited to the Supplies account. A December 31...

Richard ordered a coffee table that was a regular pentagon. Find the measure of an exterior angle of the table. (JUSTIFY)

Zor Corporation is deciding whether to pursue a restricted or relaxed working capital investment policy. The firm's annual sales are expected to total $ 3 , 6 0 0 , 0 0 0 ; its fixed assets turnover...

blossom inc. leases a piece of equipment to cullumber company on january 1 , 2 0 2 5 . the contract stipulates a lease term of 5 years, with equal annual rental.payments of $ 9 1 1 4 at the end of...

Explain the key areas in which service employees need training.

Understand the role of internal marketing and communications.

Know how to motivate and energize service employees so that they will deliver service excellence and productivity.