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

commerce platform. Focus on the following requirements:

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

system. Provide an Entity Relation Diagram for the system and show the transformation 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 optimized for effective querying.

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

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

vertical, or hybrid, based on the characteristics of the chosen table. Consider the impact of

fragmentation on query performance and propose optimization techniques. Provide SQL

commands or scripts to implement the chosen fragmentation strategy.

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

transaction for order placement and payment, ensuring data consistency in a parallel execution

environment.

$5.$ Implement access controls using PostgreSQL's role$-$based authentication. Define roles

for customers, administrators, and a superuser with appropriate permissions.

$6.$ Design and implement a data replication strategy for fault tolerance. Replicate customer

data across nodes and show how the system deals with node failures.

$7.$ Write and execute optimized SQL queries for e$-$commerce operations, like retrieving

product details, customer orders, and payment history. Utilize parallel query execuCon

wherever applicable.

$8.$ Implement a sample transaction involving multiple SQL statements including error

handling. Also, demonstrate the use of transactions and rollbacks in the distributed

environment.

Need the SQL statements and implementation