Reference no: EM13846400
Premiere Products Exercises: Relational Algebra
In the following exercises, you will use the data in the Premiere Products database. In each step, indicate how to use relational algebra to obtain the desired results.
1. List the number and name of all sales reps.
2. List all information from the Part table for part FD21.
3. List the order number, order date, customer number, and customer name for each order.
4. List the order number, order date, customer number, and customer name for each order placed by any customer represented by the sales rep whose last name is Kaiser.
5. List the number and date of all orders that were placed on 10/20/2013 or that were placed by a customer whose rep number is 20.
6. List the number and date of all orders that were placed on 10/20/2013 by a customer whose rep number is 20.
7. List the number and date of all orders that were placed on 10/20/2013 but not by a customer whose rep number is 20.
|
How long and at which setting it took to melt it
: Put about 1/4 teaspoon of salt by itself in the tin can and set over the burner, and assure that you have good ventilation
|
|
What is its dividend growth rate
: If the price of Hanbags Inc. stock is $43, its required return is 20% and the last dividend paid was $3, what is its dividend growth rate?
|
|
How your plan supports key objectives
: Virtual Organization: Riordan Manufacturing. How your plan supports key objectives
|
|
Coin collection contains
: Your coin collection contains 44 1952 silver dollars. If your grandparents purchased them for their face value when they were new, how much will your collection be worth when you retire in 2054, assuming they appreciate at an annual rate of 5.7 perce..
|
|
Premiere products exercises: relational algebra
: In the following exercises, you will use the data in the Premiere Products database. In each step, indicate how to use relational algebra to obtain the desired results.
|
|
Why assumption of normality about the distribution of wages
: What is the probability that a random sample of 49 different one-hour shopping periods will yield a sample mean between 441 and 446 shoppers and interpret your answer in words.
|
|
Provider database-ms access
: As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways ..
|
|
Identify the persuasive language and positioning
: Memo to the marketing staff regarding the company's introduction of a new diet supplement. identify the persuasive language and positioning needed to attract three different target audiences: Baby Boomers, Gen Xers, and Gen Y-ers
|
|
What is present value of your windfall-discount rate
: You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming you’re around to collect), 65 years from now. What is the present value of..
|