Quick jump links:
Announcements Office Hours
Handouts etc. Homework Solutions
Jonathan Eckstein's Management Information Systems (MIS) Sections
33:136:370:03/04
This page is for my Spring 2016 classes.
Click
here for my Fall 2015 or earlier classes.
Announcements (As of
May 12, 2016 03:45 PM)
- It's all over! Final exam scores and overall scores may be viewed
on Sakai. Please keep in mind
that except in cases of blocked graduation or similar emergency, I do not
discuss grading with students until after a two-week "cooling-off" period
has passed since posting grades. If you send me an e-mail about your
grade, I will not reply until May 26 at the earliest. Graded exams may
be viewed in my office either by appointment during the summer or during
regular office hours next semester.
Usual Office Hour Schedule
My office is 100 Rockafeller Road, room 5145. Regular office hours
were:
- Mondays 2:00-3:30pm, January 25 - April 25
- Extended hours (to be decided, but possibly 2:00-4:30pm) planned for
February 29 and April 11 (before midterms)
- Planned cancellations: March 14 (Spring break)
- Thursdays 2:30-4:30pm, January 24 - April 28
- Planned cancellations: March 3 (after first midterm), March 17
(Spring break), April 14 (after second midterm)
- Additional office hours were held prior to each final exam
- Additional times may be available by appointment; contact me by e-mail for an appointment.
Check the announcements section above for office hour
changes, extensions, additions, and cancellations.
Handouts, Class Materials, and Assignments
Note that all lecture notes, draft chapters, and homework solutions are stored on Sakai and
require a Rutgers NetID login.
- Tuesday, January 19. Introduction, class procedures, IT basics
- Friday, January 22. Some basic elements of relational databases and
MS Access; MS Access tables and forms
- Tuesday, January 26. Reports, introduction to queries, and review of
forms
- Friday, January 29. Introduction to data management, difficulties
with single-table databases
- Tuesday, February 2. Database theory, ER diagrams, dependencies and
dependency diagrams
- Database
theory slides, part I (with
minor corrections to slide 11 made after class)
- Reading:
draft chapter 4 (pages 1-11, plus the section on "Good
Database Design Principles" on page 12, and the section on
"Expanding the Customer Loan Database" on pages 13-15; updates
to the other sections may be made later)
- Friday, February 5. Memory size calculations (substitute instructor)
- Tuesday, February 9. Finish memory size calculations, zip codes,
more database design
- Friday, February 12. Multiple tables in Access, including forms and
queries; queries with aggregation
- Tuesday, February 16. Designs with multiple paths between tables, multiple tables in
Access II, more on queries SQL
- Friday, February 19. More on forms and navigation, subtypes
- Tuesday, February: 23. General lecture on systems, networks, and "the Cloud"
- Friday, February 26. Continue general lecture on networks
-
Tuesday, March 1. Midterm exam in BRR 5117
- Friday, March 4. Many-to-many relationships
- Tuesday, March 8. Review results of first midterm, more many-to-many
relationship examples
- Friday, March 11. Normal forms and normalization
- Tuesday, March 22. Multiple relationships between the same pair of
tables
- Friday, March 25. Basic SQL part I
-
Tuesday, March 29. Basic SQL part II
- Friday, April 1. Basic SQL part III
- Tuesday, April 5. Basic SQL part IV
- Friday, April 8. Review for midterm, multi-relationships in Access
-
Tuesday, April 12. Midterm exam in BRR 5117
- Friday, April 15. Unary relationships (and possibly outer joins)
-
Tuesday, April 19. Review midterm, combining
outer joins and aggregation
-
Friday, April 22. More unary-relationship
queries, query chaining
- Tuesday, April 26.
Discuss format of final exam, acquisition and development (lecture)
- Friday, April 28.
Review for final exam
-
Thursday, May 5, 12pm, room 5117 -- final exam for
section 04 (TF noon section)
Wednesday, May 11, 8am, room 5117 -- final exam for
section 03 (TF morning section)
Homework Solutions
All homework solutions are on Sakai and
require a Rutgers NetID login and a PDF reader.
- Solution
to homework assignment 1 and finished histbooks.accdb
database
- Solution
to homework assignment 2
- Solution
to homework assignment 3 (with corrections uploaded 1pm February 18)
- Solution
to homework assignment 4
- Solution to homework assignment 5
- Solution
to homework assignment 6
- Solution
to homework assignment 7
- Solution
to homework assignment 8
- Solution
to homework assignment 9
- Solution
to homework assignment 10 (cut-and-paste error corrected 2pm 4/26/2016)
- Solution
to homework assignment 11