Eat Organic Food Business Analysis and Information Management System Development

The case study presented discusses the “Eat organic food” company of Ian and his wife Ruth. The farm completely deals in growing and selling organic vegetables. They currently use a phone based manual system of taking orders from customers. The customers also self-pickup their purchased vegetables. Also their customer base is limited now. They want to expand their business by shifting to an Information based system that will be able to help manage the customer handling and marketing aspects.

ASSIGNMENT COVER SHEET
Student Name: Maddala. Sanath Kumar Reddy
Student ID No.: 23254974
Unit Name: System Analysis and Design
Unit Code: ISY00243
Tutor’s name: Ms Susanne Brun
Assignment No.: 1
Assignment Title: Eat Organic Food
Due date: 14-04-2019
Date submitted: 14-04-2019
Declaration:
I have read and understand the Rules Relating to Awards (Rule 3 Section 18 – Academic
Misconduct Including Plagiarism) as contained in the SCU Policy Library. I understand the
penalties that apply for plagiarism and agree to be bound by these rules. The work I am
submitting electronically is entirely my own work.
Signed: Sanath Kumar Reddy

1 | P a g e
“Eat Organic Food”
business analysis and
Information Management
System Development
A case study analysis
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

2 | P a g e
Table of Contents
Report A
:
Background Information:..........................................................................4
Organisation Chart:...............................................................................6
Business Functions:.................................................................................6
Project Management:...............................................................................7
Gantt chart:............................................................................................8
PERT/CPM Chart:.................................................................................9
Critical Path:..........................................................................................0
Total Duration:.......................................................................................0
System Vision Document:........................................................................1
System Capabilities...............................................................................1
Business Benefits..................................................................................2
Policies:....................................................................................................2
Risk Analysis:...........................................................................................3
Cost Benefit Analysis:..............................................................................4
Report B:
Fact Finding Techniques..........................................................................5
Questionnaire........................................................................................6
Use Case Diagrams.................................................................................8
Brief Use Case Description:.....................................................................8
Full Use Case Description:.....................................................................10
Activity Diagram:....................................................................................12
Entity Relationship Diagram...................................................................13
Database Schemes and format used:....................................................13
Sample Data:.........................................................................................14
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

3 | P a g e
System Sequence Diagram:..................................................................17
Software Options:...................................................................................17
Recommendations.................................................................................19
Conclusion.............................................................................................19
References.............................................................................................20
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

4 | P a g e
Summary:
The case study presented discusses the “Eat organic food”
company of Ian and his wife Ruth. The farm completely deals in growing
and selling organic vegetables. They currently use a phone based
manual system of taking orders from customers. The customers also
self-pickup their purchased vegetables. Also their customer base is
limited now. They want to expand their business by shifting to an
Information based system that will be able to help manage the customer
handling and marketing aspects. They want the system to be able to
automatically take orders from the customers and reduce the ordering
time. The system should display the customers all the available
vegetables in stock and also recommend them vegetables based on
their previous purchases for faster ordering. There are quite a few
people working on the farm along with Ian and Ruth. They all report to
Ian and Ruth and help in different departments from marketing to
production. Ian manages the production aspect and Ruth the marketing.
They are also planning to introduce another information system to
manage the legal paper work for their organic farming issues. The self-
pickup system is now replaced by home delivery to reduce traffic issues.
Overall the farm needs a information management system to handle the
marketing aspect of the business so that more time can be given to the
production part. This will also reduce the need for separate manpower
for each individual departments and increase profit.
Background Information:
The company described in the case study is a small to medium
enterprise which deals with the production of organic food vegetables.
The company is owned by Ian and his wife Ruth. The company first
started in Ian’s home’s backyard but now has shifted to his grandfather’s
farm where Ian had grew up. The farm is quite big in size and has
enough space to run a small production business. Ian manages the
production aspect of the business and Ruth the marketing aspect. The
quality of the organic vegetables is very good and hence has drawn
customers from around the area. The customer ordering system is done
through phone or talking directly. This is a very time consuming process
and has become a problem both for the customers as well as Ian.
The company generally communicates to its customers about the
availability of vegetables a day before the actual delivery date. This
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

