FINM037: Managing Information
Scenario
Dawn Inc. Group
Having graduated in Industrial Management, Dawn found a post with Sahar Chemicals in Saudi Arabia.
After ten years with the company, having risen to the post of project director Dawn left the company to form her own firm, specialising in dealing with oil spills at sea.
Over the years the company increased in size and also diversified, buying out a number of other companies at appropriate points of time. At the present moment the company consists of:
- a) Dawn Inc- the parent company;
- b) Bugoff Chemical Company – production of pesticides, the chief product being Malabug;
- c) Maxoil – Midland’s largest petrol distributor.
Management of the parent company is concerned about the high staff turnover during recent years. To find out about the current degree of job satisfaction among employees a study has been sponsored by the company to determine the level of job satisfaction of employees within the Group.
As part of the study, 50 employees were asked to indicate their job satisfaction in their work, in their pay and in their opportunities for promotion. Each of the three aspects of job satisfaction was measured on a scale of 1 to 100, with larger values indicating higher degrees of satisfaction.
Data was also collected (see the following table) on the age, gender, distance from home, and the company within the Group where each employee was employed, coded B, D and M.
| Employee |
Age |
Gender |
Distance from home (miles) |
Satisfaction Scores |
|||
| Work |
Pay |
Promotion |
Company Type | ||||
| 1 | 26 | F | 6 | 71 | 49 | 58 | D |
| 2 | 17 | M | 8 | 84 | 53 | 63 | M |
| 3 | 19 | F | 12 | 84 | 74 | 37 | D |
| 4 | 29 | F | 2 | 87 | 66 | 49 | M |
| 5 | 31 | F | 7 | 72 | 59 | 79 | M |
| 6 | 32 | M | 4 | 72 | 37 | 86 | D |
| 7 | 18 | M | 22 | 72 | 57 | 40 | B |
| 8 | 20 | F | 5 | 63 | 48 | 78 | D |
| 9 | 30 | F | 1 | 72 | 76 | 37 | D |
| 10 | 22 | F | 3 | 71 | 25 | 74 | B |
| 11 | 27 | F | 7 | 69 | 47 | 16 | M |
| 12 | 33 | M | 11 | 90 | 56 | 23 | M |
| 13 | 19 | M | 4 | 84 | 28 | 62 | B |
| 14 | 28 | F | 3 | 86 | 37 | 59 | D |
| 15 | 24 | F | 6 | 70 | 38 | 54 | B |
| 16 | 38 | M | 2 | 86 | 72 | 72 | D |
| 17 | 17 | F | 16 | 84 | 60 | 29 | D |
| 18 | 17 | F | 3 | 90 | 62 | 66 | B |
| 19 | 32 | F | 5 | 73 | 56 | 55 | D |
| 20 | 26 | M | 6 | 94 | 60 | 52 | D |
| 21 | 27 | M | 1 | 84 | 42 | 66 | B |
| 22 | 24 | F | 4 | 85 | 56 | 64 | B |
| 23 | 23 | M | 4 | 88 | 55 | 52 | M |
| 24 | 22 | F | 10 | 74 | 70 | 51 | M |
| 25 | 27 | F | 8 | 71 | 45 | 68 | B |
| 26 | 29 | F | 2 | 88 | 49 | 42 | B |
| 27 | 37 | F | 16 | 90 | 27 | 67 | D |
| 28 | 28 | M | 4 | 85 | 89 | 46 | M |
| 29 | 29 | M | 2 | 79 | 59 | 41 | M |
| 30 | 18 | F | 3 | 72 | 60 | 45 | B |
| 31 | 19 | M | 5 | 88 | 36 | 47 | B |
| 32 | 19 | F | 1 | 77 | 60 | 75 | B |
| 33 | 35 | F | 6 | `64 | 43 | 61 | B |
| 34 | 25 | M | 4 | 87 | 51 | 57 | B |
| 35 | 20 | F | 5 | 77 | 90 | 51 | M |
| 36 | 33 | M | 1 | 71 | 36 | 55 | M |
| 37 | 20 | F | 13 | 75 | 53 | 92 | M |
| 38 | 24 | M | 26 | 74 | 59 | 82 | B |
| 39 | 27 | F | 4 | 76 | 51 | 54 | M |
| 40 | 21 | F | 6 | 95 | 66 | 52 | D |
| 41 | 18 | F | 9 | 89 | 66 | 62 | B |
| 42 | 25 | M | 2 | 85 | 57 | 67 | B |
| 43 | 25 | F | 1 | 65 | 42 | 68 | D |
| 44 | 24 | F | 3 | 82 | 37 | 54 | D |
| 45 | 25 | F | 9 | 82 | 60 | 56 | D |
| 46 | 29 | M | 4 | 89 | 80 | 64 | M |
| 47 | 19 | F | 1 | 74 | 47 | 63 | B |
| 48 | 18 | F | 3 | 82 | 49 | 91 | B |
| 49 | 36 | F | 7 | 90 | 76 | 70 | D |
| 50 | 21 | M | 15 | 78 | 52 | 72 | D |
Task 1
You have been asked by management to set up a small database from scratch which will hold information on employees, the results of the survey on job satisfaction and the skills they have acquired to date.
Illustrate your model by showing how the entities are linked together. Explain the purpose of the primary and foreign keys and show clearly the attributes for each of the entities.
Give four examples of the types of reports that could be produced using this small database, showing clearly the layout of each with data included, and specify the purpose of each. Clearly state the benefits of your reports for management decision making.
Task 2
Design an online form that will allow the capture of new and existing employee details. Typical details should include starting qualifications and skills upon entry, a history of skills and qualifications acquired during their employment etc.,
Your design should show clearly how employees can navigate through the dialogue, and correct any mistakes. It is important that you understand what data needs to be entered for employees and to help with this, think about what information you need to get out of the system in order to help with decision making and the smooth running of the organisation.
Include any validation and verification of input and justify your design. Your design should include ‘user friendly’ features.
Ensure you incorporate security features into your design.
Task 3
It has already been identified that the management of the parent company is concerned about the high staff turnover over the last few years. A survey was carried out and information gathered (table 1).
You have already carried out some preliminary analysis on this data but feel you need to gather more information regarding staff turnover.
Discuss what additional information you will need to gather to help identify the problem and critically discuss what fact gathering techniques you think appropriate to achieve this.
Task 4
The Head of Human Resources has identified a requirement for a report that shows, for each company, a summary of the satisfaction scores for the three categories shown in the table in Task 1 and mentioned in Task 4. The report should also group these satisfaction scores in age groupings (18-21, 22-29, 30-39, 40+) for each company and clearly show the difference in scores between Male and Female within company. Justify your design and explain the benefits this type of report will have for management. Use ‘dummy’ data to show clearly the layout of the report.
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
