Reference no: EM13927529
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 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 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) )
|
Describe the steps of the scientific method earl utilized
: How would the scientific method help Earl create an experiment to determine which food sources made people sick
|
|
Is this an attractive industry to invest in
: Identify how each force impacts the trucking industry and Werner (www.werner.com) in particular. Is this an attractive industry to invest in?
|
|
Costs of all our managers and employees
: You should be concerned about the woes of all the employees on the recent hike in gas prices. The company has taken that issue sensitively upon speculation that it will not only increase the cost of operation but it will also increase the transpor..
|
|
Construct simulation to portray macrophage chasing bacteria
: Construct simulation in MATLAB to portray a macrophage chasing a bacteria as it diffuses away and ultimately catching it if:
|
|
Determine the functional dependencies
: 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 fo..
|
|
Unique and progressive organizational structure
: Starbucks Corporation has a very unique and progressive organizational structure. This product of decades of planning, tries and failures, and shrewd business sense has morphed a great deal throughout the corporation's relatively short history.
|
|
Exploit an emerging market opportunity
: 1) Which marketing system is another channel development in which two or more companies put together resources to exploit an emerging market opportunity?
|
|
Four different brands of a pain medication
: Four different brands of a pain medication used for chronic back ailments were tested to see if the number of side effects for each brand were the same. The table below lists the results of the reported number of side effects for each brand of pa..
|
|
List the components of porter competitive strategy
: Provide a brief description (definition) of these five sections and why they are important: Research and development, operations, logistics, human resource management, and information systems and technology.
|