Natural Health Food store is a chain of health food stores serving NSW, Queensland and Victoria. David Brown opened his first Natural Best Health Food Stores in 1965 and has since opened fifteen stores in three states. Initially he sold only herbal supplements, gourmet coffees and teas, and household products. In 1990, he expanded his product line to include personal care, pet care, and grocery items. In the past several months, many of Mr. David's customers have requested the ability to purchase prepackaged meals, such as chicken, turkey, fish, and vegetables, and have these prepackaged meals automatically delivered to their homes weekly, biweekly, or monthly as requested.

With the current system, a customer can become a member of Natural Best Food Delivery Service and have personal care, pet care, gourmet products, and grocery items delivered on a weekly, biweekly, or monthly basis. Only members can order the items to be delivered at their postal address. The entire subscription process takes almost an hour. The customer needs to fill in the paper form to become member which collects customer's information. To order product member needs to call the shop and a staff member writes the order against the member number. The order will have desired delivery items and quantity, delivery frequency, mode of payment and phone number. This system is old and creates lot of overhead on staff. The order gets misplaced; gets duplicated, insufficient stock or shops are overstocked etc.

Mr. David wants to deploy an Automatic Delivery System (ADS) for its existing products. The system should able to process customer's subscription. Once the subscription is processed the customer becomes member and should able to order product online. As members orders are placed, inventory is automatically updated. Each store should be equipped with a computer that accesses a centralized database. The system should able to track inventory, customers' activity, delivery schedules, and individual store sales. Each week sales summary report should be generated, low-in- stock reports, and delivery schedule reports for each store. The information contained on each of these individual reports is then consolidated into master sales summary, low-in-stock, and forecasting reports. Information contained on these reports would facilitate restocking, product delivery, and forecasting decisions. At present Mr. David uses an Excel worksheet to consolidate sales information from each store. He then uses this worksheet to make forecasting decisions for each store.

For Project Cost Benefit Analysis assume discount rate to be 10%. Total development cost is $80,000.00

WEBSITE DESIGN AND MODELLING

This assessment relates to course learning outcomes 1 to 6 stated in the e-course profile. Assessment 2 is a group assignment. You are required to form a group of 3-5 people. Following on Assessment 1, Assessment 2 is based on the same project case study. In Assessment 2 – Website Design and Modelling, you are required to complete tasks 1-5 below which assess your general course knowledge, particularly on modelling diagrams and Interface design from weeks 6-10 about different facets of systems development.

Please note that ALL submissions are passed through a computerized copy detection system and it is extremely easy for teaching staff to identify copied or otherwise plagiarised work.  Copying (plagiarism) can incur penalties ranging from deduction of marks to failing the course or even exclusion from the University.

 Please ensure you are familiar with the Academic Misconduct Procedures, available from: http://policy.cqu.edu.au/Policy/policy_file.do?policyid=1244

The tasks In the report format used in CQUniversity (refer to the Help section below for a link to the report guide), explain how you would complete the following modelling tasks and website design. The report presentation including the references.

You are to develop the report having each task clearly numbered together with your answer. You are also expected to write an introduction and conclusion for this report. In performing the following tasks, you have to strictly follow all diagramming rules used in the text for this course.

In each task, please feel free to make any assumption necessary for the reader. The explanation of your assumptions can help the reader understand your reasoning and is as important criteria in producing your Website Design and model.

Assignment 2 is a group assignment. 3-5 students in a group. Your course knowledge gained about how to model the system requirements in both the object-oriented and traditional system analysis approaches will be assessed through the tasks in assignment 2. You need to submit a design of a website. You are to complete the following task in the order given based on the case study provided to you on Moodle: 

1. Find out all Critical Use Cases

2. Draw Context Level diagram.

3. Draw Level 0 data flow diagram depicting all the business process description provided.

4. Draw ERD showing all required entities and its relationships.

5. Draw CRUD diagram.

7. Provide a prototype of website design and architecture you have developed based on the case study.

8. Details of individual group members contribution towards the development of the project.

At week 11, there will be a presentation based on the case study.

Presentation based on the case study :

Students need to present the website design in the designated tutorial/ class time. Students need to specify the advantages and disadvantages of tools they have used to develop the website design. The website design is a prototype. Students are not required to implement the design. No Database connectivity is required. Students can choose some default value for the label and text field they are using in the design. Students should click the photographs and images they would like or wish to display on the website. Students may use photographs/ images from the web but they are required to reference it properly.

Help Help on writing reports is contained in the Faculty Guide for Students – Chapter 4 Academic Report Writing:

http://www.cqu.edu.au/__data/assets/pdf_file/0003/2289/Extract-of-Chapter-3.pdf You may also benefit from a video supplied by the CQUniversity Academic Learning Centre available here:

http://www.youtube.com/watch?v=J0v9ekxeoko Assessment criteria Marks for Assessment 2 will be allocated as follows: TOPIC Weight Mark

Introduction 5 Find out all Critical Use Cases and Draw use case diagram 10 Draw Context Level diagram. 5

Draw Level 0 data flow diagram depicting all the business process description provided

Draw ERD showing all required entities and its relationships 10

Draw CRUD diagram 10

10 Provide a prototype of website design and architecture you have developed based on the case study

Details of individual group members contribution towards the development of the project

Conclusion and summary 5

Task 5 Presentation based on the case study 20 References 5 TOTAL: 105 15 10