Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Can I get a help in creating Activity Diagram for scheduling appliance repair appointment for the OnMart Superstore. Thank you in advance for your help

Can I get a help in creating Activity Diagram for scheduling appliance repair appointment for the OnMart Superstore. Thank you in advance for your help

Course: ORGANIZATION MODELING FOR DT

Question:

Use Visio , draw.io (diagrams.net), or Modelio tool to create the Activity Diagram for Scheduling an appliance repair appointment for the OnMart Superstore case study.

Case Study

OnMart Superstore

Requirements Specification & Architecture

1. The OnMart Superstore

The OnMart superstore is an online retailer that has a business model similar to Amazon, Walmart, and Target business models, and it is experiencing a significant growth in its online shopping business. The online superstore has several departments that are selling products in different categories: Electronics, Clothing, Grocery, Furniture, Sports, etc.

The OnMart superstore receives thousands of online orders every hour with package deliveries to different addresses in different cities and states. To cope with the significant growth in its online orders and deliveries, OnMart has decided to utilize a real-time stream processing and microservices platform in order to develop an application that integrates its different departments and functional units. The real-time data streaming platform will be utilized by OnMarts real-time application in order to perform a variety of tasks related to its business process and workflows including logistics, supply-chain, operational process, forecasting product demands, product recommendations, cross-promotion programs, package delivery network and delivery vehicles, customer satisfaction and product returns, fraud detection, risk mitigation and contingency planning.

For its supply chain and its delivery network/vehicles, OnMart has several warehouses and distributions centers. Every warehouse supplies a number of distribution centers and every distribution center delivers packages in different zip codes.

The logistics and supply chain network for OnMart has the following characteristics:

It delivers packages to customers distributed across 785 zip codes

It has 97 distribution centers that are located in 97 zip codes

It has 17 warehouses that are located in 17 zip codes

It serves customers in 8 cities located in different states in the US

Every serving facility (distribution center or warehouse) has a unique pair of latitude and longitude. Even though OnMart has many warehouses that supply distribution centers in the different cities, not every city has warehouses; Nashville and Atlanta do not have warehouses. Currently, Nashville is being supplied by products shipped from Chicago warehouses and Atlanta is being supplied by products shipped from Miami warehouses. The following figure illustrates the structure of the OnMart delivery network:

2. Departments and Products

OnMart has several departments, functional units, warehouses and distribution centers located in different cities and states across the US. The following diagram illustrates the departments located in different cities that require real-time collaboration and data streaming platform:

OnMart has several departments that are selling products in different categories. The following is a sample of these departments and the different product categories they sell:

Department

Product Categories (Sample)

Furniture

Bookcases, Chairs, and Tables

Grocery

Dairy, Beans, Pasta, Paper products, and cleaning supplies.

Office Supplies

Desk Supplies, Filing Supplies, Paper

& Pads, Binding Supplies, and

Stationery/mailing supplies

Clothing

Shoes, Socks, Dresses, Jackets, Shorts and Shirts

Electronics

Computers, TV, Phones, and Sound System

Appliances

Refrigerators, Dishwashers,

Microwaves, Washers, Dryers

3. Customers and Purchases

Customers place their orders online and the order might have products from the different categories in the different departments. For every order there will be a unique order number generated. When the customers place the order online, the customer will enter home address, delivery address, and shipping class.

The customer shall be provided with the following capabilities:

Return purchased items.

Review and rate purchased items.

Some customers are connected with friends in a Social Network as illustrated in the graph data model listed below and can share product description of purchased items with friends in the social network.

. 4. Geospatial and Logistics

The logistics department is responsible for the logistics and supply chain network for OnMart Superstore. The department team members track the status of the warehouses, distributions centers, inventories, deliveries, delays, and returned products for the different zip codes that OnMart serves. The department tracks the connections between the cities, warehouses, distribution centers and the zip codes they serve within the OnMart supply chain network; the data graph below shows one of the distribution centers in Chicago along with the distribution centers associated with it and the zip codes that it serves. The department is also responsible for creating contingency plans to cope with adverse weather conditions that might impact the daily operations for the warehouses, distribution centers and order deliveries.

5. Finding influential reviewers

