The objective of this assignment is to construct and deploy a database management system for an online shopping market such as Hepsiburada or Amazon, utilizing MySQL as the database. The system will provide the capability to manage products, customers, orders, and inventory for an online store. The objective is to create a reliable and efficient system that allows for the manipulation and retrieval of data for an online

shopping platform.

In the first part of this assignment you are required to provide an Entity$-$Relation $($ER$)$

diagram for this problem and write SQL Data Definition Language $($DDL$)$ statements

for your entities and their relations, and Data Modification Language $($DML$)$ statements

for your sample data.

The objective of part $1$ of this project is the following:

$2$

$$ Design an ER diagram for an Online Shopping Market Database Management

System based on the provided description.

$$ Develop DDL SQL code to create the necessary tables based on the ER diagram

and populate them with your DML SQL code.

$2\mathrm{.}1$ Entity$-$Relationship $($ER$)$ Diagram

The steps involved in creating the ER diagram:

$1.$ Entity Identification: Identify the entities involved in an online shopping market $($e$.$g$.,$ product, customer, order, seller, category, and listing are the main

entities. Based on the design, you may or may not need to add other entities as

well$).$

$2.$ Attribute Identification: Define attributes for each entity based on the project

requirements.

$3.$ Relationship Identification: Establish relationships between entities. Decide

on relationship types $($one$-$to$-$one, one$-$to$-$many, many$-$to$-$many$).$

$4.$ Cardinality and Connectivity: Determine the cardinality and connectivity

between entities in the ER diagram.

$5.$ Create the ER Diagram: Utilize any diagramming tool to create a clear,

understandable ER diagram showcasing entities, attributes, and relationships.

The relations between entities at least should be as the following:

$$ Customers should at least have a unique ID $($such as their TCKN$)$ and username.

$$ Customers may have different payment methods.

$$ Each product only belongs to one category and the amount of any product could

not be less than $0$ in the stock.

$$ Each customer can order the same product at most three times in a single order.

$$ Each order should have a unique ID$,$ and the order date should be added automatically when the customer completes the payment process. Additionally, there

is a status flag, which means the customer has completed the payment or not.

$$ Each product may have different prices based on the seller.

$$ Product alone is not purchasable by the customers. There is a product DB and if

a seller wants to sell that product, it needs to create a listing $($list of the products

sold by the seller$)$ from that product, specifying its stock and price.