Business Systems Analysis

INFS 5093

SP5 2019 Systems Design Assessment

Introduction

This document extends the instructions on the course website. Read the instructions on the course website in addition to this document.

This assessment consists of

A case study which requires you to apply your learning from the systems design module.

An analysis of professional ethics which requires you to consider the ACS Code of Ethics and the ACS Code of Professional Conduct, and to apply one of the readings provided on the course website.

A conceptual development section which requires you to consider how systems design tasks impact on a systems development project.

A learning reflection which requires you to identify what you learned from this assessment and from the reviews you received from your peers, and to relate these learning outcomes to the UniSA Graduate Qualities.

The feedback sheet lists the assessment criteria. Look for it on the assessment’s webpage. Take note of which sections carry the most marks.

Note that this assessment’s word count is 3375 without your answers, so

Don’t worry if the final word count seems high.

Also, there are some diagrams in this assessment so don’t worry if your final word count seems low.

Finally, this means every submission will have 3375 words exactly the same. Therefore, the similarity score generated by Turnitin may seem high. If you kept to high standards of academic integrity when preparing your answers, there will be no need for concern.

Draw the diagrams by hand, photograph, and insert the photographs in this file. If you prefer, you can use Word’s drawing tools (or some other drawing or modelling software) but you may find working with pen and paper is faster, easier to amend, less cumbersome, and more reliable with respect to layout.

When referring to the exemplars on the course website, read the old assessment specifications carefully because the assessments differ every study period.

Instructions

This is an individual assessment.

In the previous study period, students spent an average of 29 hours on this assessment.

Pace yourself accordingly.

For best results

Do not attempt to complete the whole assessment in one session.

Work slowly and carefully.

In addition to the instructions on the course website

Do not overlook the ‘Why?’ questions.

Read the case study carefully.

Keep track of the hours you spend.

Make assumptions where necessary. Scope for assumptions has been deliberately included in this assessment because it is often necessary to make assumptions openly when dealing with a client who is under-informed with respect to information systems. Label assumptions clearly. Here’s an example from a previous study period,

Assumption: As the passengers of Titanic II may be from any nation, I have assumed a currency converter is required for the ticket-purchasing function.

Case study: Snacks Now

From the Systems Planning assessment

Dionne Worontschak and John Sawitt own and manage an independent supermarket in the inner suburbs of Adelaide, South Australia. They believe in hard work and acting to capture business opportunities. Neither of them went to university, but John holds a Certificate IV in business management from TAFE.

They have developed a business concept and it is ready for systems planning. The concept is Snacks Now.

Dionne and John have contracted IT Foundry for systems development. You are a systems analyst working at IT Foundry and your manager has allocated to you the systems planning tasks for the Snacks Now project.

Snacks Now will offer home deliveries of groceries or fast food to customers who order via a website or smartphone app. Customers will be able to ‘like’ Snacks Now on Facebook and follow Snacks Now on Twitter; also they will be able to share and tweet their orders. When customers share or tweet an order they will accrue social points and once the points reach a certain level, customers will be rewarded with a 20% discount on their next order.

Customers will also accrue loyalty points with every purchase. When a customer’s loyalty points reach a particular threshold, they receive a $20 discount on their next purchase.

The menus of participating fast food outlets will be available via Snacks Now. Any groceries that are available in Dionne and John’s supermarket can be delivered, including dairy, delicatessen, fruit and vegetables. An online menu will be compiled from the supermarket’s inventory system and from the online menus of participating fast food outlets. When customers place an order, they pay via PayPal.

Prices will be automatically updated once a week, on Wednesdays. Prices will account for all ongoing costs, plus a 5% profit margin, some of which will recoup start-up costs.

Snacks Now will operate Thursday-Sunday nights from 8pm to 5am. If the Snacks Now business concept is successful and opportunity to expand exists, additional hours or nights will be added.

As Dionne and John work full time on running the supermarket, they will hire a junior manager who will be responsible for the day-to-day management of Snacks Now. Dionne and John expect to hire one driver in the first instance. If Snacks Now expands, additional positions will be created. The junior manager will be based in the supermarket. He or she will be responsible for compiling orders and handling any issues that arise. The driver will collect an order from the supermarket or from participating fast food outlets. Then, he or she will deliver the order to the address specified by the customer. If no one is home, the order will be left by the front door.

As Snacks Now is the first service offering such a wide range of delivered items in Adelaide, there is limited competition. However, it is important that the technology is available as soon as possible in order to capture early adopters. A social media viral marketing campaign is being designed by a local advertising company.

 

