Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[ 4 ] Chapter LB 2 . Activityr 2 . pdf ( 1 ) File | Ci / Users / CCAC _ Loaner / Documents
Chapter LBActivityrpdf
File CiUsersCCACLoanerDocumentsChapter
CREATE TABLE STUDENTACTIVITY
StudentID
Activity
ActivityFee
INT
VARCHAR
Numeric
NOT NULL,
NULL,
NULL,
CREATE TABLE ACTIVITYFEE
Activity
INT
NOT NULL,
ActivityFee
VARCHAR
NULL.
INSERT STUDENTACTIVITY VALUES
SELECT FROM STUDENTACTIVITY;
Chapter LBActivityrpdf
File
C:UsersCCACLoanerDocumentsChapter
INSERT ACTIVITYFEE VALUES
;
SELECT FROM ACTIVITYFEE;
CREATE TABLE STUDENTHOUSING
StudentID
Building
BuildingFee
INT
INT
Numeric
NOT NULt, NULL. NULt:
CREATE TABLE HOUSING FEE
Building
VARCHAR
BuildingFee
Numeric
NOT NULL, NULL
INSERT STUDENTHOUSING VALUES
'Randopih',
'Ingersoll'
CIT DATABASE SYSTEMS
LAB
Part
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 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
Create tables with the following attributes, run the and test the command by using the SELEC FROM For instance:
tableStudentID,,Activity,ActivityFeeGolf,Skiing,Sking,Swimming,Skiing,Swimming,Golf,Swimming,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started