et$02-$xythos.content.blackboardcdn.com$/5$fe$35$a$2$eada$8$f$/...$

$1$

$100\%$

CIT$230$ DATABASE SYSTEMS

Part $1.$

Directions:

Before you start this exercise, you need to install MYSQL Workbench Server that you create

Create the database.

Start the MySQL Server.

Execute the script by clicking the Execute button in the MYSQL Editor toolbar or by F$6.$ When you do$,$ the Messages tab indicates whether the script was executed successfully.

Enter and run MYSQL statements.

Open a new Query tab window by clicking the New Query button in the toolbar.

A$.$ Using the MySQL database named Exercise$\_1.$

Create tables with the following attributes, run the and test the command by using FROM For instance:

$\backslash$table$[[,$StudentID,Activity,ActivityFee$],[,100,$Golf,$65\mathrm{.}00],[2,100,$Skiing,$200\mathrm{.}00],[3,200,$Skiing,$200\mathrm{.}00],[4,200,$Swimming,$50\mathrm{.}00],[5,300,$Skiing,$200\mathrm{.}00],[6,300,$Swimming,$50\mathrm{.}00],[7,400,$Golf,$65\mathrm{.}00],[8,400,$Swimming,$50\mathrm{.}00]]$