Question: Please check these two image and solve problem 3. Urgently Problem No: 3 [4+4+4+4] The marketing manager for a computer products store has been using

 Please check these two image and solve problem 3. Urgently Problem

No: 3 [4+4+4+4] The marketing manager for a computer products store has

Please check these two image and solve problem 3. Urgently

Problem No: 3 [4+4+4+4] The marketing manager for a computer products store has been using a spreadsheet to keep track of special sales programs. This worked fine when the store was small. However, the store has been growing and has recently added some kiosks at local malls. The spreadsheet has also grown to include lots of redundancy. The columns of the spreadsheet are as follows: Store: the name of the store or kiosk, like Main or North Grand Mall Address (Addr): the address of the store Manager (Mgr): the manager of the store Manager Phone (MgrPh): the cell phone number of the manager Promotion Name (PName): the name of the promotional plan, like January White Sale Promotion Terms (PTerms): the terms of the promotion, like "buy a new computer, get a free soldering iron". Total Sales For Promotion (PTotal): the volume, in dollars, of products sold under a particular promotion at a particular store The terms in parentheses in the list above are abbreviations that you may choose to use in your solution to the problem. We'll treat this table as a single relation: Promotions(Store, Addr, Mgr. MgrPh, PName, PTerms, PTotal) The following assumptions hold: Al: Each store has just one manager, but one person may manage multiple stores. A2: Promotion names are not repeated A3: A promotion only has one set of terms Below are four functional dependencies for the Promotions relation. For each functional dependency answer the two associated questions. FD1: Store - Address, Manager Question 1: Why is FDI a functional dependency for the Promotions relation? Question 2: FDI violates third normal form (3NF) for the Promotions relation. What is it about FDI that violates 3NF? FD2: Manager ManagerPh Question 3: Why is FD2 a functional dependency for the Promotions relation? Question 4: FD2 violates 3NF for the Promotions relation. What is it about FD2 that violates 3NF? FD3: Promotion Name - Promotion Terms Question 5: Why is FD3 a functional dependency for the Promotions relation? Question 6: FD3 violates 3NF for the Promotions relation. What is it about FD3 that violates 3NF? FD4: Store, Promotion Name Total Sales For Promotion Question 7: Why is FD4 a functional dependency for the Promotions relation? Question 8: FD4 actually satisfies 3NF for the Promotions relation. Why does FD4 satisfy 3NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!