Your team is part of the IT department at Gatorware Software and you have recently normalized...

 

Transcribed Image Text:

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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: RepID Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question #2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red): 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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: ReplD Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question#2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red): 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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: RepID Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question#2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red): 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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: RepID Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question #2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red): 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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: ReplD Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question#2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red): 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 CustID Customer First 111 Peter RepID 222 Ed 333 Vance 444 Tim 555 Alan 666 Krish 777 Jae 888 Kindra Last Turylo Goad Graham Mason Carter Mahadevan Salesrep Table Primary Key: RepID Salesrep First 1 Wilma Suk Schuler Last Flintstone Flintstone Rubble 2 Fred 3 Betty 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 table's 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. 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 (enter in red): Question#2 -Why did you pick the option you did in Question#1? (2.5 points) Answer (enter in red): 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 (enter in red): 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 (enter in red):

Answer rating: 100% (QA)

Answer Customer Table Primary ... View the full answer