Before you start these exercises, you need to install the MySQL server and MySQL Workbench. The procedures for doing that are provided in the textbook in appendix $A($Windows$)$ and appendix B $($Mac$).$

Complete the following:

Make sure the MySQL server is running

Start MySQL Workbench and open a connection for the root user.

Check to make sure you are connected to the server

Do you see any databases listed in the schemas?

Are the lightning bolt icons lit up or dim? $($If dim, you are not connected$)$

If you are not connected, start the database server.

Use MySQL Workbench to create the Chelsea Books database.

Open the script named chelsea$\_$books.sql$.$

Execute the entire script by either

Clicking on the first lightning bolt icon OR$,$

Pressing Ctrl$+$Shift$+$Enter $($press all three keys at the same time$)$

Review the Chelsea Books database

In the Schemas window $($on the left$),$ expand the database called Chelsea$\_$books. Note the list of database objects in the database: Tables, Views, Stored Procedures, and Functions.