$[4]$ Chapter LB$2.$Activityr$2.$pdf

$(1)$ File $|$ Ci$/$Users$/$CCAC$\_$Loaner$/$Documents$/$Chapter$\%20...$

CREATE TABLE STUDENT$\_$ACTIVITY

StudentID

Activity

ActivityFee

INT

VARCHAR $(45)$

Numeric $(6,2)$

NOT NULL,

NULL,

NULL,

CREATE TABLE ACTIVITY$\_$FEE$($

Activity

INT $(45)$

NOT NULL,

ActivityFee

VARCHAR$(6,2)$

NULL.

INSERT STUDENT$\_$ACTIVITY VALUES

SELECT $*$ FROM STUDENT$\_$ACTIVITY;

$/$

Chapter LB$2\_$Activityr$2.$pdf

File

C:$/$Users$/$CCAC$\_$Loaner$/$Documents$/$Chapter$\%20...$

INSERT ACTIVITY$\_$FEE VALUES

$(\text{'}Golf\text{'}65\mathrm{.}00),$

$(\text{'}Skiing\text{'}200\mathrm{.}00),$

$(\text{'}Swimming50\mathrm{.}00)$;

SELECT $*$ FROM ACTIVITY$\_$FEE;

CREATE TABLE STUDENT$\_$HOUSING

StudentID

Building

BuildingFee

$2.$

INT

INT $(45)$

Numeric $(8,2)$

NOT NULt, NULL. NULt:

CREATE TABLE HOUSING FEE$($

Building

VARCHAR $(45)$

BuildingFee

Numeric $(8,2)$

NOT NULL, NULL

INSERT STUDENT$\_$HOUSING VALUES

$(100,$ 'Randopih', $3200\mathrm{.}00),$

$(200,$ 'Ingersoll' $3400\mathrm{.}00$

CIT$230$ DATABASE SYSTEMS

LAB$\_1$

Part $1.$

Directions:

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

Create the database.

Start the MySQL Server.

Execute the script by clicking the Execute button in the MySQL Editor toolbar or by pressing 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 the SELEC FROM For instance:

$\backslash$table$[[,$StudentID,,$],[1,,$Activity,ActivityFee$],[,100,$Golf,$65\mathrm{.}00],[2,100,$Skiing,$200\mathrm{.}00],[3,200,$Sking,$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]]$