Premiere Products Exercise Chapter 5 solution correct answers
- Vpqnrqhwk
- Rating : 40
- Grade : A+
- Questions : 2
- Solutions : 1079
- Blog : 0
- Earned : $19352.58
Premiere Products Exercise Chapter 5 solution correct answers
11. Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household.
Patient (HouseholdNum, HouseholdName, Street, City, State, Zip,
Balance, PatientNum, PatientName, (ServiceCode, Description,
Fee, Date) )
The following dependencies exist in the Patient table:
PatientNum → HouseholdNum, HouseholdName, Street, City, State,
Zip, Balance, PatientName
HouseholdNum → HouseholdName, Street, City, State, Zip, Balance
ServiceCode → Description, Fee
PatientNum, ServiceCode → Date
1. 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))
Dependencies:
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 the 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))
3. The requirements for Premiere Products have changed. A number and a name now identify each warehouse. Units of each part may be stored in multiple warehouses, and it is important to know precisely how many parts are stored in each warehouse. In addition, Premiere Products now wants to manage information about the suppliers from which it purchases parts. For each part, Premiere Products needs to know the number and name of each supplier as well as the expected lead time for delivering each part. (Lead time is the amount of time a supplier is expected to take to deliver the part after Premiere Products has ordered it.) Each part can have many suppliers, and each supplier can supply many parts. Using this information, convert the following unnormalized relation to fourth normal form:
Part (PartNum, Description, Class, Price,
(WarehouseNum, Warehousename, OnHand),
(SupplierNum, Suppliername, LeadTime))
[Solved] Premiere Products Exercise Chapter 5 solution correct answers
- This Solution has been Purchased 1 time
- Submitted On 13 Jul, 2015 11:19:08
- Vpqnrqhwk
- Rating : 40
- Grade : A+
- Questions : 2
- Solutions : 1079
- Blog : 0
- Earned : $19352.58
Premiere Products Exercise Chapter 5 | Complete Solution
The following exercises are based on the Premiere Products database.
1. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functio...
Premiere Products Exercise Chapter 4 | First 10 questions solved
This Tutorial is rated A+ previously,if you have any questions regarding this tutorial than you can contact me.
...Premiere Products Exercise Chapter 2 | Complete Solution
In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the Premiere Products database so you will still ha...
Premiere Products Exercise Chapter 1 | Complete Solution
Communication time = access delay +(data volume / transmission rate)
Communication time = 2.5 + (5000 * 1000 /50000)
= 2.5 + (5000000/50000)
= 2.5 + (100) =&nbs...
Premiere Products Exercise Chapter 9 | Complete Solution
1. Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customersof rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named CustomerRep65. (Include ...