5 | P a g e
creates some problem for the customers as they return disappointed not
getting the vegetable of their choice and quality. The delivery system is a
self-delivery system where the customers usually come and collect their
own vegetables. The increase in the number of customers had led to the
hiring of more helping hands for the farm. For taking orders through
phone, Ian hired four people. Chris, Christina, Cathy and Charlie’s job is
to take the customer orders and also help in gardening sometimes. They
reported directly to Ruth. The regular customers were given 20%
discount for their trust. To help with accounts aspect of the farm, Sam
and Samantha were hired to oversee that department. They also
answered directly to Ruth. The self-pickup delivery sytem was abolished
and home delivery was started to avoid the traffic jams caused by
multiple incoming customers. Mark and Marsha were appointed to help
with the home delivery service. Dirk was hired as an assistant to Mark
and Marsha to help with the heavy lifting of the produce boxes. They
were trying to combine the deliveries to reduce the number of trips. Ian
was completely dedicated to serving the production side of the business.
To manage the production side, Noel, Noeletta, Mick and Netta
were hired to help in different aspects of gardening like watering,
fertilizers, pruning, picking, planting and weeding. They all reported
directly to Ian. Ian also hired Tim, Terry and Tina to manage with the
machinery aspect of the production. Tina and Terry both are experts in
operating all types of farming machinery. They both reported to Tim, who
is the machinery manager and in charge of all the farming vehicles. Tim
directly reported to Ian for production and to Ruth for marketing
purposes. Ian is an expert knowledge in machineries and helps Tim is
maintenance of the tractors. John, is the son of Ian and Ruth, who is
studying marketing currently at Southern Cross University. Ruth and Ian
have asked him to help them in developing the Information system for
their business and he has agreed to it. He will work independently and
will report to both Ruth and Ian. On top of that, he has access to all the
information required for him to develop such a system.
The farm owners have also tried to shift towards fruits production
but lacks the necessary space and resources to produce in bulk that is
needed for the commercial market. They are planning to negotiate a deal
with the neighbouring fruit producers to strike an exchange deal where
they will be able to grow fruits in the neighbour’s land and vice versa.
However, their condition is that the production should be completely
organic which seems a little unpractical now but may be possible in
future. All in all, they want to develop an information management
system that will be able to help them solve their marketing problems and
help them shift from manual to automatic ordering system. Ruth also
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

6 | P a g e
wants another or an integrated system which will be able to organise and
handle all the legal paperwork needed to authenticate their organically
produced vegetables.
Organisation Chart:
Figure 1 Organisation chart (Source: created by author)
Business Functions:
This section will help the reader get accustomed to the business
functions of the system. The system will have two main parts. One will
focus on the production aspect and the other will focus on the marketing
aspect of the company. Each of these main divisions will have multiple
sub divisions for the smooth functioning of the system.
For example, the production system can be divided into the following
parts:
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

7 | P a g e
1. Gardening jobs: Done by Noel, Noeletta, Mick and Netta.
2. Operating farming vehicles and machinery: Done by Terry and
Tina
3. Managing the farm vehicles and Machinery: Done by Tim
For example, the marketing system can also be divided into the following
parts:
1. Taking customer orders through phones: Done by Christina, Chris,
Cathy and Charlie.
2. Accounts and record keeping: Done by Samantha and Sam.
3. Pickup and delivery of goods: Done by Mark and Marsha
4. Heavy lifting and sorting of boxes: Dirk (Assistant to Mark and
Marsha)
So from the above examples, a rough idea about the business functions
can be estimated. The functions of the business comes out to be
gardening activities like weeding, pruning, planting, picking and watering,
accounts and book keeping, operating farm vehicles and machineries,
managing and maintenance of those vehicles, taking customer orders
and delivery of the produce. At least the marketing part of the business
functions excluding the delivery needs to be incorporated into the new
Information management system.
Project Management:
This section will likely have some SUB SECTIONS…so give
them each their own header (or sub-header) so that it is easy
for the user …to USE the document by easily being able to find
any given section (or sub section).
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

