Assignment 2 -- Create A MySQL Table
In this assignment, we will get some experience using each of the 3 methods for writing SQL code -- from the command line, MySQL Workbench (the GUI) and from a text editor such as gedit for Linux, Notepad++ for Windows and Bbedit for Mac.

So in this exercise, we will create 3 different tables all related to your selected hobby. By the end of the assignment, we will have loaded all 3 tables with at least 5 records each.
MySQL Command Line

Let's start building your hobby database --

Manually create a table -- using the MySQL command line -- with the following criteria:

  • The table must have at least 5 fields
  • Populate your fields with data
  • Create a list of commands you used to perform this task
  • Run your commands in MySQL using the command line to make sure they are working
  • Take a screenshot of your working commands and table
MySQL Workbench

Manually create a table with the same criteria as above using MySQL Workbench GUI:

  • The table must have at least 5 fields
  • Populate your fields with data
  • Create a MySQL script file using the list of commands you used to perform this task
  • Run your commands in MySQL Workbench to make sure they are working
  • Save your script as a .sql file
  • Take a screenshot of your working script
Hybrid Class Assignment -- Using A Script File
Using A Script File
Create a script -- using either gedit, Notepad++ or Bbedit --that will create another table and (using your what was previously created) load all of your tables. The criteria is:

  • The table must have at least 5 fields
  • Your script should load a minimum of 5 records into each of your 3 tables
  • Run your script and take a screenshot of it working with no errors
  • Save your script to turn in
Assignment Submission Criteria
To turn in this assignment you will go to the NSC Canvas shell for this class. Submit the following as attachments:
  1. Screenshots of your working scripts
  2. Your .sql files
  3. **NOTE** The naming of your script files should be meaningful, not something generic. They should be named for your tables (which should be named correctly as well)
    For example, if you have a Sports table and have object names like: players, stats, venues and teams, this is how your script files should be named as well.


Return to Assignment Index