Unit 04: Database Design and Development Report - FPT University

This report details the design and development of a Human Resource Management System (HRMS) database for FPT University, addressing the need for improved management of the growing student population. The report begins with an overview of HRMS, defining the problem and outlining goals, objectives, and critical success factors. It then explores the system requirements, including user roles, business processes, and statistical reports. The core of the report focuses on the database design, including an Entity Relationship Diagram (ERD), use case and activity diagrams, and detailed table designs for various entities such as employees, departments, and salaries. The design incorporates interface and output designs, data validations, and data normalization to ensure data integrity and efficiency. The report further assesses the effectiveness of the design in relation to user and system requirements, providing a comprehensive view of the database development process. This report is a comprehensive study of database design and development for an HRMS system.

Database Service Report
Database Design and Development

Page 2
ASSIGNMENT 1 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing
Unit number and title Unit 04: Database Design & Development
Submission date Date Received 1st submission
Re-submission Date Date Received 2nd submission
Student Name Le Vo Hong Ngoc Student ID TCS18005
Class GCS0805_PPT Assessor name Nguyen Van Son
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that
making a false declaration is a form of malpractice.
Student’s signature
Grading grid
P1 M1 D1

 Summative Feedback:  Resubmission Feedback:
Grade: Assessor Signature: Date:
Signature & Date:

ASSIGNMENT 1 BRIEF
Qualification BTEC Level 5 HND Diploma in Computing
Unit number Unit 04: Database Design & Development
Assignment title
Academic Year
Unit Tutor
Issue date Submission date
IV name and date
Submission Format:
Format: This assignment is an Individual assignment and specifically including 1 document:
You must use font Calibri size 12, set number of the pages and use multiple line spacing at
1.3. Margins must be: left: 1.25 cm; right: 1 cm; top: 1 cm and bottom: 1 cm. The reference
follows Harvard referencing system. The recommended word limit is 2.000-2.500 words. You
will not be penalized for exceeding the total word limit. The cover page of the report has to
be the Assignment front sheet 1.
Submission Students are compulsory to submit the assignment in due date and in a way requested by
the Tutors. The form of submission will be a soft copy posted on
http://cms.greenwich.edu.vn/
Note: The Assignment must be your own work, and not copied by or from another student or from
books etc. If you use ideas, quotes or data (such as diagrams) from books, journals or other sources, you
must reference your sources, using the Harvard style. Make sure that you know how to reference properly,

You are employed as a Database Developer for a large IT consultancy company. The company has been
approached by FPT university which is expanding due to the growth of the number of students. FPT is
currently facing difficulties in dealing with managing the university. It decided to develop several academic
systems to manage the university easier including: Online Library system, Student Grading System,
Attendance System, CMS System, Scheduling System, Enrolment Systems, and so on.
You are tasked to select one of those systems to develop database for FPT university. Your tasks are to:
Work with FPT to find out about current requirements for each system
Analyze the requirements and produce clear statements of user and system requirements.
Design a relational database system using appropriate design tools and techniques
Develop a fully functional relational database system, based on an existing system design.
Test the system against user and system requirements.
Produce technical and user documentation
Part 1 (Assignment 1)
Before you start the development process, your manager has asked you to produce a report for the CEO
of FPT, containing:
1. Clear statements of user and system requirements. The system must have at least 2 user roles, including
business processes and statistical reports for FPT university managers.
2. The design of the relational database system using appropriate design tools and techniques. It should
contain at least four interrelated tables.
You would prefer to produce a more detailed document, so you will produce a comprehensive design for a
fully functional system which will include interface and output designs, data validations and cover data
normalization.
Your manager would like on the report your assessment of the effectiveness of the design in relation to user
and system requirements.
Part 2 (Assignment 2)
Once the designs have been accepted by your manager you have been asked to:

 Assessing whether meaningful data has been extracted through the use of query tools to produce
appropriate management information.
 Evaluating the effectiveness of the database solution in relation to user and system requirements,
and suggest improvements.
3. Once the system has been developed, you will test the system and your manager will complete a witness
statement indicating how your tests are performing against user and system requirements.
Besides, you will produce a brief report assessing the effectiveness of the testing, including an explanation
of the choice of test data used.
4. Lastly you will produce technical and user documentation which will be given to the company.
You want to provide some graphical representations for ease of reference in the technical guide, so you
have decided to produce a technical and user documentation for a fully functional system, including
diagrams showing movement of data through the system, and flowcharts describing how the system
works.

Learning Outcomes and Assessment Criteria
Pass Merit Distinction
LO1 Use an appropriate design tool to design a relational database system for a substantial
problem
P1 Design a relational
database system using
appropriate design tools
and techniques, containing
at least four interrelated
tables, with clear
statements of user and
system requirements.
M1 Produce a comprehensive
design for a fully functional
system which includes
interface and output designs,
data validations and data
normalisation.
D1 Assess the effectiveness of
the design in relation to user and
system requirements.