OnMart customers write many reviews for the products that OnMart sells, and the challenge for the marketing team is to decide which reviews will be displayed first and what criteria is to be used for ordering the reviews for the potential new buyers (customers). Since the customers who wrote product reviews are part of a social network and many of them are also connected to other customers in the social network, OnMart is requesting to leverage this information to find those customers who wrote at least three reviews for its products and are connected to other customers in the social network. In essence, OnMart is requesting to find the list of influential reviewers that will influence other customers, even though these customers are not direct friends in the social network. There are a few algorithms in the graph data science library (like Google PageRank, ArticleRank, etc.) that could be used to find influential reviewers and OnMart is requesting to utilize these algorithms to identify the influential reviewers.

6. Forecasting Sales Revenue and Product Demand Analysis:

There are many algorithms to forecast sales revenue and product demands. OnMart needs a formal evaluation of the popular forecasting algorithms to predict its product demand and sales per zip code, distribution centers, and warehouses. This feature requires comparative analysis and research of common forecasting models and the application of descriptive analytics methods part of the evaluation study. For this feature, OnMarts requirement is to perform a number of experiments to forecast sales revenue and product demands using timeseries analysis utilizing the three packages Facebook/Prophet, TensorFlow Time Series (TFTS), and StatsModel. Part of the exploratory/descriptive data analysis and predictive work that will be done for this feature:

7. Fraud Detection and Contingency Planning

7.1 BOT-Generated and Fake Ratings Detection

Customers of OnMart utilize their credit cards for their online purchases and they can write reviews and rate the products they purchased online. OnMart recently noticed an increase in the number of customer complaints related to fake reviews and fraudulent transactions. OnMart requested a formal analytics study to identify the root cause of the problem in order to rectify the issues underneath.

To detect fake or bot-generated reviews, there are few guidelines (https://consumerfed.org/review-bots-false-advertising-or-opinion-spam/ ) that OnMart suggested for the development team to consider in order to identity fake reviews/ratings:

High volume of reviews in a short time span

High percentage of five-star ratings

Reviews with similar/exact language from different users for the same product

Multiple ratings of the same product from the same user in 2 or more zip codes in a short period of time

7.2 Credit Card Fraud Detection

To detect fraudulent transactions for credit card purchases, OnMart requested a set of rules and a decision tree model (classifier) to help detect fraudulent credit card transactions. To classify the real-time credit card transactions, a classifier will use a pool of classification rules to classify the transaction in Real-Time (RT) as Fraudulent or Approved. Majority of the credit card detection systems send alerts when a fraud detected to a fraud detection department for further follow up by an investigator and another alert for the credit card holder.

The fraud detection process for OnMart will have a pool of rules that it can apply to check the current transaction with the previous transactions. For example, some of the features and descriptive metrics that could be used are average spending, average number of daily/monthly transactions, product category, profile of the card holder, etc. The goal is to create a decision tree model (classifier) that predicts whether the transaction is fraudulent or not fraudulent (target variable) by learning the decision rules inferred from the transactions log dataset features.

OnMart has requested that the following rules be considered and analyzed for labeling/classifying the transactions when building the predictive model::

If a credit card is used in a short period of time for multiple deliveries in different zip codes, then fraudulent transaction

If transaction amount > $1,000 and credit card is used for first time in the delivery zip-code, then fraudulent transaction

If transaction amount <= $1,000 and credit card is used for first time in the delivery zip-code, then not fraudulent transaction

If transaction amount > $1,000 and credit card is not used for first time in the delivery zip-code, then not fraudulent transaction

If transaction amount <= $1,000 and credit card is not used for first time in the zip-code delivery, then not fraudulent transaction

8. Appliance Repair & Home Repair Services

The customer can schedule a repair service for home appliances. Appointments can be scheduled, re-scheduled or canceled.

9. Shipping and Order Delivery

The customer can schedule, reschedule, track status of home delivery for the purchases ordered online.

10. The Departments, Actor Roles & Responsibilities

OnMart Superstore has different departments that have different employee roles along with the customer role:

Managers

Account Specialists (Customer Support)

Customers

Delivery Drivers

What other departments and roles must be considered??

(Marketing, Sales, etc.)

Manager has all privileges and can

1. Create/cancel/update/delete accounts, order or appointment

Account Specialist can

Create an account for a new customer

Update customer account

What other tasks must be considered??

Customer that has an existing account can do the following online:

Update Record (credit card, personal info, etc.)

Pay Monthly Bill 3. Place an Order

4. What other tasks must be considered??

Technician can

Cancel an appliance repair and service appointment

What other tasks must be considered??

Delivery Driver can

Schedule a delivery

What other tasks must be considered??

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions