Database Design and Implementation

Running head: DATABASE
Database
Name of the Student:
Name of the University:
Author Note

1
DATABASE
Table of Contents
Stage 1: Scenario and Conceptual Database Design..................................................................2
Task 1.1: Case Scenario.........................................................................................................2
Task 1.2: Entity Relationship Diagram:.................................................................................3
EER Diagram.....................................................................................................................3
Assumption........................................................................................................................3
Conceptual Diagram:.........................................................................................................4
Business Rules...................................................................................................................4
Task 2.1: Provides a logical database design for your scenario.............................................5
Task 2.2: Create the tables using Oracle DBMS....................................................................5
Database tables...................................................................................................................5
Data Population..................................................................................................................6
SQL Queries.......................................................................................................................8
Bibliography.............................................................................................................................13

2
DATABASE
Stage 1: Scenario and Conceptual Database Design
Task 1.1: Case Scenario
The Case study for the Denver Sports Club has been displayed in this report. The club
is looking to host a tournament along with the players from their academy. The organization
would host the tournament in their home ground. All the players would be divided into a
number of teams and a number of matches would take place in between the teams decided by
the club. All the players would be participating in the tournament and there would be a
number of coaches for each of the teams. Each of the match would have a coach monitoring
the game.
Now, the organization is need of a database that would be storing the data for the club
in their matches and the results of the matches are also required to be stored in the database.
The database should also be able to store the details of the winning teams in the match. The
development of the database would help the club in determining and keeping track of the
matches and the tournament taking place within the organization.

3
DATABASE
Task 1.2: Entity Relationship Diagram:
EER Diagram
Assumption
The diagram that is created above is based on a football match in which the record of
the players and the coaches of the teams have been recorded in the database. The names of all
the players and the winning team has also been recorded in the database. It has been assumed
that the database has been used for the details regarding a single match in the football event.