1. Convert the following relation into an equivalent collection of relations in 3^rd normal form (3NF) by indicating updated schema and records. The relation concerns tennis player information. The information listed on the players includes details about them and grand slam titles won. (30 points)

PLAYERS (PlayerID: char(4), FirstName: varchar(30), LastName: varchar(30),

Nationality: varchar(20), Gender: char(1), Age: numeric(3), (TitleID: numeric(2), TitleName: varchar(20), TourType: char(4), TourYear: numeric(4), Price: numeric(9,2)))

The following functional dependencies exist in the relation above.

• Playerid à Firstname, Lastname, Nationality, Gender, Age
• TitleID à TitleName, TourType, TourYear, Price
• PlayerID, TitleID à TourType, TourYear, Price

PLAYERS

PlayerID	FirstName	LastName	Nationality	Gender	Age	TitleID	TitleName	TourType	TourYear	Price
W100	Naomi	Osaka	Japanese	F	23	T001 T002	Australian Open US Open	WTA WTA	2019 2020	3,030,000.00 3,500,000.00
M101	Novak	Djokovic	Serbian	M	34	T002 T003	US Open Wimbledon	ATP ATP	2018 2021	3,500,000.00 2,400,000.00
W102	Iga	Swiatek	Polish	F	20	T004	French Open	WTA	2020	1,880,000.00
M103	Alexander	Zverev	German	M	24

 

Answer rating: 100% (QA)

1NF All attributes should be atomic PLAYERS PlayerlD FirstName LastName Natio... View the full answer