Gantt chart:
ID Outline
Number
Task
Mode
Task Name Duration Start Finish PredecessorsResource Names Cost
0 0 Eat Organic Food
Information System
133 days Tue
09-04-19
Thu
10-10-19
$195,080.00
1 1 Start Project 1 day Tue 09-04-19Tue 09-04-19 $0.00
2 2 Project Initiation 31 days Wed 10-04-19Wed 22-05-19 $62,480.00
3 2.1 Conduct a series of
staff interviews
5 days Wed
10-04-19
Tue
16-04-19
1 Project
Manager
$6,000.00
4 2.2 Review of farm
records, costs and
purchases
2 days Wed
17-04-19
Thu
18-04-19
3 Project
Manager
$2,400.00
5 2.3 Observing of Business
operations
2 days Wed
17-04-19
Thu
18-04-19
3 Project
Manager
$2,400.00
6 2.4 Interviewing of
customers
1 day Fri 19-04-19 Fri 19-04-19 4 Project
Manager
$1,200.00
7 2.5 Analysis over the
currently used
accounting processes
2 days Fri 19-04-19 Mon
22-04-19
5 Project
Sponsor,Project
Manager
$4,960.00
8 2.6 Study of sample of
orders and payment
transactions
2 days Tue
23-04-19
Wed
24-04-19
6,7 Project
Manager,Project
Sponsor
$4,960.00
9 2.7 Undertaking field
work
2 days Tue
23-04-19
Wed
24-04-19
7 Project
Manager
$2,400.00
10 2.8 Preparing a report for
Ruth and Ian
1 day Thu
25-04-19
Thu
25-04-19
8,9 Subject Matter
Expert
$960.00
11 2.9 Proposing of a
solution
4 days Fri 26-04-19 Wed
01-05-19
10 $0.00
12 2.10 Designing the project
and financial plan
15 days Thu
02-05-19
Wed
22-05-19
11 Project
Manager,Project
Sponsor
$37,200.00
13 2.11 Sanctioning of the
plan
0 days Wed
22-05-19
Wed
22-05-19
12 $0.00
14 2.12 Completion of the
Project Initiation
Phase
0 days Wed
22-05-19
Wed
22-05-19
13 $0.00
15 3 Procurement of
Materials and Technical
Planning
29 days Thu
23-05-19
Tue
02-07-19
$33,120.00
16 3.1 Purchasing of
necessary software
and contacting
technical service
provider
3 days Thu
23-05-19
Mon
27-05-19
14 Project
Manager
$3,600.00
17 3.2 Preparing a
development, testing
and quality analyst
team
5 days Tue
28-05-19
Mon
03-06-19
16 Project
Manager
$6,000.00
18 3.3 Planning for the
technical design of
project
12 days Tue
04-06-19
Wed
19-06-19
17 Development
team
$13,440.00
19 3.4 Setup of computer
systems and
networking
9 days Thu
20-06-19
Tue
02-07-19
18 Development
team
$10,080.00
20 3.5 Completion of the
planning and
procurement phase
0 days Tue
02-07-19
Tue
02-07-19
19 $0.00
21 4 Development of the
Information System
45 days Wed
03-07-19
Tue
03-09-19
$70,600.00
22 4.1 Designing the initial
interface
10 days Wed
03-07-19
Tue
16-07-19
20 Development
team
$11,200.00
23 4.2 Performing the coding
part and designing
database structure
20 days Wed
17-07-19
Tue
13-08-19
22 Development
team,Database
Administrator
$43,200.00
24 4.3 Testing of the code
and necessary
requirements
15 days Wed
14-08-19
Tue
03-09-19
23 Testing Team $16,200.00
25 4.4 Completion of the
Development Phase
0 days Tue
03-09-19
Tue
03-09-19
24 $0.00
26 5 Quality Check Phase 19 days Wed
04-09-19
Mon
30-09-19
$21,680.00
27 5.1 Checking the quality
of the Information
System
10 days Wed
04-09-19
Tue
17-09-19
25 Quality Analyst $11,600.00
28 5.2 Implementing the
necessary
recommendation to
the internal structure
9 days Wed
18-09-19
Mon
30-09-19
27 Development
team
$10,080.00
29 5.3 Completion of the
Quality Check Phase
0 days Mon
30-09-19
Mon
30-09-19
28 $0.00
30 6 Documentation of the
Information System
5 days Tue
01-10-19
Mon
07-10-19
$4,800.00
31 6.1 Preparing of reports 5 days Tue
01-10-19
Mon
07-10-19
28 Subject Matter
Expert
$4,800.00
32 6.2 Showing the reports
to the owner
0 days Mon
07-10-19
Mon
07-10-19
29,31 $0.00
33 6.3 Completion of the
Documentation Phase
0 days Mon
07-10-19
Mon
07-10-19
32 $0.00
34 7 Project Sign-off Phase 3 days Tue
08-10-19
Thu
10-10-19
$2,400.00
35 7.1 Collection of
feedback and making
payments
2 days Tue
08-10-19
Wed
09-10-19
33 Project
Manager
$2,400.00
36 7.2 Project Sign-off 1 day Thu
10-10-19
Thu
10-10-19
35 $0.00
37 7.3 Completion of the
phase
0 days Thu
10-10-19
Thu
10-10-19
36 $0.00
38 7.4 End Project 0 days Thu
10-10-19
Thu
10-10-19
37 $0.00
Project Manager
Project Manager
Project Manager
Project Manager
Project Sponsor,Project Manager
Project Manager,Project Sponsor
Project Manager
Subject Matter Expert
Project Manager,Project Sponsor
22-05
22-05
Project Manager
Project Manager
Development team
Development team
02-07
Development team
Development team,Database Administrator
Testing Team
03-09
Quality Analyst
Development team
30-09
Subject Matter Expert
07-10
07-10
Project Manager
10-10
10-10
M T W T F S S M T W T F S S M T W T F S S M T W T
01 Apr '19 22 Apr '19 13 May '19 03 J un '19 24 Jun '19 15 Jul '19 05 Aug '19 26 Aug '19 16 Sep '19 07 Oct '19
Figure 2 Gantt chart (Source: Created by Author)

