Quick jump links:    Announcements    Office Hours    Handouts etc.    Handouts (most recent class)    Homework Solutions

Jonathan Eckstein's Management Information Systems (MIS) Sections 33:136:370:03/04

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

Announcements (As of August 06, 2015 08:28 AM)

Usual Office Hour Schedule

My office is 100 Rockafeller Road, room 5145.   Regular office hours are now over for the semester, and I have a sabbatical for the 2014-2015 academic year.  Therefore, all office meetings are by appointment.
 

Handouts, Class Materials, and Assignments

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

  1. Tuesday, January 21.  Introduction, class procedures, IT basics
  2. Friday, January 24.  Introduction to relational database concepts, first introduction to Access, Access tables, and Access forms
  3. Tuesday, January 28.  More basic Access objects: reports and queries, plus some a bit more about forms
  4. Friday, January 31.  Memory storage size calculations
  5. Tuesday, February 4.  Finish storage size calculations, introduction to data management
  6. Friday, February 7.  Relational database theory part I, ER diagrams, bubble diagrams
  7. Tuesday, February 11.  One-to-many design exercises, zip codes
  8. Friday, February 14.  Multiple-table databases in Access, a bit of SQL
  9. Tuesday, February 18:  Designs with multiple paths between tables, multiple tables in Access II, more on SQL
  10. Friday, February 21.  More access forms, navigation forms, and subtypes
  11. Tuesday, February 25.  Discuss midterm format, basic background material on systems, start networks
  12. Friday, February 28.  Practice for midterm (buses problem), more networks
  13. Tuesday, March 4.  First midterm exam (BRR room 5071)
  14. Friday, March 7.  Many-to-many relationships, standard retail database structure
  15. Tuesday, March 11.  Results of first midterm, more design exercises with many-to-many relationships
  16. Friday, March 14.  Normal forms and normalization
  17. Tuesday, March 25.  Multiple relationships between the same pair of tables
  18. Friday, March 28.  More multiple relationships, multi-relationships in Access, queries, and SQL
  19. Tuesday, April 1.  More queries, including aggregation
  20. Friday, April 4.  More queries, query chaining, and subqueries
  21. Tuesday, April 8.  Business intelligence
  22. Friday, April 11.  Finish business intelligence and related topics, review for midterm, possibly start acquisition and development
  23.   $ Tuesday, April 15.  Second midterm exam
  24. Friday, April 18.  Class cancelled due to very low anticipated attendance (Good Friday plus many other events)
  25. Tuesday, April 22.  Review exams, development and acquisition processes
  26. Friday, April 25.  Unary relationships
  27. Tuesday, April 29.  Finish development and acquisition, security
  28. Friday, May 2.  Finish security, review for final exam

Homework Solutions

Unless otherwise noted, all solutions are in PDF format, viewable with Adobe Reader.  All these links connect to Sakai and will require a Rutgers NetID login.