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. Insert records to the Membership table for those customers who have purchased for more than $10000 before 03/01/2015 in the shop Apple Store. Set member type = regular member and date=03/01/2015.

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...

if last 4 digits of your student ID are 7281, then a = 7, b=2, c = 8, d = 1. Design an OFDM system with the following specifications: transmissions should be protected against multipath in a cell...

3. A 2-shell passes and 4-ube passes HX is used to heat glycerin from 20C to 40C by hot water which enters the thin-walled 2-cm diameter tubes at 90 C and leaves at 50 C. The total length of the...

Deals that do not result in the foreign investor's obtaining at least 10 percent of the shareholdings are classified as Blank______ investments. Multiple choice question. direct strategic portfolio...

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...

2. What recommendations would you have for using incentive programs at these agencies in the future?

1. Discuss why variable pay-for-performance plans have become popular and what elements are needed to make them successful.

2. What are some key performance indicators that are used by organizations in which you have been employed? How did managers explain the importance of these KPIs, and were any rewards tied to them?