9 | P a g e
PERT/CPM Chart:
Figure 3 PERT/CPM diagram (Source: Created by Author)
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR ORGANIC FOOD PRODUCTION INDUSTRY

10 | P a g e
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR ORGANIC FOOD PRODUCTION INDUSTRY

Critical Path:
The activities, which are highlighted in red would be considered as
the critical path. The activities that have slack as zero are also
considered as the critical path activities.
Total Duration:
The total duration of the project is estimated to be 133
days. (Note: Please refer to the attached Ms Project file for the
detailed analysis)

1 | P a g e
System Vision Document:
The system vision document is an important document that keeps
track of all the problems of the current systems and what new changes
are needed to be implemented for improving those problems. It also
documents the benefits of the given company after implementing the
solutions. The company in our case study is a small farm business
dedicated to producing organic vegetables. The business is currently
running all its marketing aspects manually, from taking orders to delivery
of products. This part of the document can be divided into the following
three parts:
Problem Description
The main problem faced by the system is in the marketing division
of the company. The farm business is still using manual methods for
taking the order from customers. This is being done with the help of
phones. This process results in the slower delivery of the goods. It
also increases the time taken for registering the order and writing it
down. This creates a problem for the customers as they have to wait
longer durations just to give an order for their goods. This also wastes
a lot of time for the owner Ian who can better spend this time trying to
increase the production of organic vegetables. Even for registering
the same orders the customers had to wait for longer duration. The
customers want a quicker way to order and simplify the process. The
farm is mainly dedicated to producing organic food so it needs to
produce a lot of paperwork as proof for its operations authenticity.
The business owners also wants to expand their business to the fruit
market by investing and producing commercial grade fruits. This
needs to be adapted to the information management system is easy
verification. Either a new system or integrating into the old system
would be fine.
So, to conclude a new information management system needs to
be created that will be capable enough of handling the marketing
operations of the farm business and also handle the organic
paperwork for easy authentication and increased customer
satisfaction.
System Capabilities
The system that is being designed should be able to do the following
tasks:
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

2 | P a g e
 The system should be able to take the orders of the customer
online over the internet.
 The system should be able to keep track of individual customer’s
orders and recommend the same to them when they buy again.
 The system should also maintain a track of regular customers and
offer them discounts on purchases.
 The system should also be able to handle the transaction aspects
of the business and maintain the accounts.
 The system should be able to able to club multiple deliveries while
delivering, in order to save time and cost.
 The system should be able to devise strategies for fruits
production.
Business Benefits
If this system is implemented the following benefits can be achieved:
 The business would be able to take orders from more customers
thus resulting in increased profit.
 The owner of the business Ian would be able to give more time to
production thus increasing his produce.
 The business would be able to keep track of the payments and
recover dues on time.
 The business would be able to provide faster processing times
thus increasing customer satisfaction by decreasing wait time.
 The system would be able to notify the customers about their
favourite products when restocked, thus increasing sales.
 The expansion of business to the fruit market can generate extra
revenues.
Policies:
The following policies can be implemented for the following categories of
people:
1. Customers:
 The customers should be provided with faster processing
times in case of repeated orders every week.
 The regular customers can be provided with extra discounts
when purchasing products to retain them.
 The customers can be provided with home deliveries as this
will be convenient for them.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

3 | P a g e
2. Employees:
 The employees of the farm can be given extra incentives for
doing work with extra dedication.
 Employees who are helping in two different departments
should be paid more to retain them.
 The employees can be provided with a token of organic
vegetables every week.
Risk Analysis:
There are many risks associated with the project. The main ones are
listed below:
 The “organic” tag of the food is the main reasons people are
buying from the farm. The food must be kept organic at all costs.
 The project will need a proper budget to be developed which
needs to be decided beforehand.
 The requirements for the project must be clear as per the system
vision document.
 Technical assistance from trained individuals should be used while
developing the information management system.
 The project must be planned properly and any missing
requirement either functional or non-functional may result in the
failure of the system.
 Valid documentation should be kept aside for proving that the
