Answered You can hire a professional tutor to get the answer.
The following exercises are based on the Premiere Products database. Using your knowledge of Premiere Products, determine the functional dependencies...
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 followingtable. After determining the functional dependencies, convert this table to an equivalent collection of tables thatare 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 Productsis considering adding to its database), subject to the specified conditions. For a given invoice (identified bythe InvoiceNum), there will be a single customer. The customer’s number, name, and complete address appearon the invoice, as does the date. Also, there may be several different parts appearing on the invoice. For eachpart that appears, display the part number, description, price, and number shipped. Each customer that ordersa particular part pays the same price. Convert this table to an equivalent collection of tables that are in third normalform.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 partsare stored in each warehouse. In addition, Premiere Products now wants to manage information about the suppliersfrom which it purchases parts. For each part, Premiere Products needs to know the number and name ofeach supplier as well as the expected lead time for delivering each part. (Lead time is the amount of time a supplieris 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 unnormalizedrelation to fourth normal form:Part (PartNum, Description, Class, Price,(WarehouseNum, WarehouseName, OnHand),(SupplierNum, SupplierName, LeadTime) )
