Please don't take the solution from chatGPT

Show me the steps to solve The advent of online shopping has revolutionized the traditional shopping experience, offering convenience to consumers worldwide. However, have you ever pondered the intricate processes that unfold once you confirm your purchase? Beyond the seamless transaction lies a sophisticated infrastructure comprising databases, servers, and applications working in unison.

Provide the relational database schema for an online shopping system where customers place orders. An order may consist of multiple products, with products categorized for easy organization and search. The Customer table identifies the customers placing orders with their personal information, while the Category table specifies the product categories and description. The Product table lists the available items for purchase and their prices, each linked to a category through the Category ID$.$ Orders, recorded in the Order table with date of order and the total amount, and they are associated with customers through the Customer ID$.$ The Order Detail table captures the intricate relationship between orders and products, detailing the products included in an order along with their respective quantities.

Please don't take the solution from chatGPT