production is organic.
 All organic manure should be used so as to not risk the “organic”
production tag.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

4 | P a g e
Cost Benefit Analysis:
Year of Project
year 0 year1 year 2 year 3 year 4 year 5 TOTALS
Net economic benefit $0.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00
Discount Rate 8% 1 0.9259 0.8573 0.7938 0.7350 0.6806
PV Of Benefits $0.00 $37,037.04 $34,293.55 $31,753.29 $29,401.19 $27,223.33
NPV of all BENEFITS $0.00 $37,037.04 $71,330.59 $1,03,083.88 $1,32,485.07 $1,59,708.40 $5,03,644.98
One Time Costs $95,600.00
Recurring Costs $0.00 $100.00 $100.00 $100.00 $100.00 $100.00
Discount Rate 8% 1.0000 0.9259 0.8573 0.7938 0.7350 0.6806
PV Of Recurring Costs $0.00 $92.59 $85.73 $79.38 $73.50 $68.06
NPV Of All Costs $95,600.00 $95,692.59 $95,778.33 $95,857.71 $95,931.21 $95,999.27 $5,74,859.11
Overall NPV ($71,214.13)
Overall ROI = (Overall NPV / NPV Of All Costs -0.12
Break-Even Analysis
Yearly NPV Cash Flow $0.00 $36,944.44 $34,207.82 $31,673.91 $29,327.69 $27,155.27
Overall NPV Cash Flow $95,600.00 ($58,655.56) ($24,447.74) $7,226.17 $36,553.86 $63,709.13
Project break-even occurs between years 2 and 3
Use 1st year of positive cash flow to calculate break-even fraction 2.7719 years
Figure 4 Cost benefit analysis (Source: created by author)
Expected cost:
Project Initiation 62480
Procurement of Materials and Technical Planning 33120
Development of the Information System 70600
Quality Check Phase 21680
Documentation of the Information System 4800
2400
Total Cost for the project 195080
Total Cost for the project
Report B
Fact Finding Techniques
Except the interview technique, there are many other techniques that
can be used for carrying out data collection while developing a system
(Ekblaw et al. 2016). The information system that is to be built for the Eat
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

5 | P a g e
Organic Food might undertake for collecting the data. The list of the fact
finding techniques that can be used by the developers for developing the
new information system for the Eat organic food are explained below:
a. Studying or sampling the documents that exists in that system.
b. Observing the work environment where farming is done.
c. Creating Questionnaires
d. Applying JAD (Joint Application Development)
e. Applying RAD (Rapid Application Development)
As the information analyst of the organic farm, all the above
mentioned techniques are to be used that are used for making the
information system of the organic farm. It is not mandatory to use all the
technique (Dillon 2015). The technique that the system analyst thinks
bets to use can be used for carrying out the fact-finding method for the
information system.
The first technique involves studying or sampling technique where all the
previous documents related to the business operation of the organic
farm are documented. The Eat Organic Food has many documents that
states the working process of the organization (Coronel and Morris
2016). With the increasing of business, Ian and Ruth has appointed
many other helping hands for carrying out the business. All those
documents are to be studied for carrying out the sampling and studying
fact finding technique.
Another fact finding method that can be used for developing the
information system of Eat Organic Food is visiting site technique. This
method can be used by the analyst to visit the site of the Eat Organic
Food and gathering the requirements that the Ian and Ruth wants for
improving the system of information system (Cash et al. 2014). By site
visiting, the data related with the system can be collected. This
technique is very much reliable and is inexpensive method for data
collecting. This method also increases experience of the business
analyst.
Another fact funding technique that can be used in the business
operations of Eat Organic Food is Rapid Application Development. This
mainly helps to create forms and tables related to what is done in the
system. The users in the system suggests the prototype of the system
and help the system analyst to develop the prototype (Cai and Modest
2014). This information system is basically a user centric system and will
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

6 | P a g e
be developed according to the requirement of the user. This helps to
reduce the risks in the system.
Questionnaire
Type of
Question
Questions to be asked
Closed End
Questions
1. Are you an employee of this framing
organizations?
Open End
Questions
2. From when are you working in this business?
Closed End
Questions
3. Are you enjoying the working that is one here?
Open End
Questions
4. Is the vegetables and fruits that are grown in this
farm are totally organic?
Open End
Questions
5. How much time a day do you work in this farm?
Closed End
Questions
6. Are you satisfied with the work and facilities that
are provided to you?
Open End
Questions
7. What are the kind of crops that are grown in the
farm?
Closed End
Questions
8. Is the packaging of the vegetables done properly
while delivering?
Open End
Questions
9. Who attends the customers in this system?
Closed End
Questions
10. Do customers comes regularly for buying
vegetables?
Closed End
Questions
11. Does regular customers get discount on their
buying?
Closed End
Questions
12. Does the customers give similar kind of order
daily?
Open End
Questions
13. How delivery is done to the customers?
Open End
Questions
14. Is growing of vegetables changes with season
only or on daily basis?
Open End
Questions
15. Which vegetables are on high demand from the
customers?
Closed End
Questions
16. Is the delivery done on time as expected by the
customers?
Open End
Questions
17. Who maintains the inventory of the business?
Open End
Questions
18. How the quality of the vegetables checked and
who is responsible for checking the vegetables?
Closed End 19. Is there any need for making the system
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

7 | P a g e
Questions automatic?
Closed End
Questions
20. Do you think that information system is
appropriate for maintaining all the processes in the
business?
Rhetorical
questions
21. Do you want to expand your business?
Closed End
Questions
22. Do you think implementation of this information
system will solve all the problems that exists in the
business?
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

8 | P a g e
Use Case Diagrams
Figure 1: Use Case Diagram
(Source: Created by Author)
Brief Use Case Description:
Use Case Descriptions
Customer sign
up
The customer signs up to the information system of
registering their names in the system. While signing up,
the customer needs to input all their details including
their names, phone number, email address, delivery
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

9 | P a g e
address, and phone number. The phone number that
the customer provides should be valid as it will be
needed at the time of delivery and will also be used for
any query to be asked to the customers. There should
also be a landmark provided for the delivery address so
that the delivery can be done properly.
Customer
searches the
products
After log in the customer reaches the home page of the
website of GYB. The home page consists of many
items that are available presently in the farm. The
customer searches the items and selects the products
on the basis of their needs and adds them to cart.
Payment
procedure
after ordering
The customer makes the payment after selecting the
items in the cart. The customer has more than one
option to pay to the farm. All the options are involved in
the use case.
Staff makes
the delivery of
product
After the customer orders the product and if selected
home delivery option, then the delivery is done from the
farm. The delivery is done by the staffs who are
employed in the farm to make the delivery. For making
the delivery, the delivery address must be right.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

10 | P a g e
Full Use Case Description:
Use Case
Name
Ordering System of EAT ORGANIC FOOD
Scenario The customer orders products from the farm
Triggering
Event
The customer selects the product from the menu and
adds them to cart.
The customer needs to add the system in the cart for
proceeding with the ordering system.
Brief
Description
The customer makes the payment after selecting the
items in the cart. The customer has more than one
option to pay to the farm. All the options are involved in
the use case.
Actors The customer is the main actor in this use case.
Related Use
Case
Similar to other use case that are available online
Stakeholders The stakeholders that are involved in this use case is
customer, farm head Ian, the farm hands and delivery
boy who is responsible for delivery.
Pre-
conditions
The pre-conditions that are to be fulfilled for using this
use case is to sign in to the system as a new user or log
in to the system. If the log in is successful, then only the
customer con go to the home page for viewing the
details of the product that are available.
Post-
Conditions
The post conditions that are required is that after adding
those items in their cart, the customer has to select a
payment option for completing the ordering procedure.
The customer can pay at the time of ordering or can pay
at the time of delivery.
Flow of
Activities
Actors System
Customer 1. Customer selects all the items
needed by them from the menu.
2. The system displays all the items
that are available in the farm
inventory.
3. The customer can also select
items from their previous orders or
can repeat the same order that had
been ordered previously.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

11 | P a g e
4. The system adds all the items that
are selected a shows the total
amount as a bill to the customer.
Exception
Condition
1. If the items are not available, then the customer
cannot add the item in their cart.
2. For ordering the items the customer needs sign up to
the system as a regular customer or standard customer.
3. The delivery address that is entered at the time of
ordering should be correct as the delivery will be made
to that address only.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

12 | P a g e
Activity Diagram:
Figure 2: Activity Diagram
(Source: Created by Author)
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

13 | P a g e
Entity Relationship Diagram
Figure 3: Entity Relationship Diagram
(Source: Created by Author)
Database Schemes and format used:
Table
Name
Attributes Data type
(Size)
Foreign
Key
Primary
Key
farm farm_id int (20) cust_id,
staff_id
farm_id
farm_head Varchar
(30)
farm_address Varchar
(50)
farm_pin Int (06)
farm_locality Varchar
(50)
cust_id Int (20)
staff_id Int (20)
customer cust_id Int (20) order_id cust_code
cust_name Varchar
(30)
cust_address1 Varchar
(50)
cust_address2 Varchar
(50)
cust_pincode Int (06)
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

14 | P a g e
cust_landmark Varchar
(30)
cust_email Varchar
(30)
cust_phone Int (10)
cust_status Varchar
(30)
order_id Int (20)
staff staff_id Int (20) staff_id
staff_name Varchar
(30)
staff_address1 Varchar
(50)
staff_pincode Int (06)
staff_phone Int (10)
staff_type Varchar
(30)
vegetables product_id Int (20) product_id
product_name Varchar
(30)
product_type Varchar
(30)
cost_per_unit Int (05)
product_description Varchar
(100)
order order_id Int (20) cust_id,
product_id
order_id
product_id Int (20)
cust_id Int (20)
expected_delivery Int (20)
Sample Data:
Table
Name
Attributes Data
type
(Size)
Sample data
farm farm_id int (20) 1234
farm_head Varcha
r (30)
Mary Jhones
farm_address Varcha 79 Quintin Street
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

15 | P a g e
r (50)
farm_pin Int (06) 5655
farm_locality Varcha
r (50)
NEURUM QLD
cust_id Int (20) 0123
staff_id Int (20) 0234
customer cust_id Int (20) 0123
cust_name Varcha
r (30)
Hayley Goldman
cust_address1 Varcha
r (50)
2 Chester Street
cust_address2 Varcha
r (50)
NEW BRIGHTON NSW
cust_pincode Int (06) 2483
cust_landmark Varcha
r (30)
2nd street
cust_email Varcha
r (30)
HayleyGoldman@jourrapide.c
om
cust_phone Int (10) [phone]
cust_status Varcha
r (30)
Regular
order_id Int (20) 6789
staff staff_id Int (20) 0234
staff_name Varcha
r (30)
Spencer Birks
staff_address1 Varcha
r (50)
57 Quintin Street
staff_pincode Int (06) 4512
staff_phone Int (10) [phone]
staff_type Varcha
r (30)
Delivery Boy
vegetable
s
product_id Int (20) 4567
product_name Varcha
r (30)
potato
product_type Varcha
r (30)
Root vegetables
cost_per_unit Int (05) 30
product_descripti
on
Varcha
r (100)
Fresh potatoes grown
organically
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

16 | P a g e
order order_id Int (20) 6789
product_id Int (20) 4567
cust_id Int (20) 0123
expected_deliver
y
Int (20) The delivery is expected
within 2 days
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

17 | P a g e
System Sequence Diagram:
Figure 4: Sequence Diagram of Eat Organic Food
(Source: Created by Author)
Software Options:
There are many commercial software packages that are available online
and can help Eat Organic Food to launch their official website. Some of
the names that can be suggested for the commercial packages are given
below:
a) Maria DB
b) Firebird
c) PostgreSQL
d) Database Deployment Manager
e) Apache HBase
f) MongoDB
g) MySQL
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