Finally, you present your findings to your manager and to Dionne and John. Your manager and clients have requested a 15-minute presentation.

You have completed systems planning and Dionne and John have approved the plan you prepared and they have requested progress to the systems analysis phase of the Snacks Now project.

At IT Foundry, you have a regular lunch with one of your colleagues, Tanya Collins, who is an old friend from your days as a uni student. At your next lunch, you discuss the Snacks Now project: your recent project planning success, your forthcoming systems analysis tasks and the various plans Dionne and John have for Snacks Now.

Tanya says, “So, it’s a late night home-delivery service? People can order their favourite pizza and maybe cleaning products and everything is brought in one delivery to their house?”

“Not necessarily their house, it could be any address.”

“Well, it’s perfect. I would order from them all the time. How are they going to staff it?”

“One person in their supermarket will prepare the orders and a driver will deliver.”

“One person? Alone in a supermarket all night long? That doesn’t sound very safe. It’s not a job I’d like to have.”

You hadn’t thought of that, but you can see that Tanya has a point. You wonder if this is something Dionne and John have considered. You have a client meeting scheduled for the next day. You know that future staffing decisions are not really within a systems analyst’s purview, but Tanya’s comments are troubling you.

From the Systems Analysis assessment

The preliminary investigation you wrote up for the Snacks Now project enabled you to develop a basic understanding of the business context. Your scope lists and scope statement captured the project’s key elements and made a positive impression on Dionne and John. They have approved the project’s progression to system analysis and you have scheduled a meeting with them.

After this meeting, the following requirements are known:

The information you provided in the systems planning documents is confirmed, except where it conflicts with the following.

When an order is placed, the junior manager will gather items from shelves in the supermarket, scan them and package them for delivery.

When all the items are packaged, the junior manager will close the ‘packaging’ business process for the order; an alert and delivery address will be automatically sent to the driver’s mobile device.

When items are scanned, the supermarket’s inventory database is updated and the transaction is placed in the Snacks Now accounting system (it is not considered a transaction of the supermarket).

As the supermarket carries thousands of different products, and as the local fast food outlets also have specific ranges of products, the website and mobile app will have nested menus.

When a supermarket product is out of stock, it must not be displayed in the menus. For example, when a hurricane destroys the banana crop in Queensland.

The menus are updated dynamically in response to changes in the inventory.

Daily, weekly and monthly transaction reports are required.

Data analytics on the website and the mobile app are required.

A customer database will maintain customer details, transaction history, loyalty and social points.

In compliance with the Australian Privacy Principles, it will be possible for customers to opt out of storing any data that identifies them as individuals.

As yet, no decision has been made regarding the most effective way to present the items offered by local fast food outlets; suggestions are welcome.

Also, a final decision on which accounting software will be used for Snacks Now has not yet been made, but Dionne and John have expressed a preference for buying a second license for the accounting system they are already using for the supermarket.

You make a start on systems analysis. It is clear that system response times are important. It is also clear that interfacing with the supermarket’s existing inventory database is important. However, you also realise more detailed information will come to light over time, which may require you to amend your current analysis.

New information

John and Dionne have approved your analysis of their systems and have asked you to proceed with systems design. You refer to your systems analysis documentation while designing.

User interface design

Design a user interface storyboard for a customer to place an order for fast food only.

Not sure how to make a storyboard? Storyboards show the way that tasks flow in the user interface and the way information is presented in the user interface. Here are some examples for your consideration:

http://msdn.microsoft.com/en-us/library/windows/desktop/Ff800706.0e12f17e-860b-4be5-a89d-b914b38b0680(l=en-us).jpeg

http://courses.csail.mit.edu/6.831/wiki/images/thumb/a/a8/MOD-Storyboard-4.png/300px-MOD-Storyboard-4.png

http://www.museumsandtheweb.com/mw2007/papers/vanLoon/vanloon-figure4-thumbnail.jpg

http://www.stavchansky.net/images/feature_ftsStoryboard.jpg

Put your answer here.

Design a user interface storyboard for a customer to place an order for groceries and fast food.

Put your answer here.

Design the alert that will be sent to the driver’s mobile device at the end of the ‘packaging’ process.

Put your answer here.

Design the nested menus.

Put your answer here.

Design the monthly transaction report. In this context, a transaction is a customer order. Transactions types are grocery only, fast food only, and both. The report will group the transactions by type within week and it will include appropriate sub-totals and totals. This report will summarise transactions – it will not include descriptive data. At the end of the report, include a line chart. This chart will graphically depict the transaction types, allowing John and Dionne to compare the popularity of the three different types of transactions for each day of the month.

