Woolworths Rewards

Table of Contents

Functional Requirements.

Non-Functional Requirements.

Use Case Model

Class Diagram..

Entity Relationship Diagram..

Data Dictionary.

Functional Requirements

The main functional requirements for the system are as following:

Customer Form – When a customer visits the store, a customer form will be filled by the admin staff to make the boll. A unique customer no will be issued to the customer and whenever the same customer revisits the store the same customer no will be used in every transaction.

Product Details – All the details of the product must be store in the system. When a new product is launched, a product no will be generated which is a unique number.

Billing – All the billing details will be saved in the system to generate an automated bill to the customer.

Billing Details – All the product details that are purchased by the customer will be saved in the billing details section with the quantity.

Maximum Purchase – As the purchased details of the customer are saved into the system, the maximum purchase made by the customer can be retrieved in the report section.

Reward – When a customer is rewarded for maximum purchase, the details must be saved into the system.

Non-Functional Requirements

Usability – The system must be easy to use for beginners. No special training must be required for users.

Reliability – As the system automates all business processes of the store, human errors will get eliminated. Hence, the data retrieved from the system is reliable and accurate.

Scalability – With the increase in business, no. of transactions will increase. Hence, the developed system must be able to save a large data set.

Security – All security and privacy acts will be fulfilled. Only authorized users will be given access to the system. Also, additional security measures will be implemented.

Accessibility – The system must be available at all times without any interruption. A proper backup strategy will be developed for avoiding any data loss.

Use Case Model

Use Case Diagram

Figure 1: Use Case Diagram

According to the given scenario, there are four actors – receptionist, customer, checkout staff, and management. The process starts when a customer comes to the store. When he collects the items, he reaches the reception or billing counter where all his details will be saved into the system. A unique CIN number will be generated. A bill will be generated by the receptionist. The customer then goes to checkout staff and the staff notes his CIN number to record all purchase details. At the year-end, the management checks all details of purchase history and take out the customer name who has purchased maximum and then reward him.

Class Diagram

Class Diagram

Figure 2: Class Diagram

There are five classes in this scenario. The classes' names are Customer, Products, Billing, BillingDetails, CustomerRewards, LoyaltyRewards. All these classes will add their respective data to the system. Customers are to add and modify the customer details by generating a unique CIN number. Similarly, Products will save all product details. The bill details of the customer will be saved into the billing entity whereas all product details that are billed in a particular bill will be saved in BillingDetails. CustLoyalty is for recording all customer purchase details into the system.

Entity Relationship Diagram

Entity Relationship Diagram

Figure 3: Entity Relationship Diagram

In the above ERD, we have considered six entities – customer, product, Billing, BillingDetails, PurchaseRecord, and CustomerRewards. All the customer details will be saved in the Customer table with a unique CIN number that is auto-generated by the system. The products are the master table for saving all product details. When a customer picks some items, he visits the billing counter where the receptionist makes his bill. The product details of a bill are saved in BillingDetails. After bill generation, the customer goes to the checkout counter where check out staff records all his purchasing details based on CIN number. All details will be saved in the PurchaseRecord entity. When a customer is rewarded based on purchase history, the reward details will be saved in the CustomerRewards entity.

Data Dictionary

Entities/ Table Names

Attributes in an entity

Data Types

Any Constraint

Customer

CIN

Auto Number

Primary Key

 

CustName

Short Text(50)

 
 

CustAdd

Short Text(100)

 
 

CustEmail

Short Text(50)

 
 

CustContact

Short Text(15)

 

Product

ProdNo

AutoNumber

Primary Key

 

ProdName

Short Text

 
 

ProdQty_Hand

Number

 
 

ProdPrice

Number

 

Billing

BillNo

AutoNumber

Primary Key

 

CIN

Number

Foreign Key

 

BillDate

Date

 
 

BillAmount

Number(10,2)

 

BillingDetails

ID

Auto Number

Primary Key

 

BillNo

Number

Foreign Key

 

ProdNo

Short Text

Foreign Key

 

ProdQty

Number

 
 

ProdPrice

Number

 

PurchaseRecord

PINo

Auto Number

Primary Key

 

CIN

Number

Foreign Key

 

BillAmount

Number

 
 

BillDate

Date

 

CustomerReward

CRNo

Auto Number

Primary Key

 

CIN

Number

Foreign Key

 

Reward

Short Text

 
 

Reward_Dates

Date

 

Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Computer Science Assignment Help

Get It Done! Today

Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
Upload your assignment
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

refresh