Monthly Archives: January 2016
Protected: In Class Exercise #4 Key
Assignment #2
Here’s the document for Assignment #2. Assignment #2 – SQL #1
Remember to upload to OWLbox prior to class on the due date.
In Class Exercise #4 – SQL
Here’s the doc for In Class Exercise #4 – In-Class Exercise #4 – Pen and Paper Query Exercise
MySQL Workbench Instructions
MySQL Workbench Instructions
If you’re using a lab computer, you’ll need to configure a connection with your user ID and password. If you’re using your own computer (Windows or Mac), you’ll also need to install the software.
You can get instructions for how to do both of those things in this Quick Guide. Use the guide to setup your software and connection.
You’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Community Site Gradebook (you have to be logged into the site for the gradebook to work).
Protected: In Class Exercise #3 Key
Weekly Question #2
Leave your response as a comment on this post by the beginning of class on February 1, 2016. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
If you sign in using your AccessNet ID and password you won’t have to fill in the name, email and captcha fields when you leave your comment.
Answer this question:
What do you think is the trickiest thing about creating an ERD from a problem description? What advice would you give to deal with that issue?
In Class Exercise #3
Here’s the doc for In Class Exercise #3 – In-Class Exercise #3 – Creating Schemas
Protected: In Class Exercise #2 – Key
Capture – 1/22/16
Here’s the link to the class capture for 1/22/16