The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders (ordernum,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders (ordernum, orderdate, filled, custnum) orderline (ordernum, productnum, quantity, salesprice) product(productnum, descr, producttype, msrp, onhand) Here is a sample data (assume there are more records) customer orders orderline CustNum CustName City 3 Kent OrderNum ProductNum Quantity SalesPrice CreditLimit OrderNum OrderDate Filled CustNum 1 7 2 34.99 BURLINGTON 2000 105/09/1997 1 2 2 6 1 980 4 Moore BRAMPTON 1000 205/09/1997 1 9 3 4 5 Felipe MISSISSAUGA 4500 3 05/09/1997 0 16 25 6 4 1 1 44.95 7Khoury MISSISSAUGA 1000 401/10/1997 0 10 5 2 1 99.99 8Brant OAKVILLE 1500 508/10/1997 1 3 5 8 1 25.99 9 Wells BURLINGTON 0 619/10/1997 1 5 6 7 1 34.99 13 ronwood OAKVILLE 100 715/10/1997 1 5 7 3 1 299.99 14 Joe 15 Test22 16 Joe G. TORONTO TORONTO 4000 BRAMPTON 22 1000 817/10/1997 1 9 04/11/1997 8 8 2 1 99.99 1 9 9 5 2 29.99 10 06/11/1997 1 3 10 5 11 27.5 11/01/12/1997 0 7 11 3 12 04/12/1997 0 1 11 4 13 08/12/1997 0 6 11 5 4 1415/12/1997 0 15/17/12/1997 4 12 8 0 5 13 product 6 14 7 2 1 295 42 27.5 1 25.99 1 975 34.99 15 2 1 105 15 1 H 34.99 ProductNum Descr ProductType MSRP Onhand 1 Swiss army knife Sports 51.69 22 2 Electric heater Hardware 99.99 10 3 Snowboard Sports 4 Hockey stick 5 Snow shovel 6 Stove 7 Toaster 8Jumper cables Stest Sports Hardware Appliance 989.99 Appliance Hardware test 344.99 31.63 29.99 37 172 53 17 34.99 12 25.99 38 30 1 Using PROJECT, SELECT, and JOIN, write the sequence of operations to answer each of the following questions: 1a. What are the names and customer numbers of customers who are from Mississauga? 1b. What are the names of products (descry) and product types of products purchased by customers from Brampton? The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders (ordernum, orderdate, filled, custnum) orderline (ordernum, productnum, quantity, salesprice) product(productnum, descr, producttype, msrp, onhand) Here is a sample data (assume there are more records) customer orders orderline CustNum CustName City 3 Kent OrderNum ProductNum Quantity SalesPrice CreditLimit OrderNum OrderDate Filled CustNum 1 7 2 34.99 BURLINGTON 2000 105/09/1997 1 2 2 6 1 980 4 Moore BRAMPTON 1000 205/09/1997 1 9 3 4 5 Felipe MISSISSAUGA 4500 3 05/09/1997 0 16 25 6 4 1 1 44.95 7Khoury MISSISSAUGA 1000 401/10/1997 0 10 5 2 1 99.99 8Brant OAKVILLE 1500 508/10/1997 1 3 5 8 1 25.99 9 Wells BURLINGTON 0 619/10/1997 1 5 6 7 1 34.99 13 ronwood OAKVILLE 100 715/10/1997 1 5 7 3 1 299.99 14 Joe 15 Test22 16 Joe G. TORONTO TORONTO 4000 BRAMPTON 22 1000 817/10/1997 1 9 04/11/1997 8 8 2 1 99.99 1 9 9 5 2 29.99 10 06/11/1997 1 3 10 5 11 27.5 11/01/12/1997 0 7 11 3 12 04/12/1997 0 1 11 4 13 08/12/1997 0 6 11 5 4 1415/12/1997 0 15/17/12/1997 4 12 8 0 5 13 product 6 14 7 2 1 295 42 27.5 1 25.99 1 975 34.99 15 2 1 105 15 1 H 34.99 ProductNum Descr ProductType MSRP Onhand 1 Swiss army knife Sports 51.69 22 2 Electric heater Hardware 99.99 10 3 Snowboard Sports 4 Hockey stick 5 Snow shovel 6 Stove 7 Toaster 8Jumper cables Stest Sports Hardware Appliance 989.99 Appliance Hardware test 344.99 31.63 29.99 37 172 53 17 34.99 12 25.99 38 30 1 Using PROJECT, SELECT, and JOIN, write the sequence of operations to answer each of the following questions: 1a. What are the names and customer numbers of customers who are from Mississauga? 1b. What are the names of products (descry) and product types of products purchased by customers from Brampton?
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date:
Students also viewed these databases questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A section of a warehouse is 31 feet high. Boxes that are each two feet high are to be stacked in the warehouse. How many boxes can be stacked one on top of the other? O a. 29 O b. 33 O c. 62 O d. 15.5
-
Show that the approximation obtained from Rk,2 is the same as that given by the Composite Simpson's rule described in Theorem 4.4 with h = hk .
-
An equipment manufacturer currently produces 50,000 units a year. It buys a part for the equipment from an outside supplier at a price of $1.40 a unit. The company is thinking of producing the part...
-
Sample weight averages (in kilograms) for 10 males and 10 females are listed. Find the coefficient of variation for each of the two data sets. Then compare the results. Males 70 72 75 69 64 75 60 71...
-
Assume that you own 1,200 shares of $10 par value common stock and the company has a 5-for-1 stock split when the market price per share is $70. Required: a. How many shares of common stock will you...
-
Choose a product you buy on regular basis (something you buy more than 4x per year). Think about how the supply and demand changes based on things like seasons, price, advertising/media, etc. 1 -What...
-
1. A consumer consumes two commodities, x and y. The consumer has utility function U (x, y) = (x - A) y and faces the budget constraint pxx + pyy = m. The shift parameter A is age. a) Find the...
-
what is the difference between Network operating System and operating system? which software can i say is Network operating System?
-
a) How Distributed Operating System is better than Network Operating System? Provide valid reasons for it? b) Why Operating System Scheduling is important & what is the impact of dead lock on it?...
-
Describe two major advantages and two disadvantages of each: MS-DOS operating system: Windows operating system UNIX and Linux operating system Android operating system iOS operating system macOS...
-
what characteristics are common among operating systems? List types of operating systems, and examples of each. How does the device affect the functionality of an operating system?
-
What is an operating system? mention various operating systems and explain their characteristics, advantage an disadvantage ?
-
Read the article The Role of Emotional Abuse in the Eating Disorders: Implications for Treatment and write a paper on it
-
Describe the general ways that the revised Form 990, applicable for tax year 2008 and beyond, is different from previous versions.
-
Apple stock is selling for \($120\) per share. Call options with a \($117\) exercise price are priced at \($12.\) What is the intrinsic value of the option, and what is the time value?
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
-
Twitter is trading at \($34.50.\) Call options with a strike price of \($35\) are priced at \($2.30\) . What is the intrinsic value of the option, and what is the time value?
Study smarter with the SolutionInn App