Help

Problem 7 (10 points): Assume that you are the commissioner of the International Ladies Football Association. Also assume that the London Robins went bankrupt, in 2010, after playing one year. While reviewing the company records you come across the team database which has the following fields. Table: RobinsDB Attribute Characteristics Players First Name Robins player's first name PlayersLastName (Primary key) Robins player's last (family) name PSSN Robins player's social security number Paddress Robins player's address PBD Robins player's birth date PSal Robins player's Salary Since the team is bankrupt, the RobinsDB table will NEVER have another record added to it. During a meeting with your database team, Phoebe Buffay questioned the uniqueness of the primary key in the RobinsDB table. Rachel Green explained that when the database was designed in 2020, the Robins had already gone bankrupt and the table could never have a record added to it. Since the family name was unique and it is illegal to use Social Security Number as the primary key, Rachel's team agreed that PlayersLastName would suffice as the primary key. Phoebe pointed out that even if there are no records ever added to this table, there is still a problem with Rachel's logic relating to the using PlayersLastName as the Primary Key. (a) What is the problem with the Rachel's logic? (3 points) (b) Create a unique primary key containing the attribute PlayersLastName that follows the definition of the term "key". You may add attributes to the table. Be very specific regarding the change you have made.(7 points)