12. Exercises

It is time to put everything you have learned into practice. Here you have two complete projects that integrate all the concepts of the course: from designing the database to manipulating the data.

In all of them you must:

• Design the structure of the database (tables, columns, data types and relationships).
• Create the database using SQL statements.
• Insert sample data into the tables.
• Run SQL queries to extract relevant information.

And above all, don't be afraid to experiment.

Exercise 1: Coffee machine

Design and implement a database to manage an automatic coffee machine. The system must control the inventory of available coffee types and record all the payments made.

• Which is the best-selling coffee?
• How much money has been collected in total?

Exercise 2: E-commerce

Create a complete e-commerce system with management of customers, products, shopping carts, orders and invoices.

• Which is the best-selling product?
• Who is the customer who has spent the most?

I want you to manage the cart:

• Add products to the cart.
• Remove products from the cart.
• Modify the quantity of products in the cart.
• Create an order from the cart.