Database Systems and Design

Running head: DATABASE SYSTSEM AND DESIGN
Database systems and design
Name of the Student:
Name of the University:
Author Note

1
DATABASE SYSTEM AND DESIGN
Stage 1: Scenario and Conceptual Database Design Task
1.1: Selection of the case upon which the database design and implementation is to be
based
The football event system has been selected here for the description of the database
and its implementation.

2
DATABASE SYSTEM AND DESIGN
Task 1.2: Provide a conceptual database design for your scenario & the list of enterprise
rules being modelled
Business Rules
The main business of the football event database are:
 The details of the teams are to be stored in the database.
 The database should be storing the details of the referees in the system.

3
DATABASE SYSTEM AND DESIGN
 The database should be able to store the details of the stadiums, which would be
hosting the matches.
 The database would able to store the details of the matches that
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Matches (MatchID (pk), HomeTeam (fk), OpposingTeam (fk), StadiumID (fk), MatchDate,
RefereeID (fk))
Teams (TeamID (pk), TeamName)
Stadium (StadiumID (pk), StadiumName)
Referee (RefereeID (pk), RefereeName)
Task 2.2 Create the tables using Oracle DBMS
Database tables
Teams
Stadiums