as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
build a database for tracking customer orders.
user
the database will include tables for customer information, orders, products, and payment. the customer table will include fields for customer name, address, email, and phone number. the orders table will include fields for order number, customer id, product id, quantity, status, and total. the products table will include fields for product id, name, and price. the payment table will include fields for order number and payment type.
assistant