I use MySQL. Please help with correct commands to create this tables above.

Assignment Description: Using your programming assignment experience for the TAL Distributors database, you will now create the database tables for the Colonial Adventure Tours database. To design and populate the tables with the data needed for the future assignments, study CAREFULLY the FIVE tables (GUIDE, TRIP, CUSTOMER, RESERVATION, TRIP_GUIDES) illustrated in pages 9 through 13 in the textbook. 1. Design each table structure that can correctly store the data illustrated in the table figures 1-4 through 1-8 using appropriate data types and length along with identifying the primary key(s) correctly in each table. You should use the table layout of each table illustrated in Figure 3-39 on pages 91-92 of the textbook in choosing the primary_key, data type and length. (50 points)