Reference no: EM133050688
CIS 207 Database Management
Project: Human Resource Management System
1. INTRODUCTION
The aim of this project is to enable students integrate and apply the database design and management knowledge and skills acquired by developing a human resource management system for a small organization. During this project, a student is expected to analyze, design, implement and test a small human resource database management system. The project will be done within a predetermined timeframe and be formally presented for examination.
2. PROJECT DESCRIPTION
A student is given a human resource data requirement on which to base the project. The student then maps out a plan of action to design and implement a database management system for an organization's human resource database management system. Incorporated into this plan is a requirements document or blueprint that spells out how the database will be developed. This database management system will manage data relevant to the human resource department of the organization. At the same time, this database system must have functionalities that allow users to add content, remove content, search, and query the content. The database system is expected to have some security measures in the form of data entry validations. The database system should also have navigation and way-finding mechanisms that are sensitive to usability and accessibility concerns of users. The student is expected to document all the stages in the database development life cycle.
3. ACTIVITIES
Use the steps listed below as guidelines in developing the database system. 1. System Analysis
-Describe the structure of the human resource department for which the system is to be developed.
-Capture the key components of the section using a context diagram
-Use a data flow diagram (DFD) to show the processes and flow of data.
-Describe the objectives of the proposed database system 2. Database Design
a) Conceptual Design -Apply the entity relationship modeling (ERM) for the conceptual design of the database. Use Chen's notation. All the ER diagrams should be fully labeled.
b) Selection of the database management system (DBMS) to be used. In this case, Microsoft Access shall be used by all students. Describe the key features of Ms Access, its advantages and disadvantages.
c) Logical Design - Map the conceptual design into a logical model based on the chosen database constructs i.e., Microsoft Access.
d) Physical Design - Describe the data storage organization, integrity, and security. 3. Implementation
-Ensure Ms Access is installed in your computer system
-Using Ms Access, convert the database design into a useable system by creating:
a) Tables and their relationships
b) Forms for data entry and reports output
c) Necessary queries
d) User forms, buttons, and menus for ease of navigation.
e) Test the system with sets of dummy but typical data.
4. DELIVERABLES
Submit a Project Document structured as follows:
0. Title Page
-Title of the project
-Degree Programme
-Student's Details
-Course Unit
1. Introduction
-A brief description of a typical human resource department.
-The need for a database management system
2. Body
-All the activities
-Include text, diagrams, and screenshots, as necessary. Diagrams and screenshots must have captions and explanations.
4. Conclusion
-Summarize the motivation for developing the database management system.
-Challenges faced during the development of the database management system.
-Recommendations for implementation and future improvements.
5. References
-All the references including websites
Note: The project document should be saved in MS WORD. The file name should be the first and last name of the student separated by an underscore.
Attachment:- Database Management.rar
Theory of character orientation
: Psychoanalyst Erich Fromm created a theory of character orientation, which included what he referred to as a 'marketing personality'.
|
Prepare a cost of quality report
: Sales revenue for Company was $950,000 for same financial year. Prepare a cost of quality report - Calculation Analysis in terms of percentage of total sales
|
Conduct a value chain analysis on avon
: Conduct a value chain analysis on Avon. it must be applied to company core business
|
Key secret in the success factors
: Consider what your list of personal leadership values would be from this resource. Select at least five values, but no more than 10.
|
Developing a human resource management system
: Developing a human resource management system for a small organization - database design and management knowledge and skills
|
What is the amount and character of Alicia loss
: Several years ago, Alicia loaned the corporation $50,000. What is the amount and character of Alicia's loss on satisfaction of the debt
|
Main features of market capitalism
: In your own words, what are the main features of market capitalism and centrally planned socialism?
|
Creative organizational definition
: In today's integrated, global operations and supply chain environment, an organizational definition is not limited to the resources, technologies, and people co
|
Registration process at a clinic
: A few processes have to be carried out by the clinic counter staff during registration. The first process is to enter data into computers based on the patient's
|