Reference no: EM13327465
Relational Algebra
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)
CUSTOMER (CustID, FirstName, LastName, City, Phone, Email)
INVOICE (InvoiceNumber, CustID, Date)
INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity)
ITEM (ItemNumber, ItemName, UnitPrice)
When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead.
Provide relational algebra (NOT SQL) queries for the following:
a. List the first and last names of Customers who come from the City named Perth.
b. List the first and last names of customers who had transactions on 1st August 2012.
c. List the price of the item called "Back Scratcher"
d. List the first and last names of any customer who has purchased more than 10 "Back Scratchers" in a single transaction.
e. List the names and quantities of items purchased on 1st August 2012 by the customer Peter Griffin.
f. List the dates on which Peter Griffin made purchases.
g. List the first and last names of customers who have bought "Back Scratcher" or "Hair Remover"
h. List the first and last names of customers who have bought "Back Scratcher" but have not bought "Hair Remover"
i. List the first and last names of customers who have bought "Back Scratcher" and "Hair Remover"
j. List the first and last names of any customers who have bought all of the items. (This does not need to be as part of a single purchase).
|
What is the range of the baseball
: A baseball thrown off a pedestrian pathway, 36 m above the Erie Canal, What is the range of the baseball
|
|
Provide the sql to amend the original table design
: You have been given the following specifications of a simple database for a netball association that keeps record of players, teams and matches.
|
|
What is its recoil speed
: A .30-06 rifle fires a bullet with a mass of 10 g at a velocity of 800 m/s. If the rifle has a mass of 4 kg, what is its recoil speed
|
|
List the sales for each customer
: Each query is worth 2 marks. These tables exist in sphinx and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own account. If you do so, you should ensure that you copy the sample data in dtoohe..
|
|
Problem on relational algebra
: The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)
|
|
Define relational database design
: List the details of any works of art (including the Artist who created the work) that have more than one copy recorded in the database.
|
|
What is the volume of the liquid water
: A cube of ice, 27 cm on each side, is melted into a measuring cup. What is the volume of the liquid water
|
|
Determine what is x at the end of 10 years
: The present value of a payment of 60 at the end of 10 years and 40 at the end of 20 years is equal to 40. The present value of a perpetuity with payments of x at the end of each year is also 40.
|
|
If apple ipod only played itunes, and itunes only could be
: If Apple iPod only played iTunes, and iTunes only could be heard on the Apple iPod, could Apple price the technologically integrated bundle any way they wanted? If other electronic music can play on an iPod, what determines whether there are any limi..
|