I have a question im working onAssignment Tasks

Task $1$: Schema Design and Setup $(20$ Marks$)$

Design a Schema:

Design a schema for a fictitious e$-$commerce application with the following requirements:

Users Table: Stores user information including user ID$,$ name, email, and registration date.

Orders Table: Stores order information including order ID$,$ user ID$,$ product ID$,$ quantity, and order

date.

Products Table: Stores product information including product ID$,$ name, description, and price.

Consider the appropriate data types, primary keys, and secondary indexes.

Create the Schema:

Write the CQL $($Cassandra Query Language$)$ commands to create the tables based on your design.

Task $2$: Data Insertion and Manipulation $(30$ Marks$)$

Insert Data:

Insert at least $5$ records into each table: Users, Orders, and Products.

Use realistic sample data for the e$-$commerce application.

Perform Queries:

Write CQL queries to perform the following operations:

Retrieve all orders placed by a specific user.

Retrieve all products ordered in the last $30$ days.

Retrieve user information based on user ID$.$

Consistency Level:

Explain how you would configure consistency levels for the above queries to ensure data accuracy.

Provide examples of CQL commands with different consistency levels. $($Provide a theoretical write$-$

up only$)$

Deliverables

Schema Design Document:

Submit a document outlining your schema design, including table structures and primary keys.

CQL Scripts:

Provide CQL scripts for schema creation, data insertion and results of your queries with sample

data.

Consistency and Repair Explanation:

Provide explanations for consistency levels and data repair procedures.