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: Tuesday 3rd May 2016, 9:00a.m
Tasks 6 to 8: Tuesday, 24th May, 2016, 5:00pm Task 10: Weekly, starting from 12th April 2016 till 24th May 2016.
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, 3rd May 2016 at 9a.m. The implementation phase needs to be completed and submitted by Week 12, 24th May, 2016 at 9a.m. 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: 3rd 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:
3rd 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: 3rd 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: 3rd 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: 3rd 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 3rd 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
Phase 2:
Relational Database Implementation
You must implement the normalized entity relationship model developed in TASK
4 .
The Managers of La Trobe Retail Store (LRS) information system require reporting features to help with identifying customers, products, staffs and invoice details. Some of such reports include: staffs details, finding specific age groups or genders of customers and grouping products with stores, printing a list of staff etc.
This will be achieved by creating a MS ACCESS 2007 database making use of supporting features like: forms, queries and reports. A user manual is essential to this project as the managers are novice computer users and will require assistance for using the database.
Following tasks need to be completed and submitted on 24th May at 9a.m..
TASK 6: [5%] - Data Dictionary - submission date: 24th May, 9a.m
In your report, you must include a data dictionary based on given model solution (i.e., normalised ERD). You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc.
For example,
Entity: SUPPLIER – Each instance of supplier is a person, who supplies products.
Attribute
Meaning Data Type
Format Other
SuppID A unique identifier of a supplier. Integer Index –Yes (No Duplicates)
FamilyName Family name of a supplier Text(20) Example, “Hocking”
GivenName First name of a supplier Text(20) Example, “John”
PhoneNbr Phone number of a supplier Text(12) Not Null
TASK 7: [25%] – LRS Database Implementation - submission date: 24th May, 9a.m
The recommended tool for this assignment is Microsoft Access 2007.
A. [4%] Implement your data dictionary to create a relational database in Microsoft Access 2007.
B. [6%] Populate the database with sample data. Sufficient sample data (at least 10 records per table) must be included to demonstrate that the queries, view(s), and report(s) work correctly.
C. [15%] Create view objects (“SQL queries” in MS Access 2007) to obtain tables that demonstrate following reports. (Note: it is strongly recommended that you do not use the Access query builder (QBE) – you should type the SQL queries manually.)
Finally, create the following forms and reports, requiring a separate query to satisfy each of the following information needs:
1. A form to enable simple and easy entry, delete and update of
customer and product information. 5%
2. Create a Store form in Design View and add a subform into it
to view product details in each store . 4%
3. A report that prints the customers’ details. 5 to a page. So, La Trobe Retail Store can email them required information electronically. 4%
4. A report showing invoice details of last 30 days. Order the list so that the recent invoice appear first . 4%
5. A report that shows the details of customers who visited retail stores more than once in the last month 6%
6. A report that shows the age group (e.g., 18-30, 30-50, 50 and above) who did most of the shopping in the last 30 days. 5%
7. A report that shows the group of products available for each store.
4%
8. A switchboard or startup form, which includes all required forms and reports in the LRS database system. 8%
Save the database structure, test data and query/report designs to the CD. However, printout the result of your forms and reports and include these in the hard copy submission.
-
TASK 8: User Manual - [15%] - submission date: 24th May, 9a.m
Create a user manual for your La Trobe Retail Store Information System. This manual should explain all the features of your database and how to do each task. The manual should also include screen shots of what you are explaining. Screen shots can be taken by pressing Alt+PrintScreen, and then pasting it
into your document
TASKS 6, 7 and 8 are due on 24th May at 9a.m
Submission for tasks 6, 7 and 8: soft and hard copy submission (A printed version of Word document and a CD for Access database).
TASK 9: 10 minute Presentation and Demonstration of Tasks 1 to 8 in the lab in week 12 – [10%]
TASK 10: Team Meetings and Team Reports [10%]
Submit weekly team meeting reports to your tutor providing details of the agenda, task allocation and minutes of meeting.
Each member of the team will present and demonstrate the task or tasks they have
completed in the assignment. The presentation and demonstration will take place after the submission of the assignment.
Section B. Authentication Procedure.
The signed original of the Declaration Form (C1) must be included with the assignment.
B.1 Declaration Form
The declaration should include list of tasks completed and percentage contributions by each student to the assignment.
Student Id ______________ Name _____________________________________
Student Id ______________ Name _____________________________________
Student Id ______________ Name _____________________________________
Student Id ______________ Name _____________________________________
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
GET ANSWERS / LIVE CHAT