Quick jump links:    Announcements    Office Hours    Handouts etc.    Homework Solutions

Jonathan Eckstein's Management Information Systems (MIS) Section 33:136:370:02

This page is for my Fall 2015 classes.  Click here for my Spring 2014 or earlier classes.

Announcements (As of January 06, 2016 11:29 AM)

Usual Office Hour Schedule

My office is 100 Rockafeller Road, room 5145.   Office hours are tentatively scheduled for

You may also make appointments if regularly scheduled office hours conflict with your class schedule.

Handouts, Class Materials, and Assignments

Note that all lecture notes and draft chapters are stored on Sakai and require a Rutgers NetID login.

  1. Thursday, September 3.  Introduction, class procedures, IT basics
  2. Tuesday, September 8:  Some fundamental relational database concepts, first introduction to Access, creating Access tables, entering data into tables, start Access forms
  3. Thursday, September 10:  Access forms, queries, and reports
  4. Monday, September 14:  Data management, start multi-table databases
  5. Thursday, September 17:  Data size calculations (substitute instructor)
  6. Monday, September 21:  Relational database theory, part I
  7. Thursday, September 24:  One-to-many design exercises, zip codes
  8. Monday, September 28:  Unplanned review/problem-solving session due to massive network outage disabling lab logins and file downloads
  9. Thursday, October 1:  Multiple-table databases in Access and a bit of SQL
  10. Monday, October 5:  Designs with multiple paths between tables, multiple tables in Access II, more on SQL
  11. Thursday, October 8:  Networks (plus other topics if time permits)
  12. Monday, October 12:  First midterm exam
  13. Thursday, October 15:  Go over midterm, more access forms, navigation 
  14. Monday, October 19:  Subtypes and many-to-many relationships
  15. Thursday, October 22:  More many-to-many relationships, including implementation in Access
  16. Monday, October 26:  Normal forms and normalization
  17. Thursday, October 29:  Multiple-relationships between the same pair of tables
  18. Monday, November 2:  Another multi-relationship example, queries in SQL part I (substitute instructor)
  19. Thursday, November 5:  More SQL
  20. Monday, November 9:  Query chaining and subqueries in SQL
  21. Thursday, November 12:  Review for midterm (spent entire class on SQL queries)
  22. Monday, November 16:  Midterm Exam -- all students report to BRR 3087
  23. Thursday, November 19:  Unary relationships
  24. Monday, November 23:  Review results of midterm, start lecture material on business analytics and intelligence
  25. Monday, November 30:  Continue business analytics and intelligence
  26. Thursday, December 3:  Review of query basics
  27. Monday, December 7:  Finish review of query basics, lecture on acquisition/SDLC
  28. Thursday, December 10:  Discuss final exam, lecture on security
  29. Wednesday, December 16:  Final exam in BRR 5101

Homework Solutions

All homework solutions are on Sakai and require a Rutgers NetID login and PDF reader.

  1. Solution to homework assignment 1
  2. Solution to homework assignment 2
  3. Solution to homework assignment 3
  4. Solution to homework assignment 4
  5. Solution to homework assignment 5
  6. Solution to homework assignment 6
  7. Solution to homework assignment 7
  8. Solution to homework assignment 8 (with minor typo correction 11/24/2015)
  9. Solution to homework assignment 9
  10. Solution to homework assignment 10