La Trobe University La Trobe Business School Department of Management and Marketing Business Information Systems Design (BUS5BID) Semester 1, 2016 DUE DATES: Tasks 1 to 5: 2nd May 2016, 9:00a.m Section A. Work Requirements This group assignment forms part of the assessment in this subject, and as such carries 40% of the total marks to be awarded. A group can consist of maximum 4 enrolled students. The assessment criteria can be found in the last section of the BUS5BID subject learning guide.

A.2. Submission Procedures and Required Format Your assignment is to be typewritten, in English, on A4 pages. The report should be written in clear, plain language, so that non-experts can easily understand it. The report must be your own work, i.e., it must be the result of your own reading, thought and discussion, and the expression of the ideas must be yours. Editorial assistance is permitted, but should be limited to such matters as assistance with grammar and syntax, and suggestions for improving clarity of expression. However, all rewriting in response to such assistance should be done by you. The student declaration form in Section B is to be completed and submitted with the assignment.

A.3. Scenario, Background and Tasks

Scenario La Trobe Retail Store (LRS) required an information management system to enable retail stores to manage their day-to-day operations and integrate their business into a single centralized unit leading to increased operational efficiency. The application domain for this assignment is a part of a simplified information management system for LRS. Stores are to be provided the facility to create and manage a customer database including details such as customer information, and product information etc. The Retail Store management has decided to complete this project in two phases: data modelling and implementation. You are required to complete and submit the data modelling phase for this assignment by Week 9, 2nd may Any submission after the above dates will incur penalties in accordance with La Trobe business School Policies.

Background to the Project

The LRS is a place where there are several things present, such as goods and products, customers and their needs, retail executives, etc. Such things can only be well handled by a person known as the retail store manager. The obligations of a store manager mostly depend upon the size of the store. The principal responsibility of a store manager is handling and overseeing all the day-to-day processes that are carried out in the store. He/She manages the product inventory, salespersons, goods for display, sales, etc. Apart from product and customer management, He/she also has to take care of the interests of the members in his sales team, as they are the ones who are in direct contact with the customers. Salesperson duties include taking inventory of existing products and keeping tabs on what has been ordered and purchased. The LRS consists of the sale of products from a fixed location for direct consumption by the customer. Each store is recorded as store ID, store name and location. Each salesperson in the store has staff identification number, name, and contact details. The LRS records each product as product code, name and price. Different stores may supply different price for same product. The proposed LRS information system should also maintain customer's information by recording their name, address, and phone number. The store also records invoice number and issue date before sending an invoice to a customer. Items of each invoice which describe the products bought by the customer should be recorded. Additionally, the system should record the quantity of each product. The following explanation may assist you to understand the ERD:

• more than one stores in a city, one store is a supervise store. • a customer/shopper can have many invoices.

TASK1 : [15%] - Interviewing the Client/prospective customer at LRS - submission date: 2nd May, 9a.m

Adopt design thinking approach to interview prospective customers/shoppers at LRS to determine the requirements for information management system at LRS. Document the method used in the design thinking approach

TASK 2: [10%] - Work-Centred Analysis Framework – submission date: 2nd May, 9a.m

Map the requirements identified in task 1 to the six system elements of LRS case study based on work-centred analysis framework.

TASK 3: [10%] - Performance Analysis - Business Value and Customer Value - submission date: 2nd May, 9a.m

Conduct a Performance Analysis of Business Process and Product/Output Components identified in Task 2 to determine business value and customer value gains which can be obtained through design and deployment of an information system as sub-system of the work system.

TASK 4 : [10%] - Architecture of the Information Component - submission date: 2nd May, 9a.m A. [5%] Develop an Entity Relationship Diagram (ERD) to represent the data identified in the information component of work-centred analysis framework for LRS information management system. The diagram of your ERD model must: • show all necessary entities, attributes and relationships

• show unique identifiers and nature of interaction between entities.. B. [5%] Map the ERD into a set of relations in at least Third Normal Form (3NF). You should demonstrate that each relation satisfies the rules for first normal form, second normal form, and third normal form. For example: PROPRIETOR (ProprietorID, FamilyName, GivenName, PhoneNbr) This relation is in 1NF because it does not contain any repeating groups.

In your report you must also include a data dictionary. You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc.

For example, Entity: PROPRIETOR – Each instance of proprietor is a person, who owns the kitchen.

Attribute Meaning Data Type Format Other ProprietorID A unique identifier of a proprietor. Integer Index –Yes (No

Duplicates) FamilyName Family name of a proprietor Text(20) Example,

"Hocking" GivenName First name of a proprietor Text(20) Example, "John"

PhoneNbr Phone number of a proprietor Text(12) Not Null

TASK 5: [10%] - Business Process Architecture – Data Flow Diagram (DFD) - submission date: 2nd May, 9a.m Using DFD techniques draw the context diagram of Business Process Architecture of LRS information Management System. Also draw level 0 data flow diagram showing the major sub-processes, data stores and flow of data between various sub-processes or steps in the business process component.

TASKS 1 to 5 are due on 2nd may at 9a.m. The submitted work will therefore comprise: A Microsoft Word document containing:

1) Application of Design thinking approach as an interview methodology for determining the requirements of LRS information management systems 2) Mapping of requirements identified through the design thinking approach on to the 6 system elements of work-centred analysis framework. 3) Performance Analysis of business process and product/output components of LRS information management system 4) A list of brief descriptions for each entity and attribute that you have identified in your case study.

5) \A copy of your entity-relationship model(s). 6) A copy of relational tables in 3rd normal form 7) A list of any assumptions that you made (include any clarifications from your tutor).

5) Context and level 0 dataflow diagram. 6) Declaration form (Section

Student's Declaration I hereby certify that I am an author of the submitted work bearing my name and student identification number.

Signature ___________________ Date __________

Signature ___________________ Date __________ Signature ___________________ Date __________ 8