Create an ER diagram based on the given requirements for a

Retail Store Management System shown below. Make sure to

show the following information on the diagram: Entities,

Attributes, Relationships, Cardinality ratios, Total$/$Partial

participations, Keys.

State any assumptions you make.

Requirements:

The store sells multiple products, and each product has a

unique product ID$,$ name, description, price, and stock

quantity.

The store has multiple categories, and each category has a

unique category ID and name. Each product belongs to one

category.

Customers can make purchases, and each customer has a

unique customer ID$,$ name, email, and phone number.

Each purchase can include multiple products, and each

purchase has a unique purchase ID$,$ purchase date, total

amount, and is linked to a specific customer.

Each purchase can have multiple payment methods, with

details about the payment method type $($e$.$g$.,$ Credit Card,

Cash, Gift Card$).$

The store employs staff, each with a unique staff ID$,$ name,

role, and contact information.