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

Jonathan Eckstein's Management Information Systems (MIS) Sections 33:623:370:03, 33:623:370:04, and 33:623:370:06

This page is for my Spring 2012 classes. Click here for my Spring 2011 class or earlier classes.

Announcements (As of May 08, 2012 02:37 PM)

It's over! Final exam scores, course aggregate scores, and course grades should all be visible on Sakai. I have also submitted grades to the registrar, which should be visible by May 9. The letter grades posted on Sakai are "unofficial" -- the registrar ones are the official ones (although I don't think there should be a discrepancy).
Regular office hours are over. If you want to go over your exam or need to see me for any other reason, please make an appointment by e-mail.
After the posting of final exams and course grades, I enforce a one-week "cooling off" period for all grade-related inquiries. So I will not reply to grade-related e-mail until May 15 at the earliest..
Homework 10 and a large assortment of older homework is available for pickup from the box out side my office door. Please do not pick through my personal mailbox around the corner from my office.
This site is used for unlimited-release material, with Sakai used for limited-release material (although typically I will also provide links to specific Sakai pages through this site). I do not use BlackBoard.

Usual Office Hour Schedule

My office for meeting undergraduate students is in the J. H. Levin building, room 255. Tentatively, my schedule for regular office hours for Spring 2012 is

Mondays 2:30-4:00 PM
Thursdays 3:00-5:00 PM
Or other times by appointment

Check the announcements section above for office hour changes and cancellations.

Handouts, Class Materials, and Assignments

All lecture notes are stored on Sakai and will require a Rutgers NetID login.

Tuesday, January 17 (Thursday, January 19 for Section 06): Introduction, class procedures, IT basics
- Syllabus
- Orignally intended class schedule, now superseded (refer to first page for sections 03 and 04, second page for section 06)
- Lecture notes #1
Friday, January 20 (Thursday, January 19 for Section 06): Introduction to relational database tables and Access [In Lab]
- Lecture notes #2
- Homework 1, due January 26/27 (work in progress, do not download)
  - BooksData.txt file needed for homework 1 (Note: if the data simply appear in your browser rather than downloading to a file, just perform the "save page as" operation in your browser to save the file.)
Tuesday, January 24 (Thursday, January 26 for Section 06): More basic Access objects: reports and queries, plus some review of forms [In Lab]
- class-3-base.accdb starting point for in-class exercises
- Revised class schedule incorporating changes in computer lab availability (refer to first page for sections 03 and 04, second page for section 06)
- Lecture notes #3
Friday, January 27 (Thursday, January 26 for Section 06): Storage size calculations
- Lecture notes #4 (note: in Sections 03/04, the material at the end of these notes corresponds to the January 31 class)
- Homework 2, due February 2/3
  - Example of how answers to Q1 should look
  - Database to use for Q1 and Q2 (in case you did not correctly complete homework 1)
Tuesday, January 31 (Thursday, February 2 for Section 06): Introduction to data management and multiple tables
- Lecture notes #5
Friday, February 3 (Thursday, February 2 for Section 06): Relational database theory part I, ER diagrams, bubble diagrams
- Lecture notes #6 (part a -- in-class handout)
- Lecture notes #6 (part b)
- Homework 3, due February 9/10
Tuesday, February 7 (Thursday, February 9 for Section 06): One-to-many design exercises
- Video rental in-class example
- Lecture notes #7
Friday, February 10 (Thursday, February 9 for Section 06) Multiple tables in Access I [In Lab]
- Loan database with 3 tables but no relationships yet (loans-3tables-clean.mdb) (for in-class demonstration)
- Homework 4, due February 16/17
- Lecture notes #8
Tuesday, February 14 (Thursday, February 16 for Section 06): Designs with multiple paths between tables, multiple tables in Access II [In Lab]
- Personnel database in-class example
- Personnel database roughly as it should appear at the end of this class
- Lecture notes #9
Friday, February 17 (Thursday, February 16 for Section 06): More access forms, navigation forms, and subtypes [In Lab]
- Personnel database to start the class (similar to the end of the last class, but I uploaded a full set of zipcodes)
- Economics department and honors program in-class example (subtypes)
- Homework 5, due February 23/24
  - Sakai site to hand in Q3 (only); hand in Q1 and Q2 on paper.
