Human Resource Management System: An Overview and Development, Assignments of Database Programming

Download Human Resource Management System: An Overview and Development and more Assignments Database Programming in PDF only on Docsity!

Database Service Report

Database Design and Development

ID: TCS

Name: Le Vo Hong Ngoc

Class: GCS0805_PPT

Assessor Name: Nguyen Van Son

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 TCS 18005

Class GCS^0805 _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 D

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, and that understand the guidelines on plagiarism. If you do not, you definitely get fail

Unit Learning Outcomes:

LO1 Use an appropriate design tool to design a relational database system for a substantial problem. LO2 Develop a fully functional relational database system, based on an existing system design. LO3 Test the system against user and system requirements. LO4 Produce technical and user documentation Assignment Brief and Guidance:

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:

1. Develop the database system using evidence of user interface, output and data validations and querying across multiple tables. You want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features.
2. You have decided to implement a query language into the relational database system. The developed system will be demonstrated to your manager in the report including:

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. 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 and testing 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 the best practices of people management at the time. That is, employee management techniques or methods 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 of the 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 proposed system will allow improve perform the job functions of the employees department and faculty by provide system allows: - Tasks are dispensed paper charged for the time and effort - Keep electronic records of employee's information, benefits, education, adjustments, evaluations and requests instead of paper files that need extra space. - Electronic working will be easy to completion tasks. - Also there are data facilitates retrieval and interact with them.

• The system flexible to add, delete, edit for employee record and all information belong to human 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.
4. The human resources management system (HRMS) will allow for trend analysis and reporting. 1.3.4. Organization chart and responsibilities This table will present all activities that will be developed on the human ressystem, objective of every activity and the target audiences for each activity.

4. Since the usual accounting definition of an asset involves the right to receive economic benefits in the future, human assets are appropriately classified as accounting assets. 5. It is theoretically possible to identify and measure human resource cost and benefits within an organization. 6. Information with respect to human resource costs and benefits should be useful in the process of planning, controlling, evaluating and predicting organizational performance.

1.6. literature review:

1.6.1. Introduction

Human resources are those who make up the workforce of some particular organization, economy or business sector. The "human capital" term may be understood as a synonym to the "human resources’" one. But at the same time, “human capital” one usually refers to a narrower view such as the knowledge the individuals embody as well as the economic growth. Some other terms that sometimes may be used instead of the “human resources” one include "talent", "manpower", "labor", "people" or "personnel". Any human-resources department of some organization is expected to perform human resource management, overseeing different aspects of employment (e.g., compliance with labor law and some of the employment standards), some aspects of dismissal and recruitment, as well as an administration of the employees’ benefits. Any human resources manager is known to be in charge for determining the work-related needs of the staff, using temporary staff or hiring employees in order to fill such needs, recruiting and training the best employees, supervise their work, managing employees’ relations, payrolls, benefits and compensations, preparing employees’ personal policies and records, ensuring high performance, ensuring equal opportunities for all the employees, dealing with discrimination and other performance issues. Ensuring that human resources practices conform to the regulations and pushing the employees' motivation so they achieve more within their organization, human resources managers might find the concept draw pro software a useful tool for making the needed human resources related drawings. The human resources flowcharts solution can be used while creating the human resources related drawings in the concept draw pro diagramming and drawing software, providing with a comprehensive collection of human resources themed icons, connectors, and images from the available stencil libraries, helping illustrating flowcharts, info graphics and workflow diagrams. Using this solution for mapping the human resources related management processes on every phase of human resource management, including the hiring process, the process of recruitment, payroll systems and human resource development, the human resources managers, same as man other managers, such as the project ones, may achieve more in their work spending less time on their tasks.

1.6.2. Human resource information systems types:

Operational human resources management system (HRMS) provides the manager with data to support routine and repetitive human resource decisions. Several operational-level information systems collect and report human resource data. These systems include information about the organization’s positions and employees and about governmental regulations. 1.6.2.1. Employee information systems

