Overview

Database and Order Management:

1. Customer:

   • The "customer" table stores essential customer information, including names, email addresses, and phone numbers.

2. Product:

   • The "product" table contains details about the products available on the platform, including product names, descriptions, and prices.

3. Orders:

   • The "order" table tracks customer orders, recording order IDs, customer ID (linked to the customer's table), order dates, product ID (linked to the product's table) and total order amounts.