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 aim of the report is to create a database development system based on a chosen
company. The salary management system will be prepared will help of a database. The
system developed includes development of the system that will be beneficial for the
organization maintaining the management system. This system will be helpful in managing
the salaries of all the employees present within the organization. Moreover data related to
each employees are needed to be stored properly. The dataset related to each departments
within the organization needs to be included within the database system. This will help in
organizing the details properly. Apart from this the database system will store the information
relate to salary and payment of each employee within the organization. This will help the
organization to manage and have a proper control over the employee’s information and data
sets.

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
There are certain rules for business that are needed to be followed while managing the salary
system. The rules important for salary management system are implemented accordingly and
described below:
 The system should have the ability to store details of each department with the help of
unique DeaprtmentID.
 The details regarding to the employees are to be stored in the system with the help of
unique EmployeeID.

3
DATABASE SYSTEM AND DESIGN
 The system need to store details regarding the salary of each employee from different
departments working within the organization. This will help to sort the salary as per
the position of the employees.
 Apart from this, the system needs to have a proper record regarding the payment
details of each employees working within the organization. This will contain salary
details also.
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