18 | P a g e
h) SQLite
Two software packages that can be used by the Eat Organic Food for
launching their website are compared in the following section.
Firebird is a particular software package that is considered to be an open
source of SQL RDBMS. This particular software package mainly runs on
Microsoft Windows, Linux, MacOSX, Unix Platforms that helps to
support the procedures that are stored in the system and can also be
used to trigger the events (Cahill et al. 2017). This software package
provides many features. ACID transactions is provided by this software
that helps to satisfy all the process of transaction in the system. This
engine database also helps the organization to keep many versions that
are actually recorded for a particular transaction for all the active users in
the database. When a particular transaction gets complete, all the
records that are changed in a transaction are then marked. This
particular software package includes referential integrity with the MVCC
architecture. All external functions are supported by this package and
also supports the SQL activity that helps to send many number of events
that are asynchronous to the users associated with the system. This
system also includes third party involvement that mainly includes the
GUI administration tool along with the replication tool (Brettin et al.
2015). This particular software package support fast recovery and no
transaction logs are included in the system. Many methods can be used
for accessing the methods such as API, .NET provider, OLE DB, python
moule, JDBC, PHP, dbExpress/FireDAC drivers, and Perl. Incremental
backups are kept in the system along with implementation of the cursor
in PSQL.
Another software package that can be used for the information system of
Eat Organic Food is MariaDB. This includes a fork of developed with the
help of community. This is mainly done by the MySQL RDBMS that
helps to stay free under the GPL (Alles et al. 2018). This particular
development is actually led by many original developers who are related
to MySQL. This can happen because of concern occurred due to
acquisition by Oracle Corporation. The MariaDB mainly helps to maintain
some high compatible MySQL that helps to ensure the replacement with
binary library parity and includes exact matching with the APIs of
MYSQL along with the commands (Bailis et al. 2014). This software
package mainly includes engine named as XtraDB storage that helps in
replacing the InnoDB as well as the system of new storage which is
known as Aria. This software package is used in transactional and with
the non-transactional system of the Eat Organic Food and includes
MySQL.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

