Question

( HEY THERE my name is N I need new and unique answers, please. (Use your...

( 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.

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
( HEY THERE my name is T I need new and unique answers, please. (Use your...
( HEY THERE my name is T 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...
Assume that you have a Saudi football league player database. In this database, you have a...
Assume that you have a Saudi 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.
I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
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.. HCM102 Based on the overview, developed after finishing chapter one (Introduction of Organizational Behavior), explain why learning of organization behavior is important for public health students?
(My Name is AA please I need new and unique answers, please. (Use your own words,...
(My Name is AA please 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: System analysis and design IT243 Q1: As the project sponsor, you suggested that your company that runs multiple local supermarkets should provide an online shopping service to increase sales during COVID-19 pandemic. Write a system request to propose this project. System request Project Sponsor Business Need Business...
Discussion Topics: Assume that you have a Saudi league player database. In this database, you have...
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.
I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
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.. HCI213 Q: Demonstrate how electronic claims such as EDI works during insurance processing in the healthcare system ? I need new and unique answers, please. (Use your own words, don't copy and paste),
I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
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.. PHC311 Q:"WAS THE INDUSTRIAL REVOLUTION A PUBLIC HEALTH DISASTER OR BOON?" DISCUSS ( 250words)
I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
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.. PHC214 Demonstrate the importance of improving interprofessional teamwork in healthcare.( i need 250 words please)
Please Use your keyboard (Don't use handwriting) Thank you.. I need new and unique answers, please....
Please Use your keyboard (Don't use handwriting) Thank you.. I need new and unique answers, please. (Use your own words, don't copy and paste) HCI 112 Questions: demonstrate the impact of computerized provider order entry systems on the clinical workflow.
I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
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.. PHC131 Q) Smoking causes Lung Cancer" Discuss based on Hill's criteria? (250 words)
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • A gigantic warehouse stores approximately 40 million empty aluminum beer and soda cans.​ Recently, a fire...
    asked 15 minutes ago
  • 5. There are many complaints from passengers about the late running of buses on a particular...
    asked 19 minutes ago
  • (1 point) A survey of 1780 people who took trips revealed that 117 of them included...
    asked 24 minutes ago
  • Implement the following circuit to test the characteristics of a D flip flop. Note: Using a...
    asked 27 minutes ago
  • Next, suppose you add the unemployment rate, as a variable, to the regression model above and...
    asked 29 minutes ago
  • In a recent random sample, where 600 adults were surveyed, 16.4% indicate that they have fallen...
    asked 31 minutes ago
  • Suppose that you estimate the following regression: SALES = 5.467-1.034(PRICE) A) How do you interpret the...
    asked 36 minutes ago
  • Consider the following scenario: An industrial seller of grass seeds packages its product in 50-pound bags....
    asked 39 minutes ago
  • ​(Bond valuationlong dash—zero coupon​) The Latham Corporation is planning on issuing bonds that pay no interest...
    asked 55 minutes ago
  • The article “Doctors Cite Burnout in Mistakes” reported that doctors completing residency have financial struggles that...
    asked 58 minutes ago
  • The frame for an education survey includes 2000 high schools, each of which contain 1000 students....
    asked 1 hour ago
  • Professor Gersch grades his midterms and then takes a sample of eight tests and notices their...
    asked 1 hour ago