Creating the Database
The first thing that we need to do is create a database for our project.
Launch MySQL Workbench and create a new file by clicking on File > New Query Tab. Save this file as sportsDB.sql (File > Save Script As... ).
We are going to create a database called sports_booking.
Enter the line
CREATE DATABASE sports_booking;
into sportsDB.sql and execute it.
If all goes well, you should see the message
1 row (s) affected
in the output window.
As we move forward with the project, you’ll be asked to perform various SQL tasks. Do remember to click on the ‘Execute Statement' button to execute your SQL statements after each task. This will allow you to check and correct any mistake as you go along.
In addition, you can also create another SQL file called drop.sql. If you make any mistake in your SQL code and need to make amendments, you can drop the...