Solution-Primary key attributes are underlined

Primary key attributes are underlined

Assignment Help Basic Computer Science

Reference no: EM131260402

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

Reference no: EM131260402

Questions Cloud

What development nightmare did you see in sauper documentary : Considering Moss' "narrowest economic definition" of development, what "development nightmares" did you see in Sauper's documentary? Please explain.

Find the branch impedances and generate an input file : EEL 5250 Power Systems Analysis Homework. Use MATPOWER to conduct power flow calculation for the study system described. You can assume that Sb = 1 MVA. The line admittance for every line is zl = 0.0099 + j0.099 pu. Find the branch impedances and gen..

Name of the linux distribution : 1. What is the name of the Linux distribution that is supported by Red Hat Linux, but is considered open source and can be downloaded and used without charge?

What is the setup cost based on the desired lot size : What is the setup cost, based on the desired lot size? - What is the setup time, based on $40 per hour setup labor?

Primary key attributes are underlined : 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.

Most important categories of internal control procedures : Which one of the following is considered one of the six most important categories of internal control procedures?

Advanced tax-transfer taxes and wealth planning : Billy is a single individual who possess a life insurance policy worth $300,000 that will pay his 2 friends $800,000 upon his death. This year, Billy transfered the policy and all incidents of ownership to an irrevocable trust that pays income annual..

Discuss relativism with your classmates in general : What are some relativistic beliefs that you have or that you find in society? What are those ethical beliefs and how do people justify those beliefs? Using the articles from Mary Midgley (see also Rachels' and Goodman's articles from the recomme..

List and discuss android devices location sensors : Q1. List and Discuss Android devices location sensors. Q2. What are Adapters in android, explain different adapter views?

User Account

All Pages

Primary key attributes are underlined

Reference no: EM131260402

Reference no: EM131260402

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT