Ask DBMS Expert


Home >> DBMS

Case Study: Gap Filler

Gap Filler is a recruitment and labour hire company (i.e., ‘staffing solutions') that services the agricultural and food processing industries in regional Victoria. Gap Filler provides short-term and temporary labour to farmers, horticulturalists, orchardists, vineyards, and a range of food and beverage packaging and processing businesses.

For example, during the apple harvest, Gap Filler provides fruit pickers to orchardists and personnel to work in apple packaging and processing plants. Gap Filler also recruits personnel for permanent positions (e.g., farm workers and managers, and supervisors for packaging and processing facilities). Gap Filler started in 1997 as a small family run business based in Shepparton, approximately 200 km north-east of Melbourne. Gap Filler has gradually developed business operations across regional Victoria and has offices located in Hamilton, Swan Hill, Sale, and Warrnambool. The Shepparton office serves as the head office for Gap Filler and this is where the accounts and the senior management team are located.

The company employs 48 staff in a variety of fulltime and part time roles. Gap Filler recorded turnover of just over $16 million for the financial year ended 2013. The Gap Filler sales team have successfully developed ongoing business relationships with a variety of large and smaller businesses. Unfortunately much of this sales information and marketplace intelligence resides with sales team members rather than captured by any company information system. An ongoing challenge for the business is matching its supply of reliable workers available for hire to the seasonal and fluctuating demand of its customers. Keeping up to date records on over 400 workers' availability, contact details, currency of certifications for operating equipment (e.g., heavy vehicles, forklifts, and loaders), and how well the workers are performing on the job is also a challenge. Currently this worker information is stored on a Microsoft Access database which struggles to meet the business's needs.

Moreover, Gap Filler's administrative staff are required to manually transfer much of this worker information from hard copy forms and emails into the Access database. Companies using Gap Filler's workers email through the number of hours clocked up each week. Gap Filler would like to improve the systems used for managing worker information and recording workers hours.

About eight years ago the company invested in a labour hire and sales system (Filler-IT). Unfortunately the Filler-IT system is becoming increasingly difficult to maintain. The Filler-IT system has also proved difficult to modify for the changing business environment. Moreover, the business wishes to take labour hire bookings, record workers' hours, and payments via the internet. Unfortunately, the Filler-IT system does not readily support online transactions. The business uses QuickBooks (Enterprise version) to run its accounts. For general computing requirements, the company operates desktop and laptop computers operating Microsoft Vista and Office 2007.

The company's directors recognise that a review of the Gap Filler's business information system needs is required, especially given that the Filler-IT system is getting to the end of its useful life. You have been asked by the Gap Filler's directors to write a preliminary report that: (a) outlines the company's business information system (BIS) requirements, and (b) makes recommendations on the core systems that would meet these BIS requirements.

Key questions to address:

1. What are the main activities that the business undertakes?

2. Where in the business are the crucial decisions made?

3. What types of information does the business require to operate successfully?

4. What are the requirements for the:
a. transaction processing system?
b. sales and customer relationship management (CRM)?
c. inventory?
d. planning and scheduling?
e. accounts?
f. decision support and management information systems?

5. What are the different types of business information systems that could be used to effectively meet these requirements?

6. What core information systems do you recommend the business adopt?

You are free to structure the report as your group see fit. Your aim should be to produce a report that follows a logical order taking the reader from a situational analysis to your group's recommendations and the rationale for these. A suggested structure for this report follows.

1. Introduction
2. Description of the business
3. The key information required to successfully operate the business
4. BIS requirements
5. Recommended information systems and how these will meet business requirements

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9743592

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As