Computers and Technology, 19.10.2021 09:40, 123martinnnnn

You are hired to create a database for managing the information about a local girl soccer league. This league has more than 20 teams. Each team has a name, base-location, and an email address as the contact. Each team has a manager and a coach. Each team has multiple players. A player has a jersey number in her team. But if she plays for another team later, her jersey number may be different. The league needs to keep track all players, including name, phone, DOB, address, and parent’s phone. The information about the game is also important to the league, such as teams played, game time, location and the scores. The league not only wants to know which team plays games, but also which player played at each game and her stats (such as playing-minutes, goal made, number of faults, etc.). The coach of team is usually appointed for 2-year term. The league needs to know when a coach is appointed, coach’s contact number, his/her profession, education degree received, etc., A coach may coach different teams at different time period. The information of manager of each team should be also stored in the database, including his/her contact info. A manger may also work for different teams at different time period. Each team has some helpers/assistants who are usually parents or volunteers from local communities. The league also needs to keep track their contact information. a. create an ER model for this database.
b. transform this ER model into a set of tables.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 14:00, michelle7511

Which database model is best used for data warehouse and data mining

Answers: 3

continue

Computers and Technology, 22.06.2019 23:30, kenken2583

Jaina and tomas are being considered as new tenants in an apartment. the landlord looks at their creditworthiness because he wants to be sure his new tenant pays the rent on time and in full. the table below summarizes the information that was on their applications. application information questions jaina tomas how many years have you had your job? 5 2 what is your monthly salary? $1,850 $2,500 how many credit cards do you have? 4 1 how much debt do you have? $13,000 $7,000 how many times were you late with payments on credit cards in the past year? 5 1 who will the landlord decide to be more creditworthy and why? tomas because the ratio of his debt to income is less. jaina because she has had her job longer, which makes her look more stable. jaina because she has more credit cards available to her. tomas because he makes more money per month.

Answers: 2

continue

Computers and Technology, 23.06.2019 18:30, DSUDLER5555

Write a program that prints the day number of the year, given the date in the form month-day-year. for example, if the input is 1-1-2006, the day number is 1; if the input is 12-25-2006, the day number is 359. the program should check for a leap year. a year is a leap year if it is divisible by 4, but not divisible by 100. for example, 1992 and 2008 are divisible by 4, but not by 100. a year that is divisible by 100 is a leap year if it is also divisible by 400. for example, 1600 and 2000 are divisible by 400. however, 1800 is not a leap year because 1800 is not divisible by 400.

Answers: 3

continue

Computers and Technology, 23.06.2019 19:00, jaymc1932

Whose task it is to ensure that the product flows logically from one step to another?

Answers: 3

continue

Do you know the correct answer?

You are hired to create a database for managing the information about a local girl soccer league. Th...