Question: Consider the following database schema: Customer ( cid , cname, phone, age) Order ( oid , date, total_price, cid, sid) Order_item ( coid , oid

Consider the following database schema:

Customer (cid, cname, phone, age) Order (oid, date, total_price, cid, sid) Order_item (coid, oid, quota) Inventory (coid, coname, amount, price, sid) Shop (sid, sname, revenue) Membership (cid, sid, date, type)

Primary key attributes are underlined. Note that coid is a unique id for commodities in the inventory and in an order.

Answer the following questions using QBE. Draw tables in your answer.

1. Find the name of the customers who bought macbook on 01/02/2015 from shop Apple Store.

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!

Consider the following database schema: Customer ( cid , cname, phone, age) Order ( oid , date, total_price, cid, sid) Order_item ( coid , oid , quota) Inventory ( coid , coname, amount, price, sid)...

Tool doesn't matter. Consider the following database schema (primary keys are underlined) and SQL queries: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo....

Question II-7. (3 points) Write an SQL query that returns the manufacturer for cars with low horsepower, meaning all its manufactured cars are less than 800 horsepower. When writing a query, write...

Question X. (4 points) Write a relational algebra expression for the cars that finished the race in a time smaller than all races average time, Instructions When writing a query, write the query in a...

I -2 (4 points) Write an SQL statement to add an attribute difficultyLevel to the relation raceLap . Add an attribute name to the relation race and set name, location to be a foreign key in the...

4. [20 Points] Exercise 6.5.1, parts: a, c, e, f on page 295 in the textbook, with details as follow. Consider the schema of the CED database introduced above in question 2 . Using SQL, express the...

Instructions When writing a query, write the query in a way that it would work over all possible database instances and not just for the given example instance! Consider the following database schema...

Consider the following database schema 5. (5 points) Consider the following database schema CarDesc (CarNo, Model, Color, Year) Review (Model, Review, Rating) Then consider the following views v, (N,...

Consider the following database schema used to track vehicular incidents. The database has been in use for several years and contains millions of entries. Primary keys are underlined and foreign keys...

For any set S in a metric space 1. int S is open. It is the largest open set in S. 2. is closed. It is the smallest closed set containing S.

In end-of-chapter exercise 6.10. we analyzed cases where the interest rates for borrowing and saving are different. Part of the reason they might be different is because of government policy. A....

Select all that apply Which of the following are reasons for receivables growth exceeding sales growth? Multiple select question. Deteriorating creditworthiness among existing customers. Selling more...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

9. Can allowing trainees to make errors in training be useful? Explain.

14. You have a one-day classroom experience in which you need to help a group of engineers and software programmers learn to become project managers. After training, they will have to manage some...

1. Using any source possible (magazines, journals, personal conversation with a trainer), find a description of a training program. Consider the learning process and the implications of the learning...