David Schuff

Click here for a copy of the presentation slides.  We’ll cover this in week 5.

In this lecture, we’ll discuss the use of Structured Query Language (SQL) to performs operations related to creating and deleting […]

Assignment: SQL (Getting Data out of the Database) – Due Date 9/26/2012

For this assignment, you will be working with the same movie rental database as your in-class exercise. The schema is also the same, so […]

Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.

Click here for instructions on the inclass exercise. Also, you can view the complete schema of the database here.

Of the two ERD in-class exercises, we could complete only one. To receive 0.5 pts bonus points, draw an ERD for the business scenario described in the other in-class exercise (click here for the link). Also […]

Here is the ERD of the business scenario that we completed in class. Prepare a set of relational tables based on this ERD following the rules discussed in the class.  To receive a bonus of 0.25 pts, submit your […]

We’ll be using the MySQL Workbench utility (client) to connect and interact with a MySQL server database. The MySQL workbench is available on the classroom netbooks.

This document explains:

How to set up […]

Due Date : September 19: note that the syllabus mentions the due date of September 17.
Assignment: ER Modeling
Create an ER model for the following two scenarios. Make sure that you read the description […]

Go to community.mis.temple.edu/gradebook – click here

Login using your Accessnet username and password

If the gradebook does not show any grades

Confirm with your professor that a grade has been entered […]

Click here for class captures by date:

September 10, 2011

September 12, 2011

September 14, 2011

Click here for a copy of the presentation slides.  We’ll cover this in week 4.

In this lecture, we’ll discuss the use of Structured Query Language (SQL) to extract information from a database using the SELECT statement.

Think for about 100 seconds what you learnt in class during week 3 and summarize your thought here.

Summarize the differences between the three customer segments at MGM in terms of: a. Customer Interaction Model, b. Role of Information Systems

Comment on the following with respect to the MGM case: “you cannot become a whale just by eating at the buffet.” Also, explain whether this makes business sense for the firms. (Hint: See Q5b from the MGM case […]

Click here for a copy of the presentation slides. We will cover this in week 3.

In this lecture, we’ll provide an overview of MySQL and discuss the use of  MySQL Workbench to write queries.

Prepare an Entity Relationship Diagram (ERD) for the following business scenario:

The Monster Car Company produces specialty vehicles by contract, all with the “Monster” theme. The company operates several […]

Prepare an Entity Relationship Diagram (ERD) for the following business scenario:

The Big City public housing agency has assigned you the task of keeping track of who is living in the agency’s developments over […]

Click here for class captures by date:

September 5, 2012

September 7, 2012

Click here for class captures by date:

August 27, 2011 – not available due to technical issues

August 29, 2011

August 31, 2011

pls note that class captures may not be available for all dates due to […]

Think for about 100 seconds what you learnt in class during week 2 and summarize your thought here.