Sql Business Application
...Atkins
Kevin Dahl
Brandy Jones-Hsia
Jeff Pabers
September 9, 2004
SQL Business Application
Human Resource Database Application
Overview
The SQL business application that team C will develop is a standard Human Resources Database Application (HRDA). The HRDA focuses on the basic functions of HR departments. The HRDA provides methods to insert HR data into the database, such as personnel information, job description information, and personnel benefit information, and personnel training information. The application uses this data to provide useful and meaningful reports about the human resources of the company. Also, the HRDA is an application that queries data local to the system the application is installed. The application is not a client/server application, but the principle behind the application can be used in the client/server environment. The HRDA database has been developed using Microsoft Access, and is a Microsoft Access database with forms to input data into the database and forms to retrieve data from the database. The database forms use SQL statements to manipulate and retrieve data from the database.
The Key features of the HRDA are it ability to find and display particular information about a particular employee or group of employees, a job description or an employee benefit. These key features will give the user of the system the ability to select an employee, job, or benefit and then select the particular information they wish to know about the selected employee, job or benefit. Also, there are standard reports built into the system, like an employee directory, telephone directory, employees listing by job description, employees listed by benefit name, and so on. These key features provide the means for the HR department to gather the information and statistics they need to perform their job.
The input data of the HRDA consist of...
View Full Essay
