Instructor: David Schuff

Assignments

Assignment #2: Getting Information Out of a Database (SQL #2)

Here is the assignment instructions.

And here is the movie rental schema you’ll need to do the assignment!

Remember, you must submit a single Microsoft Word document with the query you used and the answer that was returned. If your submission does not have both of these you will not get credit for the assignment.

The assignment is due by the start of class on September 26, 2017.

Assignment #1: ER Modeling

Here is the assignment instructions.

Use ERDPlus to complete the assignment. It is pretty straightforward to use, but this handy video shows you how to create an ERD and export the diagram as a graphic. That graphic can then be inserted into a Microsoft Word document.

Remember, you must submit a single Microsoft Word document – if you send multiple graphic files, or multiple Word files, you will not get credit for the assignment.

The assignment is due by the start of class on September 14, 2017.

Where and when do we meet?
Alter Hall 232
12:30 - 1:50 Tuesdays and Thursdays
Office Hours
David Schuff (instructor):
2:00-3:00, Tuesdays and Thursdays
Speakman Hall 210E and email (see my site)

Lauren Soentgen (ITA):
1:00 - 2:00 Mondays
11:00-12:00 Fridays
Speakman Hall 210D (and see her site)