A project to design a database structure to manage a simple e-commerce system which has 3 tables they are customers, orders and products. Each table as the details of the customers and theirs products and order details.
customer: This table stores name, email, address. Orders: This table stores customer id, order date, amount. products: This table stores product name, product price and description of the products,
With this data we have solved some queries, normalized the tables and created DB Design for these tables.