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:

A1: 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

1. Give an example of insertion anomaly in this table.
2. Go through the Normalization process and transform the above table into tables that are in 3NF. For full credit complete the following tasks:
3. Identify the functional dependencies
4. Transform the table Promotionsin 1NF relation(s)
5. Transform the resulting relation(s) in 2NF
6. Transform the resulting relation(s) in 3NF

The final relations should have meaningful names, Primary keys and Foreign Keys should be properly identified.

1. (5 points) Data mining and applications

1. Describe in your own words what is data mining.
2. List two reasons why data mining is popular now and it wasn't as popular 20 years ago.
3. Give a practical (real life) example of a data mining task.

Please answer this the assignment is due is 5 hours