- Lecture notes #10
Tuesday, February 21 (Canceled for Section 06 due to illness): Network technology
- Practice material for first midterm
- Lecture notes #11
Friday, February 24 (Canceled for Section 06 due to illness): More network technology, review for midterm
- Buses practice problem
- Lecture notes #12 (solution to the buses problem)
Tuesday, February 28 (Thursday, March 1 for Section 06): First midterm exam
- Due to the exam, there are no Lecture Notes #13
Friday, March 2 (Thursday, March 1 for Section 06): Many-to-many relationships, standard retail database structure [In Lab]
- Focus groups in-class example
- Computer store in-class example
- Computer store database for Access exercise
- Homework 6, due March 8/9
- Lecture notes #14
Tuesday, March 6 (Thursday, March 8 for Section 06): More many-to-many design exercises
- Project teams in-class example
- Library in-class example
- Lecture notes #15
Friday, March 9 (Thursday, March 8 for Section 06): Multiple relationships between the same pair of tables
- Commuter airline in-class example
- College in-class example
- Lecture notes #16
- Homework 7 to be distributed after spring break
  Tuesday, March 13 -- No class, spring break
  
  Thursday, March 15 -- No class, spring break
  
  Friday, March 16 -- No class, spring break
Tuesday, March 20 (Thursday, March 22 for Section 06): More multi-relationships, query lab I [In Lab]
- Sports league in-class example
- Database for sports league example
- Final version of database with relationships and queries from end of class
- Lecture notes #17
Friday, March 23 (Thursday, March 22 for Section 06): Normal forms and normalization
- Lecture notes #18 (in-class handout)
- Homework 7, due March 29/30
Tuesday, March 27 (Thursday, March 29 for Section 06): Advanced queries, query chaining, and related topics [In Lab]
- Sports league database from the end of previous query lab
- League standings query chain diagram
- Sports league database approximately as at the end of class
- Lecture notes #19
Friday, March 30 (Thursday, March 29 for Section 06): Enhancing the store database, more query chaining [In Lab]
- Computer store example with price histories
- Computer store database with price histories
- Graphical depiction of chained query
- Homework 8, due April 5/6
  - conference.mdb database for Q2
  - sports-with-games.mdb database for Q3 and Q4
- Lecture notes #20
Tuesday, April 3 (Thursday, April 5 for Section 06): Practice queries for midterm, start ethics
- Query practice questions
- Blank query grid answer sheet
- Additional practice material (print yourself):
  - Practice problems (on Sakai)
  - Blank sheet for answers to practice problem 1
  - Solutions to all five practice problems (on Sakai)
- There are no Lecture Notes #21. The small amount of lecture material from this class is covered in Lecture notes #22 (see below)
Friday, April 6 (Thursday, April 5 for Section 06) Ethical issues in modern information systems
- Lecture notes #22
Tuesday, April 10 (Thursday, April 12 for Section 06): Second midterm exam
- Due to the exam, there are no Lecture Notes #23
Friday, April 13 (Thursday, April 12 for Section 06): Unary relationships [In Lab]
- Employees database in-class example
- Course catalog in-class example
- Homework 9, due April 19/20
  - emp-self.accdb database needed for Q3 (the same as emp-self.accdb a few lines above)
- Lecture notes #24
Tuesday, April 17 (Thursday, April 19 for Section 06): Return and review exams, start security
- Lecture notes for this class will be included in Lecture Notes #26 (there will be no Lecture Notes #25)
Friday, April 20 (Thursday, April 19 for Section 06): More security
- Lecture notes #26 (also covers portions of classes 25 and 27)
- Homework 10, due April 26/27
Tuesday, April 24 (Thursday, April 26 for Section 06): Finish security, start development and acquisition
- Lecture notes #27 (also covers beginning of class 28)
Friday, April 27 (Thursday, April 26 for Section 06): Finish development and acquisition, review for final exam
- Final exam practice questions are on Sakai
- Final exam practice solutions are on Sakai
Thursday, May 3, 4-7pm in Beck Auditorium for all sections: 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.

Solution to homework 1
Solution to homework 2 (Note: the grader had an earlier version of this document with a small error on Q1(c); I have adjusted all grades to be one point higher than marked on your assignments.)
Solution to homework 3
Solution to homework 4
Solution to homework 5:
- Solution to homework 5, problems 1 and 2
- Solution to homework 5, problem 3 (.accdb database project format)
Solution to homework 6
Solution to homework 7
Solution to homework 8
Solution to homework 9
Solution to homework 10