Reference no: EM13950419
Premiere Products Database
Table: Rep
|
Rep_Num
|
Last_Name
|
First_Name
|
Street
|
City
|
State
|
Zip
|
Commission
|
Rate
|
|
20
|
Kaiser
|
Valerie
|
624 Randall
|
Grove
|
FL
|
33321
|
$20,542.50
|
0.05
|
|
35
|
Hull
|
Richard
|
532 Jackson
|
Sheldon
|
FL
|
33553
|
$39,216.00
|
0.07
|
|
65
|
Perez
|
Juan
|
1626 Taylor
|
Fillmore
|
FL
|
33336
|
$23,487.00
|
0.05
|
Table: Customer
|
Customer_Num
|
Customer_Name
|
Street
|
City
|
State
|
Zip
|
Balance
|
Credit_Limit
|
|
148
|
Al's Appliance and Sport
|
2837 Greenway
|
Filmore
|
FL
|
33336
|
$6,550.00
|
$7,500.00
|
|
282
|
Brookings Direct
|
3827 Devon
|
Grove
|
FL
|
33321
|
$431.50
|
$10,000.00
|
Table: Orders
|
Order_Num
|
Order_Date
|
Customer_Num
|
|
21608
|
10/20/2003
|
148
|
|
21610
|
10/20/2003
|
356
|
|
21613
|
10/21/2003
|
408
|
|
21614
|
10/21/2003
|
282
|
Table: Order_Line
|
Order_Num
|
Part_Num
|
Num_Ordered
|
Quoted_Price
|
|
21608
|
AT94
|
11
|
$21.95
|
|
21610
|
DR93
|
1
|
$495.00
|
|
21610
|
DW11
|
1
|
$399.99
|
|
21613
|
KL62
|
4
|
$329.95
|
|
21614
|
KT03
|
2
|
$595.00
|
Table: Part
|
Part_Num
|
Description
|
On_Hand
|
Class
|
Warehouse
|
Price
|
|
AT94
|
Iron
|
50
|
HW
|
3
|
$24.95
|
|
BV06
|
Home Gym
|
45
|
SG
|
2
|
$794.95
|
|
CD52
|
Microwave Oven
|
32
|
AP
|
1
|
$165.00
|
|
DL71
|
Cordless Drill
|
21
|
HW
|
3
|
$129.95
|
1. The following exercises are based on the Premiere Products database. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.
Part (PartNum, Description, OnHand, Class, Warehouse, Price,
(OrderNum, OrderDate, CustomerNum, CustomerName, RepNum,
LastName, FirstName, NumOrdered, QuotedPrice) )
2. List the functional dependencies in the following table that concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions. For a given invoice (identified by the InvoiceNum), there will be a single customer. The customer's number, name, and complete address appear on invoice, as does the date. Also, there may be several different parts appearing on the invoice. For each part that appears, display the part number, description, price, and number shipped. Each customer that orders a particular part pays the same price. Convert this table to an equivalent collection of tables that are in third normal form.
Invoice (InvoiceNum, CustomerNum, LastName, FirstName, Street, City, State, Zip, Date, (PartNum, Description, Price, NumShipped) )
|
What arguments most influenced your decision
: Based on what you have read, should we legalize the production of human clones? What arguments most influenced your decision? How would you explain your position to someone who disagrees with you
|
|
Variation with equivalence ratio of the equilibrium
: Using appropriate software, develop plots giving the variation with equivalence ratio of the equilibrium products of octane-air mixtures at 30 atm and selected temperatures ranging from 1700 to 2800 K.
|
|
Organization is planning to deploy sql server 2012
: Your organization is planning to deploy SQL Server 2012 on two (2) servers as a production database. You have been asked to outline the steps required to implement these servers into the existing network, with the knowledge that 500 users will be con..
|
|
Reasons for discrepancies and ssible mechanisms
: Discuss both the reasons for these discrepancies and ssible mechanisms by which such pollutants are formed in an actual engine. In a memorandum, summarize your findings and conclusions.
|
|
Determine the functional dependencies
: After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.
|
|
The u s continue on the path to bring liberty and freedom
: Due to our financial issues and social strains, is it prudent for the U.S. to continue with a policy of intervention with countries that are not a threat to us or should the U.S. continue on the path to bring liberty and freedom to all corners of the..
|
|
Maximum number of homogeneous phases
: 1. What is the maximum number of homogeneous phases that can exist at equilibrium for a system involving
|
|
Which policy should the government of togo choose
: Option B is to allow G and T to be determinedendogenously so as to hold the value of the interest rate constant. Which policy should thegovernment of Togo choose?To answer this question, first assume that Togo is struck by exogenous shocks to mone..
|
|
Describe a practical application or technology
: In order from the longest to the shortest wavelength, list component wavelengths of the electromagnetic spectrum. For each type of radiation, be sure to provide its name, wavelength range, and frequency range. Describe a practical application or te..
|