OOSE (1)
OOSE (1)
OOSE (1)
(2021-2025)
AIM: Choose any one project and Write the complete problem
statement.
Problem Statement:
Before starting an online jewelry store, some problems that may arise include:
● Categorization: It can be difficult to categorize jewelry items by production date, such as gold, silver,
diamond.
● Transaction analysis: It can be difficult to analyze transactions for a specific time period.
● Inventory availability: It can be difficult to determine which items are available in the store.
● Organized retail crime: Sophisticated criminal groups can steal high-value items, which can lead to financial
losses and put the safety of employees and customers at risk.
Online jewelry stores can offer a wide range of collections because they don't have the same inventory holding
capacity and display space constraints as physical stores.
Customer-Facing Features
1. Personalized Recommendations:
○ Use Salesforce Einstein AI to offer personalized product suggestions based on customer
behavior and preferences.
2. Product Catalog:
○ Display a visually appealing catalog of jewelry items with high-resolution images, descriptions,
and prices.
3. Advanced Search and Filters:
○ Enable customers to filter products by category, price range, material, gemstone type, occasion,
and more.
4. Secure Payment Gateway Integration:
○ Seamlessly integrate with payment platforms to ensure safe and hassle-free transactions.
5. Wishlist and Favorites:
○ Allow users to save their favorite items for future purchases.
6. Customer Reviews and Ratings:
○ Showcase authentic customer feedback to build trust.
7. Mobile-Friendly Design:
○ Ensure responsive design for an optimal shopping experience on all devices.
1. Inventory Management:
○ Track inventory levels in real-time to prevent stockouts and overstocking.
2. Order and Shipping Management:
○ Automate order processing and integrate with shipping providers to update delivery statuses.
3. Customer Relationship Management (CRM):
○ Utilize Salesforce CRM to maintain customer profiles, track interactions, and deliver
personalized marketing.
4. Marketing Automation:
○ Send targeted email campaigns and promotional offers through Salesforce Marketing Cloud.
5. Data Analytics and Reporting:
○ Gain insights into sales trends, customer preferences, and performance metrics using Salesforce
dashboards.
6. Role-Based Access Control:
○ Secure sensitive data by assigning roles and permissions to different team members.
1. Introduction
1.1 Purpose
This document outlines the functional and non-functional requirements for an online jewelry
store built on Salesforce. The system will offer a seamless e-commerce platform for customers to
browse, purchase, and manage jewelry products. It will also include features for backend
operations such as inventory, customer relationship management (CRM), and analytics.
1.2 Scope
2. Overall Description
2.1 Product Perspective
This project will be implemented as a SaaS application using Salesforce Commerce Cloud,
leveraging Salesforce’s ecosystem for scalability and reliability.
● Customer Portal: User-friendly interface for customers to explore and purchase jewelry.
● Admin Portal: Backend system for managing inventory, orders, and marketing
campaigns.
● AI Integration: Personalized recommendations using Salesforce Einstein AI.
● Payment Gateway: Secure integration with payment systems.
● Reporting and Analytics: Dashboards for tracking business metrics.
● Customers: General users purchasing jewelry. Should have basic internet skills.
● Administrators: Staff managing operations. Should have familiarity with Salesforce.
● Support Agents: Responsible for handling customer queries using Salesforce Service
Cloud.
● Web application: Compatible with major browsers (Chrome, Safari, Firefox, Edge).
● Mobile application: Compatible with iOS and Android.
● Backend hosted on Salesforce Cloud.
4. Non-Functional Requirements
4.1 Performance Requirements
4.2 Security
4.3 Usability
4.4 Scalability
● Support increased traffic during festive sales or promotions.
4.5 Availability
5. System Architecture
● Frontend: Built using Salesforce Commerce Cloud.
● Backend: Powered by Salesforce CRM and Marketing Cloud.
● Database: Salesforce native database.
● Integration: Payment gateways, shipping APIs, and social media platforms.
7. Constraints
● The system must adhere to GDPR and PCI-DSS compliance for data protection and
payment security.
● Limited customization due to Salesforce platform constraints.
Practical No.3
An Entity Relationship Diagram (ERD) for an online jewelry store would depict the connections
between key entities like "Customer," "Product," "Order," "Category," "Payment," and "Shipping
Address," illustrating how each piece of data relates to one another within the store's database,
allowing for efficient management of customer information, product details, orders, and payment
processing
Key Entities and Relationships:
● Customer:
● Attributes: Name, Email, Phone Number, Shipping Address, Billing Address, Password
● Relationship:
● "Places" one-to-many "Orders"
● Product:
● Attributes: Product ID, Name, Description, Price, Image, Category, Material, Gemstone Details, Size,
Stock Availability
● Relationship:
● "Belongs to" one "Category"
● Relationship:
● "Has many" "Products"
● Order:
● Attributes: Order ID, Order Date, Total Price, Shipping Cost, Payment Method, Order Status
(Pending, Processing, Shipped, Delivered)
● Relationship:
● "Placed by" one "Customer"
● Relationship:
● "Belongs to" one "Order"
● Payment:
● Relationship:
● "Associated with" one "Order"
● Shipping Address:
● Attributes: Address Line 1, Address Line 2, City, State, Zip Code
● Relationship:
● "Can be linked to" many "Orders"
Key Relationship Cardinalities:
● Customer to Order: One-to-Many (A customer can place multiple orders)
Zero Level Data Flow Diagram (0 Level DFD) of jewellery Shop Management System :
This is the Zero Level DFD of jewellery Shop Management System, where we have elaborated the high
level process of jewellery. It's a basic overview of the whole jewellery Shop Management System or
process being analyzed or modeled. It's designed to be an at-a-glance view of Quality, Payment and
Product showing the system as a single high-level process, with its relationship to external entities of
jewellery, Design and Stock. It should be easily understood by a wide audience, including jewellery,
Stock and Quality In zero level DFD of jewellery Shop Management System, we have described the high
level flow of the jewellery system.
High Level Entities and proccess flow of jewellery Shop Management System:
First Level DFD (1st Level) of jewellery Shop Management System shows how the system is divided
into sub-systems (processes), each of which deals with one or more of the data flows to or from an
external agent, and which together provide all of the functionality of the jewellery Shop Management
System system as a whole. It also identifies internal data stores of Product, Payment, Quality, Sales,
Stock that must be present in order for the jewellery system to do its job, and shows the flow of data
between the various parts of jewellery, Stock, Payment, Product, Quality of the system. DFD Level 1
provides a more detailed breakout of pieces of the 1st level DFD. You will highlight the main
functionalities of jewellery.
Main entities and output of First Level DFD (1st Level DFD):
Processing Quality records and generate report of all Quality Processing Payment records and generate
report of all Payment
Key Actors:
1. Customer – This is the primary user of the system.
2. Admin – Responsible for managing products, orders, and customer data (optional for this specific use
case diagram, unless you're considering an admin role).
3. System – The e-commerce platform that processes actions and manages the store's functionality.
1. Actors:
o Customer: The person who will interact with the store for browsing, purchasing, and managing
their profile.
2. Use Cases:
o Search: The customer searches for specific jewelry items.
o Browse: The customer browses through the jewelry categories or list of available products.
o View Profile: The customer can view and edit their account details, such as name, email, and
shipping address.
o Add to Shopping Cart: When a customer finds an item they like, they can add it to their
shopping cart.
o View Cart: The customer can view the contents of their cart.
o Order: The customer can review their cart and proceed to order.
o Checkout: The final step where the customer provides shipping and payment details to complete
the purchase.
Practical No. 6
The Activity Diagram for logging into an online jewelry store shows the sequence of actions and decisions
involved when a user attempts to log in to their account. This involves verifying the user's credentials, and
depending on the outcome (successful or failed login), the system either grants access or asks the user to
retry or reset their password.
Here is a step-by-step breakdown of the Login Process:
Steps in the Login Activity Diagram:
1. Start: The user initiates the login process by choosing to log in to the store.
2. Enter Username and Password: The user is prompted to enter their username (or email) and password.
3. Validate Credentials:
o The system checks whether the entered username and password match an existing account in the
database.
4. Decision (Valid Credentials?):
o If Yes, the system proceeds to grant the user access.
o If No, the user is shown an error message and is given the option to retry or reset the password.
5. Retry: If the user chooses to retry, they are prompted to enter the credentials again.
6. Reset Password: If the user selects the option to reset their password, the system takes them through the
password recovery process.
7. Successful Login: If the login is successful, the user is granted access to their account (e.g., redirected to the
homepage or their profile page).
8. End: The login process is either completed successfully, or the user exits or retries.
Practical No. 7
The name of the diagram itself clarifies the purpose of the diagram and other details. It describes
different states of a component in a system. The states are specific to a component/object of a
system.
A Statechart diagram describes a state machine. State machine can be defined as a machine which defines
different states of an object and these states are controlled by external or internal events.
Activity diagram explained in the next chapter, is a special kind of a Statechart diagram. As
Statechart diagram defines the states, it is used to model the lifetime of an object.
Statechart diagram describes the flow of control from one state to another state. States are defined as a
condition in which an object exists and it changes when some event is triggered. The most important
purpose of Statechart diagram is to model lifetime of an object from creation to termination.
Statechart diagrams are also used for forward and reverse engineering of a system. However, the
main purpose is to model the reactive system.
This is the UML sequence diagram of jewellery Shop Management System which shows the interaction
between the objects of Payment, Quality, Sales, Jwellery, Product. The instance of class objects involved in
this UML Sequence Diagram of jewellery Shop Management System are as follows
● Payment Object
● Quality Object
● Sales Object
● Jwellery Object
● Product Object
A Login Sequence Diagram for an online jewelry store would depict the flow of interactions between the
user and various systems (e.g., front-end, back-end, database) when a user attempts to log into the platform.
Below is an outline of what the sequence diagram might look like:
Participants (Objects):
● Stock Component
● Design Component
● Product Component
● Quality Component
● Jwellery Component
●
Features of jewellery Shop Management System Component Diagram
● You can show the models the components of jewellery Shop Management System.
Jewellery Shop Management System Class Diagram describes the structure of a jewellery Shop
Management System classes, their attributes, operations (or methods), and the relationships
among objects. The main classes of the jewellery Shop Management System are Jwellery, Stock,
Sales, Quality. Payment, Product.
Classes and their attributes of jewellery Shop Management System Class Diagram:
Diagram: