After determining the functional dependencies convert this

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) )

Solution Preview :

Prepared by a verified Expert
Database Management System: After determining the functional dependencies convert this
Reference No:- TGS01259698

Now Priced at $30 (50% Discount)

Recommended (96%)

Rated (4.8/5)