Im working on this question i need helpTask $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.