Uses of Databases and the Types of Database Software
Objective
• This project gives students the opportunity to work with real-world data and perform some endto-end development of a database, without step-by-step instructions.
• Apply the Access skills that are covered throughout the course to create an HR Database, whilst providing explanation for each decision.
• To give students the opportunity to demonstrate their ability to work towards milestones leading to the completion of the project.
• Allow students to collaborate and work in groups, as the project can be completed in groups of up to 5 students.
• Include proper references for any external research in the correct format (MLA or APA) at the end of your written report.
Background Information about the Project
• You are employed and a large leading-edge company with many employees
• As a member of the HR team, you have been asked to create a database to track 100 employees from 3 different departments.
• The database must include at least
o 3 related tables (1 of the three should be named employee table)
o 4 different queries
o 1 form for entering new employees
o 2 reports
• Be creative! The database can be setup any way that works and makes sense. Keeping in mind database principles.
Part A: General Database Research – Answer the following questions in essay/report format. To be submitted with your Access Database File.
1. What is a database?
2. Why are databases important?
3. How are databases typically used in H.R. environments?
4. Research and share information about 3 other types of database software/vendors. Which ones are good/popular? Why?
Kindly do all Part A. Only
Database
Student’s Name
Institutional Affiliation
Instructor
Date
A database is a structured data collection often electronically stored and accessed from a computer system. The data is organized into a structured format, which can be managed and manipulated by an application. Databases can store information from single or multiple users (Lu & Holubová, 2019). Common uses for databases include data analysis, storage, and web-based applications. Databases are used in many industries and applications, from financial services to online retail. The importance of databases lies in their ability to store and manage large amounts of data quickly and efficiently. They can store data in multiple formats, including text, images, and audio files. This data can then be accessed from any computer with an internet connection, allowing users to access and analyze it from anywhere in the world. Databases are used for several purposes, including data processing, analysis, storage, and retrieval. Data processing involves transforming raw data into meaningful information, such as analyzing customer behavior.
Databases are also crucial because they provide a secure platform for storing and managing data. They are designed to be resistant to data loss or corruption, meaning that data stored in a database is unlikely to be lost in the event of a system failure. This is essential for businesses that rely on data, as it ensures that the information is safe and secure. Databases are also critical because they are cost-effective (Kraska et al., 2021). They allow organizations to store large amounts of data without incurring high costs. This is especially true when compared to traditional storage solutions, such as paper and filing cabinets. Databases allow organizations to access and analyze data from anywhere worldwide, reducing the need for expensive physical storage solutions. They are also important because they enable companies to make informed decisions. By using databases, firms can analyze and interpret data more quickly and accurately. Doing so allows them to make the best decisions based on real-time data. This is especially critical for businesses, such as online retailers, that need to make rapid decisions.
Databases are commonly used in Human Resource (HR) environments to store and manage employee information, comprising personal data such as name, address, date of birth, and social security number, as well as job-related data like job title, salary, and benefits. By using a database, HR departments can maintain accurate and organized records of their workforce. Databases also allow HR departments to quickly access employee records and generate reports (Stanton & Weiss, 2003). For example, they can generate reports on employee performance, attendance, and turnover rates. Reports can be used to make decisions about employee promotions, salary increases, and other personnel-related matters. Databases also provide a platform for HR departments to manage employee benefits such as vacation time and health insurance. By using a database to track employee benefits, HR departments can...