Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

The system development team at the xyz company is working

The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Invento ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Question find at least two academic sources that describe

Question: Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities that can be conducted in the cloud and the pros a ...

Suppose that you have designed a database for morgan

Suppose that you have designed a database for Morgan Importing that has the following tables: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, ...

Instructionsfor decades relational databases remained

Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...

Systems analysis project scenic routes operates a bus

Systems analysis project Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm nee ...

A taking an unnormalised list describe how you would

(a) Taking an unnormalised list, describe how you would normalise it using the normal forms technique and show how the result of this method is used. (b) You are currently in the process of developing a RDBMS for a natio ...

Database and information retrieval assignment - data

Database and Information Retrieval Assignment - Data Privacy Essay Task - Write an essay (aim for 750 words) that addresses issues associated with data proivacy. Use the Australian Privacy Principles - discussed in class ...

  • 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