TABLE CONTENT
1. Introduction. ................................................................................................................................ 10
1.1. Overview ............................................................................................................................... 10
1.2. System description ............................................................................................................... 10
1.3. Problem definition ............................................................................................................... 11
1.3.1. Goals ............................................................................................................................... 11
1.3.2. Objectives....................................................................................................................... 11
1.3.3. Critical success factors ................................................................................................... 11
1.3.4. Organization chart and responsibilities ........................................................................ 11
1.4. Feasibility study: ................................................................................................................... 12
1.5. Human resources management general rules: ................................................................... 12
1.6. literature review: .................................................................................................................. 13
1.6.1. Introduction ................................................................................................................... 13
1.6.2. Human resource information systems types: .............................................................. 13
1.6.2.1. Employee information systems .............................................................................. 13
1.6.2.2. Position control systems......................................................................................... 14
1.6.2.3. Applicant selection and placement information systems ..................................... 14
1.6.2.4. Performance management information systems.................................................. 14
1.6.2.5. FPT University reporting and compliance information systems ........................... 14
2. System analysis ........................................................................................................................... 15
2.1. Entity Relationship Diagram (ERD) ...................................................................................... 15
2.1.1. Human Resource Management System entities and their attributes: ....................... 15

2.1.6.3. Departments ........................................................................................................... 20
2.1.6.4. Trainings .................................................................................................................. 20
2.1.6.5. Vacations ................................................................................................................. 21
2.1.6.6. Salaries .................................................................................................................... 21
2.1.6.7. Attendance .............................................................................................................. 22
2.1.6.8. Evaluations .............................................................................................................. 22
2.1.6.9. Employee_Vacations .............................................................................................. 22

1. Introduction.
1.1. Overview
For more than a century now, human resource management, as a discipline and practice in the
management of people in an organization, has evolved and developed into different areas.
These disciplines and practices have gone through a process of trial and error, theory building andtesting
of various concepts by practicing managers and academics. The underlying forces behind the evolution
and development of human resource management have been (and still are) mainly environmental, and
the quest for knowledge of better ways of acquiring and utilizing labor.
The changing organizational environment in the marketplace pushed managers to improve efficiency in
the production and service delivery processes by increasing their ability to use thebest practices of
people management at the time. That is, employee management techniques ormethods that would
improve production, reduce service delivery costs, and at the same time ensure sustained availability of
competent staff in the organization.
This study is devoted to providing organizations with a human resource management system ofthe
evolution and development of human resource management and the way it works and influences people
management in contemporary organizations.
1.2. System description
Human resources management system (HRMS) was created to include the best practices
for service human resources departments within the company and is the work of all employees
department.
The target group of the system that serves the human resource procedures is special for the employees
and managers.
This system is also classified according to staff branches and departments as it is classified according to
the work of multiple systems; In addition to that it is organized in terms of personnel (promotions -
bonuses– trainings- Benefit).
This system of work area makes it easy to enter movements daily work , also organizes
holidays, whether in the day or hours , Emission a monthly report full and detailed and accurate for all
staff movements within a specified period (work required -work actual ).

- The system flexible to add, delete, edit for employee record and all information belong tohuman
resources management.
1.3. Problem definition
1.3.1. Goals
The aim of this study is to build the human resources management system to increase the efficiency
of the performance and the safety of the decisions taken and the advancement of the institution
The researcher will study the human resource management system requirements used in any
company in order to build a human resource management system efficiently.
1.3.2. Objectives
We will build a web-based human resource management system (HRMS) to increase the
performance and organization of the entire range of human resources management services by
developing these sections:
- Rules section.
- Compute the net salary after adding salary, promotions percentage and loans.
- Detailed reports section.
- Direct email communication.
- Statistical data charts.
- Training section.
- Vacations section.
- Salary.
- Attendance.
1.3.3. Critical success factors
1. Increased performance of the entire range of human resources management services.
2. Provide a single point of contact for customers to take human resources management system
(HRMS) procedures or to request any clarification.
3. Expand the coverage of the human resources management system (HRMS) to include the entire
human resources services, including human resources management system (HRMS) planning,
performance management and Internet recruitment systems.

Table (1.1): Organization chart and responsibilities.
Question Objective Activity Target Audiences
How to control on
the access of the
system?
Making saved
authentication to
the system
Developing Rules
section
HRMS give employee rules to
access any par of the system
How to Compute
the net Salary for
the employees?
To compute the
net salary for
everyone on the
system
Computing net Salary
after adding Salary,
promotions
percentage and loans.
HRMS compute net salary for all
employees on the system.
How to get all
Detailed information
about any part of the
system?
To get detailed
reports about any
part of the system
Developing Detailed
Reports section
HRMS will extract all data on the
system
How to make
direct communicate
with the employees?
To communicate
with all employees
quickly
Managing
communication
with whole system
members.
Employees who are members on
human resource management
system (HRMS).
How to realize the
change of data on
the system?
To represent all
data on thesystem
Representing data on
the system in graphs
and statistics
All data on the system stored on
database.
1.4. Feasibility study:
Information has been collected by reference to sources, written references and informationpublished in
scientific, research and literary sites on the Internet
1.5. Human resources management general rules:
The human resources management team suggests to the management team how to strategically
manage people as business resources. This includes managing recruiting and hiring employees,
coordinating employee benefits and suggesting employee training and development strategies. In this
way, general rules related to human resources management system.