Description
hello i need help with my project its simple and easy to implement. all the details are attached in files.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Running Head: VOLLEYBALL LEAGUE
1
Volleyball League
Name
Institution
VOLLEYBALL LEAGUE
2
PART II
1. Local Volleyball League Database.
The entities are Teams, Players, Coaches, Results, Fixtures, Overall Standings and
Playoff Standings.
2. Queries in English
How many teams are there in the volleyball league and what are their names?
Who are the players in the respective teams in the volleyball league?
Who are the coaches of the respective teams in the volleyball league?
What are the results of the different matches played in a season?
What are the fixtures of matches in a given season?
What are the team positions in the overall standings in a league season?
Which teams have advanced to the playoffs in a league season?
Who are the winners of the title in a league season?
Which team has won the league title most number of times?
Which teams have advanced to final in a league season?
3. Atomic transaction.
Insert a new team into the teams table and commit the transaction.
4. Assumptions
Below are the attributes of the different entities and their keys.
Entities
Attributes
Teams
team_id (Primary Key), team name
Players
player_id (Primary Key), player_name,
team_id
Coaches
coach_id (Primary Key), coach_name,
team_id (Foreign Key)
Results
result_id
(Primary
(Foreign Key), result
Key),
fixture_id
...