Solution to Activity 3.1

The solution to this activity is as follows:

1. Open a new query tab.
2. Enter the following SQL statement into the query tab:

   -- -----------------------------------------------------
   -- Table 'autoclub'.'eventmemberregistration'
   -- -----------------------------------------------------
   CREATE TABLE IF NOT EXISTS 'autoclub'.'eventmemberregistration' (
     'ID' INT NOT NULL AUTO_INCREMENT,
     'ClubEventID' INT NOT NULL,
     'MemberID' INT NOT NULL,
     'ExpectedGuestCount' INT NOT NULL DEFAULT 0,
     'RegistrationDate' DATE NOT NULL,
     'FeesPaid' BIT NOT NULL DEFAULT 0,
     'TotalFees' DOUBLE NOT NULL DEFAULT 0,
     'MemberAttended' BIT NOT NULL DEFAULT 0,
     'ActualGuestCount' INT NOT NULL DEFAULT 0,
     'Notes' MEDIUMTEXT NULL,
    ...