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 report has been used here for the discussions on the salary management system
for an arbitrary organization. The organization would be benefitted by the implementation of
the system as this would provide them with the option to fetch the salary and payment
information form the system very easily. In addition to this, the system would also help the
management in storing the details of the departments and the names of the employees of the
organizations. The salary status for each of the employees in the organization would be
efficiently stored and displayed with the use of the database for the system.

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 rules on which the development of the database is based on are
described below:
 The system should be able to store the details of all the branches within the
organization.

3
DATABASE SYSTEM AND DESIGN
 The system should be able to store the details of all the employees within the
organization and each of the employee would belong to a certain branch and they
would be identified by a unique employee id.
 The system should be able to store the details of salary for each month for each of the
employee.
 The details of the payment of the salary for each of the employees within the
organization is stored in the system.
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Branch (BranchID (pk), BranchName)
Employee (EmployeeID (pk), EmployeeName, EmployeeAddress, EmployeeContact,
BranchID (fk))
Salary (SalaryID (pk), EmployeeID (fk), Amount, Month)
Payment (PaymentID (pk), SalaryID (fk), Mode)
Task 2.2 Create the tables using Oracle DBMS
Database tables
Branch