Gord Burtch

Do the second scenario from our in-class exercise, about housing and residents. Bring your diagram with you to class this Friday and we will discuss it briefly at the beginning.
I will have extended office […]

Here is the solution to the in-class exercise we did about ER diagrams (this is for Scenario 1: Inventory & Parts).

Notes… when given a business scenario like this, generally you should take the following […]

Here is the link.

Here is the link.

It’s time for your first assignment! For this assignment, you will need to read the attached scenarios and create the associated ER diagram. Make sure you follow the same notation we use in class (rectangles, […]

Hello everyone,

On Wednesday we will be spending our time on an in class exercise, on ER modeling. This excersise is intended to get you more familiar with the creation of ER diagrams, especially some more […]

This is relevant to the MGM grand case we plan to discuss today, particularly in regard to the casino “player cards” that MGM uses. This article discusses a particular niche that a number of tech startups have […]

Here is the link.

Answer one of the following questions as a comment on this post.

Submit your contribution by 3:00 PM on Friday, September 14. It should be insightful (don’t just repeat back facts from the class), but it […]

Here is a link to a potentially useful reference for ER diagrams. You can refer to this as we cover the topic as well as when you are doing your first assignment (I’ll be posting the ERD assignment soon).

Here is the link.

Here is the link.

Here are the questions for the case “Slots, Tables, and All that Jazz: Managing Customer Profitability at the MGM Grand Hotel.”

Make notes on these for the class discussion on September 10. Remember there will […]

This document explains:

How to set up MySQL Workbench on your own computer.
Set up a connection to our class server (on a lab computer or at home).

You have a username and password for the MySQL server. […]

After we finish with the material on Relational Modeling, we’ll dive into MySQL. This lecture will provide an overview of what a database server is, how it is used by a business, and the different ways that you […]

Here’s an interesting site that explores New York City’s subway data, offering a number of cool visualizations. The project, and the value of open government data more generally, was recently discussed by the […]

Here is a link to the class capture.

Here’s a link to an article from the Huffington Post a couple of days back discussing Homicide Watch. This is an independent organization that is tracking data on homicides and then hoping to sell that data to […]

Answer one of the following questions as a comment on this post. Make sure you log into the community site before writing your comment (I need to know your name to give you credit)!

Submit your contribution […]

Hello everyone,

As I had mentioned previously, I will not be present for our lecture this coming Friday. The lecture will be covered instead by Professor Wattal.

Another point I wanted to raise about the […]