Question

Discussion Topics:

Assume that you have a Saudi 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.  

Note:

Please I need a short answer only on paragraph.

Answer 1

Given, you have a saudi league player database, in that database you have players table with attributes (Name, age, position, ect.)

You need to add informations about player agents. So you have to use INSERT keyword to add such player agent's informations.

Attributes are the datatype assosiate with the column. You can represent agent information as attributes. For example if you need to fetch specific name (mike) from the players table, use the following code.

SELECT name from Saudi league payer

WHERE name = 'mike';