Database System and Design

Running head: DATABASE
Database
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
A game database has been assumed for the descriptions in the report and the detailed
information about the games and the gamers have been used in this report. The database has
been used for the description of the games, their producers and the type of platforms on
which a gamer plays that games. There are different genre of games and there is different
type of genre for the producers as well. The game database should also be able to provide
important information to the gamer about any particular game.
Task 1.2: Provide a conceptual database design for your scenario & the list of enterprise
rules being modelled.

2
DATABASE SYSTEM AND DESIGN
Business Rules
The business rules on which the development of the database is done are described
below:
 The system should be able to store the details of the games in the database with the
major information including the producers, type of game and the mode of game.
 The system should be able to store the details of the gamers who are playing the
games and on which console they would be playing the games.
 The database should be able to store the details of the producers that produce the
games.
 The database should also store the details of the consoles on which the gamers play
the games.
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Logical design for the selected scenario is provided below:
Producer (ProducerID(pk), ProducerName)
Games (GameID (pk), GameName, GType, GMode, ProducerID (fk))
Gamers (GamerID (pk), GamerName, GameID (fk), ConsoleID (fk))
Console (ConsoleID (pk), ConsoleName)
Task 2.2 Create the tables using Oracle DBMS
Database tables
Console

3
DATABASE SYSTEM AND DESIGN
Producer
Game