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

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

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

• It's all over.  Exam scores should be be visible on Sakai, and letter grades should be on the registrar / transcript site.
• I observe a two-week cooling-off period after exam grades are posted, except in cases that would affect imminent graduation or dismissal.  So, except in very special circumstances (such as interfering with imminent graduation), I will not reply to exam-related e-mail until two weeks after the exam.  
   `

Usual Office Hour Schedule

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

• Tuesdays 2:00-4:30pm from September 9 through December 8, except
  • Office hours cancelled November 3 
  • No office hours November 24 (Thanksgiving)
  • Other changes, cancellations, or additions to be posted as needed
• Wednesdays 10:00am-12 noon, September 15 through December 9, except
  • Possible cancellation November 4 (I may be at a conference)
  • No office hours November 25 (Thanksgiving)
  • Other changes, cancellations, or additions to be posted as needed.

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
   • Syllabus
   • Planned class schedule (updated September 3 to correct typo)
   • Reading: draft chapter 1
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
   • class-3-base.accdb starting point for in-class exercises
   • Reading: draft chapter 2
   • Homework assignment 1, due September 17
     • counties-a-through-d.txt file for exercise
4. Monday, September 14:  Data management, start multi-table databases
   • Reading: draft chapter 3 (with minor revisions on September 21, 2015)
5. Thursday, September 17:  Data size calculations (substitute instructor)
   • Reading: supplementary notes on data size calculations
   • Homework assignment 2, due September 24
6. Monday, September 21:  Relational database theory, part I
   • PowerPoint slides from presentation in class (with some corrections made right after class, and few more edits on September 24)
   • Reading: draft chapter 4 (pages 1-12)
7. Thursday, September 24:  One-to-many design exercises, zip codes
   • Video lending library example handout
   • Reading: draft chapter 4 (pages 12-22)
   • Homework assignment 3, due October 1
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
   • Loan database with 3 tables but no relationships yet (loans-3tables-clean.mdb) (for in-class demonstration)
   • Reading: draft chapter 5 (pages 1-17)
   • Homework assignment 4, due October 8
10. Monday, October 5:  Designs with multiple paths between tables, multiple tables in Access II, more on SQL
    • Personnel database in-class example
    • Personnel database with full structure and a small number of data records added
    • Reading: draft chapter 5 (pages 18-25)
11. Thursday, October 8:  Networks (plus other topics if time permits)
    • Reading: supplementary notes on systems (will cover if time permits)
    • Reading: supplementary notes on networks
12. Monday, October 12:  First midterm exam
    • Last names A-K report to 100 Rock room 3031
    • Lat names L-Z report to 100 Rock room 3038
       
13. Thursday, October 15:  Go over midterm, more access forms, navigation 
    • Personnel database to start the class (similar to the database at the end of class 9, but with a full set of zip codes downloaded from the post office website)
    • Personnel database approximately as at the end of the class
    • Reading: draft chapter 6
    • Homework assignment 5, due October 22
14. Monday, October 19:  Subtypes and many-to-many relationships
    • Economics department and honors program in-class example (subtypes)
    • Reading: draft chapter 4 (pages 23-28 for material on subtypes)
    • Focus groups in-class example
    • Plumbing supply store in-class example
    • Reading: draft chapter 7 (pages 1-7)
15. Thursday, October 22:  More many-to-many relationships, including implementation in Access
    • Plumbing supply store hands-on example
      • Database (plumbingstore-clean.mdb) to start the class
      • Completed database
    • Project teams in-class example
    • Library in-class example
    • Reading: draft chapter 7 (pages 7-22)
    • Homework assignment 6, due October 29
16. Monday, October 26:  Normal forms and normalization
    • PowerPoint slides from presentation in class
    • Reading: draft chapter 9 (updated 11/4/2015)
17. Thursday, October 29:  Multiple-relationships between the same pair of tables
    • Commuter airline in-class example
    • College in-class example
    • Reading: draft chapter 8 (pages 1-10)
    • Homework assignment 7, due November 5
18. Monday, November 2:  Another multi-relationship example, queries in SQL part I (substitute instructor)
    • Sports league in-class example
      • Database for sports league example (with no relationships yet)
    • Plumbing supply store again (if needed)
    • Reading: draft chapter 8 (pages 10-13)
    • Reading: draft chapter 10 (pages 1-11; updated 11/4/2015)
19. Thursday, November 5:  More SQL
    • Database for sports league exercises, including relationships (dates updated to 2015)
    • Database for plumbing supply store exercises, set up to resume where previous class ended
    • Reading: draft chapter 10 (pages 11-17)
    • Homework assignment 8, due November 12
      • Conference.mdb database for third question
20. Monday, November 9:  Query chaining and subqueries in SQL
    • Database for sports league exercises, including relationships (dates updated to 2015)
    • Plumbing supply store problem with price histories
      • Database for in-class exercises
    • Reading: draft chapter 10 (pages 17-25; updated 11/5/2015)
21. Thursday, November 12:  Review for midterm (spent entire class on SQL queries)
    • Additional query exercises for in-class review  
22. Monday, November 16:  Midterm Exam -- all students report to BRR 3087
     
23. Thursday, November 19:  Unary relationships
    • Employees database in-class example
      • "Clean" database (emp-self-clean.accdb) without relationships
      • Database with relationships (emp-self.accdb)
      • Database with completed queries from class (emp-self-sql-queries.accdb)
    • Course catalog in-class example
    • Reading: draft chapter 11
    • Homework assignment 9, due December 3
24. Monday, November 23:  Review results of midterm, start lecture material on business analytics and intelligence
    • Reading: supplementary notes on business analytics and intelligence (same as following class reading)
25. Monday, November 30:  Continue business analytics and intelligence
    • Reading: supplementary notes on business analytics and intelligence
26. Thursday, December 3:  Review of query basics
    • Bookstore database
    • Bookstore database with completed queries
    • Homework assignment 10, due December 11
      • Express package shipment raw data file for Q3
27. Monday, December 7:  Finish review of query basics, lecture on acquisition/SDLC
    • Bookstore database
    • Bookstore database with completed queries
    • Reading: supplementary notes on acquisition/SDLC
28. Thursday, December 10:  Discuss final exam, lecture on security
    • Reading: supplementary notes on security (on the exam, you are responsible only through the "unintentional threats" section, since that's as far as we got in class)
29. Wednesday, December 16:  Final exam in BRR 5101
    • Practice questions and solutions are posted on Sakai
         

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
   • Written portion
   • Access database
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