MN507 Software Engineering Report: Coles Supermarket System Design

This report details a software engineering analysis and design for the Coles Supermarket. It begins with an overview of functional requirements, such as product storage, customer enrollment in schemes, and purchase tracking, and non-functional requirements like availability, scalability, reliability, and maintainability. The report employs use case modeling, a sequence diagram, a data flow diagram, and an ER diagram to visually represent the system's architecture and data relationships. It also includes a comprehensive data dictionary defining attributes, sizes, and data types for key entities like customers, staff, and purchases. Finally, the report concludes with a bibliography of relevant sources.

Running head: SOFTWARE ENGINEERING
SOFTWARE ENGINEERING-
AUSTRALIAN SUPERMARKET GIANT COLES
Name of the Student
Name of the University
Author Note

1SOFTWARE ENGINEERING
Table of Contents
Functional requirements..................................................................................................................2
Non-functional requirements...........................................................................................................2
Use case modelling..........................................................................................................................4
Sequence diagram for the supermarket............................................................................................5
Data flow diagram...........................................................................................................................6
Data dictionary.................................................................................................................................6
ER diagram......................................................................................................................................8
Bibliography....................................................................................................................................9

2SOFTWARE ENGINEERING
Functional requirements
The functional requirements that are associated with the Coles supermarket are described
below:
 The system will focus on storing the details of the product and will provide the
description whenever a customer requests to avail the product.
 The products are mainly accessed with the help of product ID.
 The system will request the customers to provide personal details so that they can enroll
themselves for a particular scheme for availing the benefits.
 The system will store all the details regarding the purchase that is made by a customer.
 Once the customer provides their personal details a CIN number will be generated that
will be unique for every customers.
 Purchase ID will be generated on every bill made by the customers.
 The CIN will store purchase details of the customers that will be used in future for the
purpose of providing them with the schemes and suitable offers.
 The system calculates the overall investments based on the purchase ID of each customer
and provides gift towards them.
Non-functional requirements
The non-functional requirements are basically referred to the attributes that are used for
determining the appearance and support that is provided by the system towards the customers.
The Coles organization plays a crucial role in everyone’s life and this ensures that an effective
support is provided towards the customers. The basic nonfunctional requirements of the
organization are as follows:

3SOFTWARE ENGINEERING
 Availability: the system that is being associated with the Coles organization needs to be
available enough so that customer can avail the services at any time. This also ensures
better services provided towards the customers.
 Scalability: scalability is one of the essential factor that is associated with the system
development that ensures better performance and can be accessed from any platform.
With the growing technology there is a huge need to have proper system that will be able
to meet the needs of the customers without any challenges.
 Reliability: reliability is a characteristic that is used for stating the systems functionality
and the benefits that are offered towards the customers. Whenever a system is
implemented within an organization it becomes essential to ensure that the system is
reliable enough to meet the needs of the customers.
 Maintainability: there is a huge need to ensure that the system is able to maintain proper
performance for the system without creating much errors. With proper maintenance it
will become easy to manage the activities and will be able to provide effective services
towards the customers.

4SOFTWARE ENGINEERING
Use case modelling

5SOFTWARE ENGINEERING
Sequence diagram for the supermarket

6SOFTWARE ENGINEERING
Data flow diagram
Data dictionary
Customer_Details
Attributes Size Null/Not null Data type Key
CIN 10 Not null Short text Primary key
Name_Cus 16 Not null Short text
Address 24 Not null Long text
Cus_Phno 10 Not null Number
Staff
StaffID 10 Not null Short text Primary key

7SOFTWARE ENGINEERING
Staff_Name 12 Short text Not null
Staff_Add 25 Long text Not null
Staff_phno 10 number Not null
Purchase
Purchase_ID 10 Short Text Not null Primary key
Name_prod 20 Long text Not null Foreign key
Date_Purchase 25 Long text Not null
CIN 10 Short text Not null Foreign key
StaffID 13 Short text Not null Foreign key
Product details
Name_scheme 14 Short text Not null Primary key
Details_Scheme 17 Long text Not null
Registration
ID_Registration 10 Short text Not null Primary key
Name_Scheme 14 Short text Not null Foreign key
CIN 10 Short text Not null Foreign key
DateOfReg 12 date Not null

8SOFTWARE ENGINEERING
ER diagram

9SOFTWARE ENGINEERING
Bibliography
[1]"DBMS Tutorial | Database Management System - javatpoint", www.javatpoint.com, 2019.
[Online]. Available: https://www.javatpoint.com/dbms-tutorial. [Accessed: 23- Aug- 2019].
[2]"What is Use Case Diagram?", Visual-paradigm.com, 2019. [Online]. Available:
https://www.visual-paradigm.com/guide/uml-unified-modeling-language/what-is-use-case-
diagram/. [Accessed: 23- Aug- 2019].
[3]K. Fakhroutdinov, "Use case diagrams are UML diagrams describing units of useful
functionality (use cases) performed by a system in collaboration with external users
(actors).", Uml-diagrams.org, 2019. [Online]. Available: https://www.uml-diagrams.org/use-
case-diagrams.html. [Accessed: 23- Aug- 2019].