Design and implement a distributed and parallel database system using PostgreSQL for an e$-$

commerce pla:orm. Focus on the following requirements:

$1.$ Brief the requirements for the database system and the assumpCons considered for the

system. Provide an EnCty RelaCon Diagram for the system and show the transformaCon of the

ER diagram.

$2.$ Create a PostgreSQL database schema for the pla:orm with the required tables. Ensure

that the schema is normalized and opCmized for effecCve querying.

$3.$ Implement fragmentaCon strategies on the system. Select any table from the defined

schema for fragmentaCon and implement an appropriate type of fragmentaCon, i$.$e$.,$ horizontal,

verCcal, or hybrid, based on the characterisCcs of the chosen table. Consider the impact of

fragmentaCon on query performance and propose opCmizaCon techniques. Provide SQL

commands or scripts to implement the chosen fragmentaCon strategy.

$4.$ Implement a strategy for handling concurrent transacCons. Implement a sample

transacCon for order placement and payment, ensuring data consistency in a parallel execuCon

environment.