Scenario:

Your team is part of the IT department at Gatorware Software and you have recently normalized two tables (no nulls or redundant data). Each table has been assigned a proper primary key as follows:

Customer Table Primary Key: CustID

Salesrep Table Primary Key: RepID

We also know that:

1. Wilma Flintstone handles customers 111, 222, and 333.
2. Fred Flintstone handles customers 444, 555, and 666.
3. Betty Rubble is a brand new sales representative and does not have any customers assigned yet.

Assignment#1 (5 points)

It has been decided that the data in the Customer and Salesrep tables will be linked together by copying one of the tables primary keys into the other table to act as a cross reference between the data in each table. You have two options:

1. Add a CustID column to the Salesrep table.
2. Add a RepID column to the Customer table.

Question#1 Which option do you pick to make sure you still have no redundant data (i.e. unnecessarily repeated data a.k.a multivalued entries) data in any of your tables? (2.5 points)

Answer :

Question#2 Why did you pick the option you did in Question#1? (2.5 points)

Answer :

Assignment#2 (5 points)

Question#1 -Does it matter from a normalization point of view that Betty Rubble does not have any customers? (2.5 points)

Answer :

Question#2 Does it matter from a normalization point of view that customers Jae Suk and Kindra Schuler do not have a sales representative assigned to them? (2.5 points)

Answer :