MIS2502 (Sp12) - Data Analytics (Section 003)

Here is the assignment.

Correction: The first question requires seven SQL statements, not five.

As you’re working through the assignment, if you get an error message like this:

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

Do the following to fix it:

1. Go the Edit menu and select Preferences.
2. Select the “SQL Editor Tab”
3. Uncheck the “Safe Updates” box
4. Close MySQL Workbench and restart the program. This will let you make “unsafe” updates. But be careful!

Here is the assignment.

Here is the assignment instructions.