Creating a database from 0 in MySQL

The work was done for the purpose of the school project. There are no easy procedures, types.
The base consists of 8 tables as requested by the customer. Each of the tables is connected by keys that are based on the connection between the tables.