<prompt> Design a database schema for storing customer orders.  <response>: Heres a basic database schema for storing customer orders:Table 1: Customers- CustomerID Primary Key - a unique identifier for each customer- CustomerName - the name of the customer- CustomerAddress - the customers address- CustomerEmail - the customers email address- CustomerPhoneNumber - the customers phone numberTable 2: Products- ProductID Primary Key - a unique identifier for each product- ProductName - the name of the product- ProductDescription - a description of the product- ProductPrice - the price of the productTable 3: Orders- OrderID Primary Key - a unique identifier for each order- CustomerID Foreign Key - the ID of the customer who made the order- OrderDate - the date the order was placed- OrderTotal - the total cost of the orderTable 4: OrderDetails- OrderDetailID Primary Key - a unique identifier for each order detail- OrderID Foreign Key - the ID of the order- ProductID Foreign Key - the ID of the product ordered- Quantity - the quantity of the product ordered- UnitPrice - the price per unit of the product orderedThis schema includes four tables: Customers, Products, Orders, and OrderDetails. The Customers table stores information about each customer, while the Products table stores information about each product. The Orders table stores information about each order, including the customer who made the order, the date it was placed, and the total cost of the order. The OrderDetails table links the Orders and Products tables, storing information about the specific products ordered, including the quantity and unit price. 