Draw an object model that shows the necessary data components of this system. If you make assumptions (which you should keep to an absolute minimum!), make sure to list them in detail

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A basketball league wants to keep track of its teams and players. For each team, they need to track the name, city, and the number of years the team has been in the league. A city can host multiple teams, but a team can only ever represent one city. They also wish to store the population of each city.

 

Multiple players play for each team (a new team might not yet have any players). For each player, the league wants to keep track of the first and last names, and the player’s jersey number. They only track the player’s most recent team – no historical data are stored. One and only one player on each team is designated the captain – this also needs to be stored.

 

Each team is owned by one or more owners. For each owner, they need to track to the first and last name, all of the owner’s phone numbers, and the percentage of the team that each owner owns. Owners can own more than one team at the same time.

 

At the end of the season, the league needs to publish a season-end report that lists every player on a roster at the end of the season, and every owner of every team. They also need to list the number of teams playing in each city.

 

 

Draw an object model that shows the necessary data components of this system. If you make assumptions (which you should keep to an absolute minimum!), make sure to list them in detail

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Top down approach design
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education