(Answered) Consider the following database schemacustomer cid cname

Engineering

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 theinventory and in an order.

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

1. Find the name of the customers who bought ‘surface' on ‘01/21/2015' from shop ‘NYC Windows Store'.

2. Find the oldest customer who is either a member of ‘NYC Windows Store' or ‘LA Windows Store'.

3. Insert records to the Membership table for those customers who have purchased formore than $30000 before '04/01/2014' in the shop ‘NYC Windows Store'. Setmember type = ‘regular member' and date='04/01/2015'.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M92015186
Price:- $15

Verified Expert

Priced at $30 Now at $15, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Question suppose we have a message m 0101011010100001 to

Question : Suppose we have a message m = 0101011010100001 to be transmitted across a network and to protect it from errors, we use the CRC generator polynomial P(x) = x 7 +x 6 +x 2 +x. Answer the following: (a) What is t ...

Question imagine that you are hired as a cio of a quickly

Question: Imagine that you are hired as a CIO of a quickly growing retail chain with an online presence. You have growing transactional databases but want to build a business intelligence infrastructure. You also have va ...

Question suppose a problem can be solved with two different

Question : Suppose a problem can be solved with two different algorithms, A or B. Algorithm A has a time complexity of TA = 17n, and algorithm B has a time complexity of TB = 0.5n 2 . Give the range of n for which it is ...

State the required answer precisely and then provide proper

State the required answer precisely and then provide proper explanation. It is not enough to provide one- word or one-line answers. Provide examples and state precisely the meaning of the following features supported by ...

What is the supply curve how do you apply the law of supply

What is the supply curve, how do you apply the law of supply in economics?

After reading the article 10 techniques for gathering

After reading the article, 10 Techniques for Gathering Business Requirements, think about the following scenario and answer the questions provided. Wilmington University is implementing a mobile app where students are ab ...

Find example that shows ideas can have big consequences in

Find example that shows ideas can have big consequences in the world. Describe the problem and how the idea helped to solve the problem. Include references

Question standards and advantages and disadvantages of

Question: Standards and Advantages and Disadvantages of Standards" Please respond to the following: • From the e-Activity and the information provided by the IEEE 802.11 WLAN Working Group for Wireless Standards, assess ...

In the sans examples of policy the database access policy

In the SANS examples of policy, the database access policy states Database user names and passwords may be stored in a file separate from the executing body of the program's code. This file must not be world readable or ...

Question suppose a process ie parent forks a child process

Question : Suppose a process (i.e., parent) forks a child process using resource sharing such that the parent and child share all resources. Does this include the Process Control Block and memory space or does the child ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert