Question

Assume that you have a football league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.

Answer 1

We would be creating a separate table for the agent where we would be specifying the name and other information about the agent and each agent will be provided with the unique ID that will be stored in the player table and there will be the primary key for the agents table and it will be the foreign key for the players table and by making use of the foreign key and primary key we can keep intact the referential integrity rule ll and by making two tables and linking them by using the keys we are making a task easier to normalize the data. in the place table we will be having the agent ID and using that ID we can refer to the agent table and get the agent details using that ID.