19 | P a g e
Recommendations
For the Eat Organic Food, it can be recommended to the system analyst
to include in house development in the system so that the social media
can be included in the system. This will help the organization to attract
many customers with some features that provides new services to the
customers. For developing this system, two commercial packages can
be used that is MongoDB as well as MySQL.
Conclusion
This above report states the designing phase of the information system
for the Eat Organic Food. As Ian and Ruth wants to increase their
business operations and wants to handle their operations automatically,
the system design should be done carefully so that the business analyst
can develop the system more efficiently. This report states the use case
diagram of different actors and activities involved in the information
system of the Eat Organic Food. There is also an ERD, an activity
diagram and a sequence diagram that might help the reader to imagine
the system that is to be developed for the Eat Organic Food.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

20 | P a g e
References
Alles, M., Brennan, G., Kogan, A. and Vasarhelyi, M.A., 2018.
Continuous monitoring of business process controls: A pilot
implementation of a continuous auditing system at Siemens.
In Continuous Auditing: Theory and Application (pp. 219-246). Emerald
Publishing Limited.
Bailis, P., Fekete, A., Franklin, M.J., Ghodsi, A., Hellerstein, J.M. and
Stoica, I., 2014. Coordination avoidance in database
systems. Proceedings of the VLDB Endowment, 8(3), pp.185-196.
Brettin, T., Davis, J.J., Disz, T., Edwards, R.A., Gerdes, S., Olsen, G.J.,
Olson, R., Overbeek, R., Parrello, B., Pusch, G.D. and Shukla, M., 2015.
RASTtk: a modular and extensible implementation of the RAST
algorithm for building custom annotation pipelines and annotating
batches of genomes. Scientific reports, 5, p.8365.
Cahill, L.S., Carey, L.M., Lannin, N.A., Turville, M. and O'Connor, D.,
2017. Implementation interventions to promote the uptake of evidence‐
based practices in stroke rehabilitation. Cochrane Database of
Systematic Reviews, (3).
Cai, J. and Modest, M.F., 2014. Improved full-spectrum k-distribution
implementation for inhomogeneous media using a narrow-band
database. Journal of Quantitative Spectroscopy and Radiative
Transfer, 141, pp.65-72.
Cash, D., Jaeger, J., Jarecki, S., Jutla, C.S., Krawczyk, H., Rosu, M.C.
and Steiner, M., 2014, February. Dynamic searchable encryption in very-
large databases: data structures and implementation. In NDSS (Vol. 14,
pp. 23-26).
Coronel, C. and Morris, S., 2016. Database systems: design,
implementation, & management. Cengage Learning.
Dillon, D.M., RPX Corp, 2015. Software framework that facilitates design
and implementation of database applications. U.S. Patent 9,009,195.
Ekblaw, A., Azaria, A., Halamka, J.D. and Lippman, A., 2016, August. A
Case Study for Blockchain in Healthcare:“MedRec” prototype for
electronic health records and medical research data. In Proceedings of
IEEE open & big data conference (Vol. 13, p. 13).
Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems.
London: Pearson.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY

21 | P a g e
Groomer, S.M. and Murthy, U.S., 2018. Continuous auditing of database
applications: An embedded audit module approach. In Continuous
Auditing: Theory and Application (pp. 105-124). Emerald Publishing
Limited.
Just, R., Jalali, D. and Ernst, M.D., 2014, July. Defects4J: A database of
existing faults to enable controlled testing studies for Java programs.
In Proceedings of the 2014 International Symposium on Software
Testing and Analysis (pp. 437-440). ACM.
Minker, J. ed., 2014. Foundations of deductive databases and logic
programming. Morgan Kaufmann.
Rajakumari, S.B. and Nalini, C., 2014. An efficient data mining dataset
preparation using aggregation in relational database. Indian Journal of
Science and Technology, 7(S5), pp.44-46.
Smirnov, A.V., 2015. FIRE5: a C++ implementation of Feynman Integral
REduction. Computer Physics Communications, 189, pp.182-191.
Tamm, S. and Kimberlin, S., salesforce. com Inc, 2014. Virtual objects in
an on-demand database environment. U.S. Patent 8,819,060.
INFORMATION MANAGEMENT SYSTEM DEVELOPMENT FOR
ORGANIC FOOD PRODUCTION INDUSTRY