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
Premiere Products Database
Table: Rep
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) )
Computer Science Homework Solutions
#23454
Database Design: Normalization
See attach file for details and charts.
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 is this?
By OTA - Overall OTA Rating
Ramas Ramaswami, PhD - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$15.96)
Included in Download
- Plain text response
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Database Concept - Why is normalization important?
- What problems does redundancy in a database cause? - What problems does redundancy in a database cause?
- Is normalization more important than user needs? - Please explain to me weather or not normalization is more or less important than the end user's needs? Is this true is normalization less important than the user's needs or what?
- Database Normalization - Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply ...
- data - In your own words, explain the concept of normalization. What does normalization accomplish? What are the advantages of normalization? In general, how do you go about normalizing a relation?