Put your answer here.

Data design

A table is provided in Appendix One. The data is in 1NF.

Normalise the table(s) to 2NF.

Put your answer here.

Normalise the tables to 3NF.

Put your answer here.

Create an ERD for the customer order process.

Put your answer here.

System architecture

You have completed the data design. Now you will design the system architecture. You begin by reviewing the system architecture checklist.

Which items on the system architecture checklist are relevant to the Snacks Now information system?

Put your answer here.

Prioritise the items that you identified in question 9. Briefly explain (one or two sentences) these priorities.

Put your answer here.

Consider cloud computing. Are you going to recommend any cloud computing capabilities for the Snacks Now information system? Why?

Put your answer here.

User approval is recommended as one of the closing tasks of systems design. Write a plan (100-200 words) for obtaining user approval.

Put your answer here.

Ethical analysis

Reflect on your experiences as a student or in your career. Identify an ethical issue that you encountered at some time in your past.1

Describe the ethical issue. Do not describe how it was resolved.

Put your answer here.

Consider the ethical decision-making process from Reynolds (2015) and the ethical decision-making process from O’Boyle (2002). These readings can be located on the course web site. In responding to the questions below, refer to the ACS Code of Ethics and the ACS Code of Professional Conduct.

To analyse the ethical issue you described in question 13, which is better: the ethical decision-making process from O’Boyle (2002) or the one from Reynolds (2015)?

Put your answer here.

What are your reasons for rejecting the other approach?

Put your answer here.

Apply your chosen approach to the ethical problem you described in question 13.

Put your answer here.

Reflect upon the processes in Reynolds (2015) and O’Boyle (2002).

Would an analysis be more robust if it had included some aspects of both approaches? For example, if you were to apply O’Boyle’s approach (2002), would your analysis be more robust if it included some aspects from Reynolds (2015)?

Put your answer here.

Explain. In your explanation, clearly describe which features of O’Boyle’s approach and which parts of Reynolds’s approach are preferable.

Put your answer here.

Conceptual development

So far, this assessment has supported the development of skills required in professional practice, including ethics. Now, it supports the development of professional expertise.

What is the overall purpose of the systems design phase of a project and how does it differ from the systems analysis and systems planning phases?

Put your answer here.

Consider the case study above and the design you prepared. You may have completed the tasks with a lot of care. If so, your design is likely to be effective in supporting future project activities.

Consider a situation in which the design is careless.

With respect to the systems design tasks completed above, identify problems that may arise for the following stakeholders. Your answer should have six unique problems (two per stakeholder).

Snacks Now

Put your answer here.

Snacks Now’s customers or the wider community

Put your answer here.

Your own future work tasks (systems analysis tasks)

Put your answer here.

Select two of your problems from question 19.

With reference to these two problems, what are your conclusions about the importance of attention to detail with respect to system design?

Put your answer here.

Learning reflection

Think about the tasks you completed in the Systems Planning, Systems Analysis and Systems Design assessments. Reflect upon any knowledge you have gained from completing these tasks. Read the UniSA Graduate Qualities.

Name two learning outcomes.

Note: although the Course Objectives on the Course Outline can be informative, consider your personal learning experience. You have a unique history; therefore you will have unique learning outcomes. In other words, if you knew a lot about data normalization before starting this assessment you can’t identify that skill as a learning outcome, you will identify something else instead.

Example: In these assessments, I learned and I learned .

Put your answer here.

For each of your learning outcomes, name one relevant Graduate Quality.

Example: “As noted above, my first learning outcome is . This learning outcome correlates to the graduate quality . My second learning outcome is . This learning outcome correlates to .”

Put your answer here.

In your previous answers, you named two learning outcomes and you related each one to a Graduate Quality.

Addressing each Graduate Quality separately, explain how this assessment’s tasks enabled you to develop these qualities.

Put your answer here.

The following questions are for internal students only.

In your previous assessments, your teammates reviewed your teamwork capabilities on SparkPLUS. Read and consider the peer reviews your teammates gave you.

NOTE: the reviews on SparkPLUS will be read in conjunction with your answers.

According to your teammates, what are your weaknesses? Make a short list.

Put your answer here.

According to your teammates, what are your strengths? Make a short list.

Put your answer here.

What is the most important thing on the list of strengths? Why is it the most important thing?

Put your answer here.

What is the most important thing on the list of weaknesses? Why is it the most important thing?

