ITDA1001 - Database Fundamentals Tutorial 1 and Tutorial 2 – Capturing Data Objectives - On completion of the activities, the students will be able to :- 1. Understand the basic concepts of Capturing Data 2. Be aware of the many types of data found in application systems 3. Understand the importance of data 4. Start thinking of the nature of data by deciding on the data type EastWood Manufacturing Pty Ltd is an organization with 1000 employees. It designs and manufactures furniture and has both local and overseas customers. The organization is currently operating on a file-based system and management has allocated a million-dollar budget to migrate from a file-based to a Relational DataBase Management System (RDBMS). The Finance department has been chosen to pilot the new system. You are a group of database consultants that EastWood has engaged to look into the requirements of the Finance department. Your first task is to identify all the data that the Finance department must maintain in the new system based on the functions of the department. You have interviewed the users of the Finance department and the following are some findings that you have obtained. For Finance Department The department runs the payroll system every month. It maintains data on employee's basic salary and the date he joined the company. It is also in-charge of the year-end bonus processing. Each staff member is assigned a unique staff number when he first joins Eastwood. The finance dept has to track the various types of claims (i.e. transport claims, dental claims, medical claims, meal allowances, overtime claim) made by employees; as well as the various types of loans (i.e. housing loans, computer loans, car loans) that employees have applied for. As part of employee benefits, Eastwood offers loans at preferential interest rates to employees who have been with the company for more than 5 years. The gross salary that each employee receives at the end of each month is computed by adding all claims to the basic salary, and deducting all loan repayments from it. In addition to loan repayments, regular monthly donations made by staff to various charitable organizations are also automatically deducted from the basic salary. An annual increment is given each year. The date of the increment depends on the date that the staff member joined the organisation. For example, staff who joined on 1st Oct 2000 will get her first annual increment on 1st Oct 2001. The increment amount depends on the person's employment grade and performance. Grade D staff will get an increment between $100-$200 per year; Grade C staff between $201-$300 per year, Grade B staff between $301-$400 per year, Grade A staff between $401-$500 per year, and superscale staff between $500-$1000 per year. The monthly overtime pay is calculated based on the total number of hours worked for that month. This is subject to a cap of 5% of the monthly basic salary for staff who are eligible for overtime pay. Management staff (i.e. superscale and grade A) cannot claim for overtime pay. In addition to the annual increment, employees are also given a one-time special performance bonus in July if they had achieved outstanding performance for the previous year. The bonus ranges from $500 to $2000 and is awarded based on the supervisor's recommendation. Questions 1. Based on the information above, analyse the data required by the Finance Department. 2. Indicate the data type for each data item, i.e. whether they are character (text), number or date. 3. Identify which data can be derived from other data.