Question

( HEY THERE my name is N I need new and unique answers, please. (Use your own words, don't copy and paste), Please Use your keyboard (Don't use handwriting)

((Thank you FOR YOUR HELP))

SUBJECT: IT-244: Introduction to Database

Q: 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.

Answer 1

we can add the attributes of 'Player agents' in the existing table or we can create other table.

Adding the attribute in existing table:

we can add the attributes of player agents in existing table as like the common atributes in that table.

Creating the new table or new entity:

• we can create the new table by adding the attributes of player agents in that table, and we need to specify the relationship between the tables.
• we should maintain a relationship between 'player' and 'player agents' tables by adding the primary key of player table in 'player agents' as foriegn key.
• player agents(player name) references player(name)
• foriegn key---->primary key.

As per my view, creating new entity is a best way to maintain consistency and good performance.

so please create New table or New entity