Hi tutor. I am so new in database. So i have a hard time to understand everything. the challenge is:

The digital economy boomed during the COVID-19 crisis. As people embraced social distancing, they turned to online shopping more than ever before and become an increasingly important in our daily life. Online shops utilise digital information and communication technologies, such as computers and mobile devices, to access and manage the data of users, customers, products, supplier, carts, orders, and payments.

Assuming that I am a database designer for the local merchant, i need to propose a database design for the online platform to manage their business activities by providing the following:

1. to i dentify ALL possible entities in any relevant business activities process (give suitable entity name), complete all the entities with suitable attributes together with assign primary key. (Use your assumption to determine the attributes.)
2. to identify ALL relationships, cardinality, and/or participation for each identified entity.
3. to draw an Entity Relationship Diagram (ERD) by clearly stating the relationships between entities, cardinalities and attributes with correct notation.
4. Based on ERD created in (3), convert it into a relational schema. State the primary key and foreign key for each relational schema (relations).
5. Create all relevant relations (tables) based on relational schema in (4). Choose appropriate data types for each attribute. Indicate the primary key and foreign key in each relation (table) created.
6. to produce sample records for each relation (table) that observe the relational integrity rules. FIVE records perrelations are enough.
7. 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:

Can use any Databases Management System (DBMS) tool (using DDL SQL or GUI).

I need to submit a printout (screen capture) of:

1. Each table which 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).

also another question:

• In your opinion,what mechanisms should be used to ensure that all the data stored in the database is accurate and consistent?