Scenario:

Your team is part of the IT department at GRC 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.

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:

a) Add a CustID column to the Salesrep table.

b) Add a RepID column to the Customer table.

Questions 1-4

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?

Your Answer:

2. Why did you pick the option you did in Question#1?

Your Answer:

3. Does it matter from a normalization point of view that Betty Rubble does not have

any customers?

Your Answer:

4. 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?

Your Answer:

Customer CustID First 111 Peter 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Suk Schuler