BACHELOR IN INFORMATION TECHNOLOGY WITH HONOURS

JANUARY 2021

CBDB3403

DATABASE

NO. MATRIKULASI : 970426146216001

PUSAT PEMBELAJARAN : BANGI LEARNING CENTER

1.0 INTRODUCTION

2.0 DETERMINATION OF MAIN ENTITIES’

2.1 EMPLOYEE

2.2 DEPARTMENT

2.3 SALARY

2.4 PERFORMANCE

2.5 HUMAN RESOURCE

2.6 BENEFITS

2.7 LEAVE

3.0 DETERMINATION OF ATTRIBUTES AND PRIMARY KEY

4.0 DETERMINATION OF RELATIONSHIP, CARDINALITIES AND

PARTICIPATION

5.0 ENTITY RELATIONSHIP DIAGRAM

6.0 RELATIONAL SCHEMA

7.0 DATABASE AND TABLES CREATION IN DBMS

8.0 TABLE RECORDS

9.0 SQL QUERIES

REFERENCES
 INTRODUCTION:

In my assignment, I would be
proposing a database design
for the telehealth system
implementation by drawing a
complete Entity Relationship
Diagram (ERD) as well as
creating the relational database
based on the given scenario
with its business rules
In my assignment, I would be
proposing a database design
for the telehealth system
implementation by drawing a
complete Entity Relationship
Diagram (ERD) as well as

1
creating the relational database
based on the given scenario
with its business rules
A DBMS enables human resource departments to effectively and systematically store and
organize employee-related data. Information like employee profiles, personal particulars,
work history, performance histories, benefits, and more are included in this. All of this
information being in one location makes it simple to access, retrieve, and analyze it,
increasing HR efficiency as a whole.

Effective Data Retrieval: HR professionals can use a DBMS to rapidly access specific
employee data or produce reports based on numerous criteria. Compared to manually
searching through piles of paper papers or dispersed digital files, this saves time and
effort. The querying features of the DBMS make it simple for HR employees to filter and
retrieve pertinent data.

In this assignment, I would like to propose a database design and implement a human
resources management system by creating a relational database based on the provided
scenario and its business rules as well as a complete entity relationship diagram.

DETERMINATION OF MAIN ENTITIES:

The main entities of the Human Resource Management System are employee,

department, salary, performance, human resource, benefits and leaves.

EMPLOYEE

Each individual employee within the organization is represented as a separate entity in the

employee database. It contains specific information about the employee, including

2
personal details, work-related information, salary, benefits, and any other pertinent data

associated with their employment.

DEPARTMENT

Departments within an organization can be represented as entities in the employee

database. Each department entity includes details such as department name, manager,

team members, and other relevant information that helps in organizing and structuring the

workforce.

SALARY

This entity represents the compensation or remuneration provided to an employee for their

work. It includes the monetary amount or package offered to employees, typically on a

recurring basis (e.g., monthly, biweekly, or annual). The salary entity encompasses both

the fixed components (base salary) and variable components (bonuses, incentives) that

make up the overall compensation package.

PERFORMANCE

This entity represents the formal evaluation process conducted to assess an employee's

performance. It includes details such as the date of the review, the reviewing manager,

3
key performance indicators (KPIs) or goals set for the employee, feedback, ratings, and

overall performance assessment.

HUMAN RESOURCES

POSITION/JOB TITLE

The positions or job titles within the organization can be modeled as entities. These

entities define the roles and responsibilities associated with specific positions, including

job descriptions, qualifications, skills required, and reporting relationships.

LEAVE

Leave entity associated with the leave entity enable the organization to effectively

manage employee time-off, track leave balances, ensure appropriate approvals, and

maintain accurate records of leave usage. They facilitate efficient scheduling, workforce

planning, and compliance with leave policies and regulations.

DETERMINATION OF ATTRIBUTES AND PRIMARY KEY

4
5
DETERMINATION OF RELATIONSHIP, CARDINALITIES AND PARTICIPATION

6
 APENDIKS

RUJUKAN / REFERENSI

Nama Pengarang, (tahun), Tajuk Buku, Penerbitan

7
 < PROGRAM >

< SEMESTER / YEAR>

< COURSE CODE>

< COURSE TITLE>

MATRICULATION NO : <MATRIC NO>

8
9
INSTRUCTIONS
 Do not copy the assignment question and instructions to your answer.
 Prepare your assignment answer following the layout of the ASSESSMENT
CRITERIA shown in the RUBRICS provided for the course. Where RUBRICS are
not provided, follow the instructions/guidelines specified by the Open University
Malaysia (OUM) for the assignment concerned.
 Your assignment should be written according to the number of words outlined
in the assignment instruction EXCLUDING references.
 Type your answer using 12 point Times New Roman font and 1.5 line spacing.
 Show the number of words at the end of your assignment.
 Tables and figures where provided, should be appropriately titled.
 List your references separately in the APPENDIX page.

10
 ATTACHMENT

REFERENCES

Author’s name (year). Book, Title, Publication

11