User Account

All Pages

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?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  1.what is the value of the following instruction?

1.What is the value of the following instruction? mov al,01101011b shr al,22.What is the two's complement of the binary number 11010000?3.Which statement defines an array local variable consisting 40 signed words?

  Floating point format has an n-bit frac field

Suppose a floating point format has an n-bit frac field and a k bit exp field. What is the smallest integer that can be represented exactly? Assume that k is large enough not to provide any limitations on the problem. What is the integer for IEEE-754..

  Names for a base class

What is a base class? And what are the other names for a base class? Should common functionality be put in the base class? Why or why not?

  Locate vendors of biometric products

Using the Web, locate vendors of biometric products. Find one vendor with a product designed to examine each characteristic mentioned in your textbook. What is the CER associated with each product? Which would be more acceptable to users? Which..

  What is your best guess as to the number of red balls in urn

An urn contains an unknown number of red balls, and 10 balls total. You draw 100 balls, with replacement; 42 are red. What is your best guess as to the number of red balls in the urn?

  Should the company purchase or lease the car

Use an interest rate of 10% per year and annual worth analysis.

  Write a java program that produces a simple formatted report

For this lab you will write a Java program that produces a simple formatted report. The program will prompt the user to enter a file name. This file must contain information in a specific format (detailed below).

  Determine the eigenvalues

How to determine the eigenvalues  of L(P) in the following stages :  - determine the eigenvalues of Kn

  Limitations of digital subscriber line

Part 1: What are some limitations of Digital subscriber line (DSL) technology? Part 2: What are some examples of improvements of asymmetric digital subscriber line 2 (ADSL2) beyond regular DSL?

  A function in two different classes and implemented in c++

Is it possible that a function is friend of two different classes

  Discuss the concept of polymorphism/operator overloading

What is the difference between persistent and transient objects? How is persistence handled in typical 00 database systems?

  Assignment-cloud computing slide presentation

Image that you are a member of a development team that is creating a large and important web-based application. This application is critical to the company and must be available 24 hours per day.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd