MySQL and MySQL Workbench Install
In this assignment you will install MySQL and MySQL Workbench on your computer.
If you don't have them installed already, download and install MySQL and MySQL Workbench on your computer (30 min. - 1 hour)
Both are Open-Source (free) and available for all 3 platforms.
NOTE: Doing this class in Linux rather than in Windows or Mac will give you an advantage. The vast majority of server database systems are run in the Linux/UNIX environment. (It is still not too late to get into my Linux class IT-135.)
horizontal bar
Hybrid Class Assignment -- Simple Table Corrections
I have a simple Vendor/Parts tracking database with 3 tables as shown below --
I have 2 problems:
  1. I cannot seem to add a 2nd phone number for my vendors without deleting the first one
  2. I can only purchase 1 product in each purchase transaction
What do I need to do to fix these problems ? (Your answers should be less than 1 page long) -- 15 min

There is an extra credit assignment tied to this lab. If you would like credit, it is best to do it now and submit it with the rest of your submissions. The link to it is here:
Extra Credit For Lab 1

Assignment Submission Criteria
To turn in this assignment you will go to the NSC Canvas shell for this class. Submit:
  1. A screenshot showing a running MySQL Workbench instance on your computer
  2. A 1 page answer to my problem in the hybrid section
Do not submit your assignments any other way
Return to Assignment Index