The human resource department must maintain information on each of the organization’s employees for a variety of decision and reporting purposes. One part of this employee information system is a set of human resource profile records. An employee profile usually contains personal and organization-related information, such as name, address, sex, minority status, marital status, citizenship, years of service or seniority data, education and training, previous experience, employment history within the organization, salary rate, salary or wage grade, and retirement and health plan choices. The employee inventory may also contain data about employee preferences for geographical locations and work shifts. Another part of an employee is an employee skills inventory which contains information about every employee, such as work experience, work preferences, test scores, interests, and special skills or proficiencies 1.6.2.2. Position control systems A job is usually defined as a group of identical positions. Every position consists of tasks performed by one worker. The purpose of the position control system is to identify each position in the organization, the job title within which the position is classified, and the employee currently assigned to the position. Reference to the position control system allows a human resource manager to identify the details about unfilled positions. 1.6.2.3. Applicant selection and placement information systems After jobs and the employee requirements for those jobs have been identified and after a suitable pool of job candidates has been recruited, the candidates must be screened, evaluated, selected, and placed in the positions that are open. The primary purpose of the applicant selection and placement information system is to assist human resource staff in these tasks. 1.6.2.4. Performance management information systems Performance management information systems include performance appraisal data and productivity information data. Performance management information systems data is frequently used as evidence in employee grievance matters. Careful documentation of employee performance was measured and reported is critical to acceptance of appraisal information in grievance hearings. This kind of systems can lead to a number of decisions beyond merely supporting the operational decision to retain, promote, transfer, or terminate a single employee. 1.6.2.5. FPT University reporting and compliance information systems FPT University reporting and compliance information systems provide information needed both to maintain compliance with government regulations and to improve productivity and reduce costs associated with employees

Figure (2.13) ER diagram for Human Resource Management System

2.1.3. Use case diagram

As shown in figure (2.14) administrator of the proposed system and the employee have various activities shared with login activity.

Figure (2.14) Use case diagram for Human Resource Management System

2.1.4. Activity diagram

As shown in figure (2.15) administrator of the proposed system can create vacations for employee who is a member of the proposed system. If there is an error the system will notify the manager

2.1.6. Database design

This section describes the eight tables that are linked to our project. These six tables is described in the following point

o Logins.

o Employees.

o Trainings

o Vacations.

o Attendances.

o Salaries.

o Department.

o Employee_Vacations

o Evaluations

2.1.6.1. Logins The admin table stores the information about human resources manager profile. All the human resources managers who will manage the system will be saved in this table. Table 2.1 Logins

Field name Data type Allow Nulls Description Username (^) Varchar(50) Primary key, Username login [Password] Varchar(50) x Password Login [Role] Bit x decentralization Employee_ID (^) Int x Employee code Foreign key

2.1.6.2. Employees The table employee stores the information about employee profile. The entire employees who are added by the manager in the system will be saved in this table. Table 2.2 Employee

2.1.6.3. Departments The table department stores all departments requested through the system will issue. All of these department data will be in this table. Table 2.3 Department

2.1.6.4. Trainings The table training stores all trainings which are added by the manager. All of these trainings data will be in this table. Table 2.4 Trainings

Field name Data type Allow Nulls Description

Employee_ id Int Primary key, Username login

Employee_ password Varchar (20) x Password of Employee

Employee_email Varchar (50) x Email of Employee

Employee_name Varchar (50) x Full name of Employee

Employee_ address Varchar (50) x Address of Employee

Employee_ mobile Varchar (11) x Phone of Employee

Department_ID Int x Department code, Foreign key

Field name Data type Allow Nulls Description

Department_ID Int Code Department , Primary key

Department_title Varchar (20) x Name Department

Field name Data type Allow Nulls Description

Training_ id Int Code Job

Training_ title Varchar (20) x Name Job

Training_ description Text x Description of Job

Employee_ID Int x Employee code Foreign key