Put your answer here.

Was it harder for you to review your peers or to read the reviews they gave you? Why?

Put your answer here.

How can you benefit from the reviews you received?

Put your answer here.

With respect to the teamwork in the Systems Planning Assessment, what was your biggest mistake?

Put your answer here.

With respect to the teamwork in the Systems Analysis Assessment, what was your biggest mistake?

Put your answer here.

Write a short plan (eg 50-150 words) that will prevent you from making these mistakes in future.

Put your answer here.

Not for assessment

How many hours did you invest in this assessment? This information will be provided to future students in this course.

Put your answer here.

Thank you for the time and effort you have invested. I look forward to reading your submission.

References

Australian Computer Society nd, ACS Code of Ethics, viewed July 30 2019, <https://www.acs.org.au/content/dam/acs/acs-documents/Code-of-Ethics.pdf>.

Australian Computer Society nd, ACS Code of Professional Conduct, viewed July 30 2019, <https://www.acs.org.au/content/dam/acs/rules-and-regulations/Code-of-Professional-Conduct_v2.1.pdf>.

O’Boyle, E J 2002, ‘An ethical decision-making process for computing professionals’, Ethics and Information Technology, vol. 4, no. 4, pp. 267-277.

Reynolds, G 2015, Ethics in Information Technology, Thomson (chapter 1).

Tilley, S & Rosenblatt, H 2017, Systems Analysis and Design, 11th edition, Cengage Learning.

[Add more references of your own. Don’t know how? Check the online study help.]

 

Appendix One: Orders data

Order Date Time Name Deliver to Deliver time Deliver date Retailer Retailer rating Item Size Quantity Price Per Total Order total
1 25/5/2017 22:47 Sally Larkins 1 Home Street, Adelaide 23:45 25/5/2017 D&J 5 Kellogg’s Cornflakes 450g 2 4.00 Unit 8.00 27.66
1 25/5/2017 22:47 Sally Larkins 1 Home Street, Adelaide 23:45 25/5/2017 Dominos Pizza 3 Chicken Fajita null 1 16.90 Unit 16.90 27.66
1 25/5/2017 22:47 Sally Larkins 1 Home Street, Adelaide 23:45 25/5/2017 D&J 5 Golden North Country Fresh Milk 1 litre 1 2.76 Unit 2.76 27.66
2 25/5/2017 22:49 Matt Wilson 10 High Street, Mitcham 23:50 25/5/2017 D&J 5 Pink lady apple Medium 6 1.25 Kg 1.14 24.81
2 25/5/2017 22.49 Matt Wilson 10 High Street, Mitcham 23:50 25/5/2017 D&J 5 Kiwifruit null 2 2.35 Kg 0.68 24.81
2 25/5/2017 22.49 Matt Wilson 10 High Street, Mitcham 23:50 25/5/2017 D&J 5 Kellogg’s Cornflakes 220g 1 2.49 Unit 2.49 24.81
2 25/5/2017 22.49 Matt Wilson 10 High Street, Mitcham 23:50 25/5/2017 Beyond India 5 Cheese naan null 2 5.00 Unit 10.00 24.81
2 25/5/2017 22.49 Matt Wilson 10 High Street, Mitcham 23:50 25/5/2017 Beyond India 5 Aloo channa massala Main 1 10.50 Unit 10.50 24.81
3 25/5/2017 23:05 James Ruch 6 Wright Street, Adelaide 00:10 26/5/2017 D&J 5 Farmers Union Iced Coffee 600ml 2 2.00 Unit 4.00 44.95
3 25/5/2017 23:05 James Ruch 6 Wright Street, Adelaide 00:10 26/5/2017 D&J 5 Strawberries 250g 2 4.50 Punnet 9.00 44.95
3 25/5/2017 23:05 James Ruch 6 Wright Street, Adelaide 00:10 26/5/2017 D&J 5 Cavendish Banana null 2 0.60 Unit 1.20 44.95
3 25/5/2017 23:05 James Ruch 6 Wright Street, Adelaide 00:10 26/5/2017 Amigo’s Café and Pizzeria 4 Student Box 1 with Sprite null 1 14.95 Unit 14.95 44.95
3 25/5/2017 23:05 James Ruch 6 Wright Street, Adelaide 00:10 26/5/2017 Social Street S2 3 Pad Thai Chicken null 1 15.80 Unit 15.80 44.95

 

1 This ethical issue must come from your real life. Do not describe a theoretical ethical issue. Do not describe an ethical issue from any courses you have taken.