Question
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
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:
- Wilma Flintstone handles customers 111, 222, and 333.
- Fred Flintstone handles customers 444, 555, and 666.
- 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:
- Add a CustID column to the Salesrep table.
- 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 :
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started