Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
¶ … Databases
There are many databases that I encountered in my work. Some are databases related to the projects I handle and concerns the clients' needs while there are also databases that concern the entire company. One example of this database is the payroll database.
The payroll database contains all the important information that relates to the employees' salary. This includes the number of hours an employee had work, his benefits and incentives, his pay rate, and others. Some of the files that are necessary for this database to properly function are the attendance file (which is also a database) and employee information file. It is a must that the payroll database must contain all the right information. Otherwise, negative consequences may affect the entire company, including the financial tracking and salary of employees. Some of the important fields in the payroll database are the following.
Employee Name
Employee Number
Hourly/Daily Rate
Number of hours worked
Number of available/used leaves
Deductions such as taxes
Payroll date
Overtime pay
Gross and Net Salary
Another important database that I encountered in my work is the Employee Information database. This database contains all the information of every employee such as personal background, professional background, and current status in the company. Every employee in our company finds this database useful because they can check and update their work status there such as listing their current projects as well how the projects are going. Another advantage of this is that the employees' managers, or those to whom they report to, can easily access their information, eliminating the need for unnecessary meetings. Moreover, managers can track their employees' activities, providing them with more information from where they can base their evaluation on their employees. Some of the important fields in this database are the following.
Employee's Name
Position
Department
Reports to Job Responsibilities
Projects Handled
Projects Currently Handling
Achievements
Professional Qualifications
There are still other important databases in our company. However, as payroll and employee information are among the databases that especially affects the entire company, I consider them the most important ones. These databases are perhaps similarly important to every company. These may be the most common databases but definitely the most important ones in terms of managing every company.
Database Presentation The objective of this study is to present a new database to be implemented in the clinical setting to increase quality and safety of patient care. The database at focus in this work in writing is that of the Targeted Therapy Database (TTD) in a Cancer unit in a hospital. The work of Mocellin, et al. (2010) relates that the "efficacy of current anticancer treatments is far from satisfactory and
Database Administrator for Department Store Scenario The department store has expanded in the local region by opening five more bookstores, and the bookstore has launched a series of marketing campaign to increase sales and attract new customers. The objective of this technical report is to develop a plan to create and maintain an enterprise-wide database system that will assist the bookstore to hold the inventory and sales data. The database design will
Database Security The focus of this study is that of database security. Databases and database technology are such that play critical roles in the use of computers whether it be in business, electronic commerce, engineering, medicine, genetics, law, education or other such entities requiring the use of computer technology. A database is quite simply a collection of data that is related such as a database containing customer information, supplier information, employee
Database Security Plan and Requirements Definition for a University Department The database security plan and requirements definition were developed. The plan included, at the outset, the inclusion of major stakeholder at the University and described their roles in initiating, implementing, and maintaining the plan. Individuals responsible for daily and other periodic tasks were developed. A major consideration in planning the security was the policy that governs granting of access. The need-to-know,
" "STUDENT INFORMATION TABLE" ( "STUDENT ID" CHARACTER (4) NOT NULL, NAME CHARACTER (25) NOT NULL, "STREET NUMBER" CHARACTER (10) NOT NULL, "STREET NAME" CHARACTER (25) NOT NULL, CITY CHARACTER (25) NOT NULL, STATE CHARACTER (10) NOT NULL, EMAIL CHARACTER (25) NOT NULL, "PHONE NUMBER" CHARACTER (15) NOT NULL ); CONNECT RESET; SQL FOR Book_Information CONNECT TO LIBRARY; CREATE TABLE "USER"; CREATE TABLE BookInformation ( "BookISBN" CHARACTER (10) NOT NULL; "AUTHOR" CHARACTER (25) NOT NULL; "TITLE" CHARACTER (50) NOT NULL; "PRICE" CHARACTER (10) NOT NULL; CONNECT RESET; SQL STATEMENT FOR
Database Design for Spa/Hotel Booking System The WR (Woodlands Retreat) is a medium sized organization currently intending to build a database system to integrate modern IT (information systems) in its business operation to enhance its dynamic and innovative business operations. Although, the Woodlands Retreat has an IT system, however, the current systems are not capable of keeping book records as well as not capable of managing all data for the company