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
The description of the report is based on the development of the database on a salary
management system of an arbitrary company. The system consists of the development of a
system that would be helpful for the organization in maintaining a management system that
would be helpful for them in managing the salaries of the employees of the organization. The
data related to the departments in organization are also to be included in the database of the
system. In addition to this, the data of all the employees are also required to be stored in the
database system for the organization. The salary and the payment for each of the employees
in the organization are to be stored within the database of the organization.

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 business rules for the implementation of the salary management system has been
described below:
 The system should be able to store the details of the departments with their unique
DepartmentID.

3
DATABASE SYSTEM AND DESIGN
 The system should be able to store the details of the Employees are to be stored in the
system with their unique EmployeeID.
 The system should be able to store the details of the salaries of each of the employees
of the organization.
 The system should be able to store the details of the payment of salaries for the
employees for the organization.
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Department (DepartmentID (pk), DepartementName)
Employee (EmployeeID (pk), EmployeeName)
Salary (SalaryID (pk), EmployeeID (fk), Amount)
Payment (PaymentID (pk), SalaryID (fk), PMode)
Task 2.2 Create the tables using Oracle DBMS
Database tables
Department
Employee