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 demonstration of a railway management system is provided in this report. Storing
the data of a railway system is very important and one such arbitrary railway system has been
considered for this report. The train details are to be stored in the system along with the
stations details. This would help the customers in having the details of the trains and the
station so that they would be able to select their desired location. In addition to this the details
of the customers are also to be stored in the system. The bookings would done for the system
are also to be recorded in the system so that the details of the railway system are maintained
in the database.

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 set of rules defined below are required for the development of the database of the
railway management system:
 The details of the train are to be stored in the system including the Train Number.

3
DATABASE SYSTEM AND DESIGN
 The details of the Employees are to be stored in the database.
 The details of the station are stored in the system identified by their unique id.
 The booking details are to store in the database.
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Customer (CustomerID (pk), CustomerName)
Station (StationID (pk), StationName)
Train (TrainID (pk), TrainName)
Booking (BookingID (pk), TrainID (fk), SStation (fk), EStation (fk), CustomerID (fk),
NumberOfSeats, Time)
Task 2.2 Create the tables using Oracle DBMS
Database tables
Customer
Station