In response to the evolving market demands caused by the digitalisation of the economy, a local electronics retailer initiated an aggressive plan to enhance customer satisfaction and optimise its business processes. Consequently, the local retailer strategically implements an extensive initiative customized to the specific requirements of managing data within the electronics retail industry.

Assume you are employed as a Database Administrator $($DBA$)$ for this local electronics retailer. The company operates an online platform and physical stores offering a diverse range of electronic gadgets, appliances, and accessories. As part of your responsibilities, you are tasked with designing and implementing a database system for their Product Management System. The database solution should enable efficient storage and retrieval of information related to product inventory, customer interactions, order processing, and sales data, ensuring smooth operations and enhancing customer satisfaction throughout their shopping activities.

The scope of this project is focusing on the database design and implementation by providing the following tasks:

$($a$)$ Identify ALL possible entities that are related to the Product Management System $($give suitable entity name$),$ and complete all the entities with suitable attributes together with a primary key. $($Use your assumption to determine the attributes.$)$

$($b$)$ Identify ALL relationships, cardinality, and$/$or participation for each identified entity.

$($c$)$ Draw an Entity Relationship Diagram $($ERD$)$ by clearly stating the relationships between entities, cardinalities and attributes using the correct notation.

$($d$)$ Based on ERD created in $($c$),$ convert it into a relational schema. State the primary key and foreign key for each relational schema $($relations$).$

$($e$)$ Create all relevant relations $($tables$)$ based on the relational schema in $($d$).$ Choose appropriate data types for each attribute. Indicate the primary key and foreign key in each relation $($table$)$ created.

$($f$)$ Produce sample records for each relation $($table$)$ that observe the relational integrity rules. FIVE records per relation are enough.

$($g$)$ Then, produce FIVE SQL queries that can be used to manipulate the data from each relation and show ALL the results from each of the queries. $($The queries should include a simple query, query for sorting results, aggregate function, sub$-$queries and query to alter the existing tables.$)$

Note:

You are free to use any Databases Management System $($DBMS$)$ tool $($using DDL SQL or GUI$).$

You should submit a printout $($screen capture$)$ of:

$1.$ Each table shows the table name, fields and sample records.

$2.$ Each query in $$SQL View$,$ so that the grader can see your SQL code.

$3.$ The result of each query $($in table format$).$