Using MySQL Workbench and PhpMyAdmin, perform transactions using the sample dataset. For each of the following, show the SQL query and its results:

1. Using MySQL Workbench, load and execute the createdb script to create the sampdb database
2. Using MySQL Workbench, connect to the sampdb database to create the student, grade event, score and absence table using the create scripts from the sample dataset.
3. Using MySQL Workbench, connect to the sampdb database to populate the student, grade event, score and absence table using the insert scripts from the sample dataset.
4. Access MySQL via your Web hosting account to add a database with the name 'sampdb'
5. Access phpMyAdmin via your Web hosting account to create and populate 3 tables in the sampdb database using the scripts from the sample dataset.

Submit this assignment to the dropbox "Assignment 04: Using SQL." This assignment is worth 50 points and will be graded according to the scoring guide below.

SCORING GUIDE ( 50 POINTS )

 

Rating Scale
10 - 9	Work meets or exceeds criterion at a high level of competence.
8	Work reflects an understanding of criterion with minor misunderstandings/misconceptions.
7	Criterion partially met, but one or more important concepts/skills are missing or flawed.
6	Work reflects an attempt to meet criterion, but significant misunderstandings/misconceptions are apparent.
5-0	Criterion not met or work is absent.

 

Criteria
1.	Sampdb database created in MySQL Workbench using sample dataset.
2.	Student, grade event, score and absence table created in MySQL Workbench using sample dataset.
3.	Student, grade event, score and absence table populated with data from sample dataset.
4.	Sampdb database added to MySQL Web host account.
5.	Three tables created and populated in phpMyAdmin using data from sample dataset.