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)
- It's all over! Please refer to Sakai for your grades
- Grades
for the 10:20am section (look under "GradeBook")
- Grades
for the 12:00pm section (look under "GradeBook")
- MidExam1 is our first midterm score (for your
reference).
- MidExam2 is your second midterm 1 score (for your
reference).
- HwkAvg is your average homework score, counting
missed homework as zero, but dropping the lowest score.
- Absences is your number of recorded absences.
I deducted 0.5% from your course score for each recorded absence beyond
5. Any number below 6/28 means there was no deduction from your
grade.
- Final Exam is your score on the final exam.
Note that I graded the exam out of more than 100 points, and points on
different parts of the exam weighed different amounts. At the end,
I scaled the total score to 100, so you will see some decimal points in
your score.
- Overall Course Score is your overall score in the
course, computed from the preceding five scores according to the
weighting system announced in the syllabus. This score determines
your letter grade.
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.
- Tuesday, January 21. Introduction, class procedures, IT basics
- Friday, January 24. Introduction to relational
database concepts, first introduction to Access, Access tables, and Access
forms
- Tuesday, January 28. More
basic Access objects: reports and queries, plus some a bit more about forms
- Friday, January 31. Memory storage size calculations
- Tuesday, February 4. Finish storage size calculations, introduction
to data management
- Friday, February 7. Relational database theory part
I, ER diagrams, bubble diagrams
- Tuesday, February 11. One-to-many design exercises,
zip codes
- Friday, February
14. Multiple-table databases in
Access, a bit of SQL
- Tuesday, February 18: Designs with multiple paths between tables, multiple tables in
Access II, more on SQL
- Friday, February 21. More access forms,
navigation forms, and subtypes
- Tuesday, February 25. Discuss midterm format, basic background
material on systems, start networks
- Friday, February 28. Practice for midterm (buses problem), more
networks
- Tuesday, March 4. First
midterm exam (BRR room 5071)
- Friday, March 7. Many-to-many relationships, standard retail
database structure
- Tuesday, March 11. Results of first midterm, more design exercises
with many-to-many relationships
- Friday, March 14. Normal forms and normalization
- Tuesday, March 25. Multiple relationships between the same pair of
tables
- Friday, March 28. More multiple relationships, multi-relationships
in Access, queries, and SQL
- Tuesday,
April 1. More queries, including aggregation
- Friday, April 4. More queries, query chaining, and subqueries
- Tuesday, April 8. Business intelligence
- Friday, April 11. Finish business intelligence and related topics,
review for midterm, possibly start acquisition and development
- $
Tuesday, April 15. Second midterm exam
- Friday, April 18. Class cancelled due to very low anticipated
attendance (Good Friday plus many other events)
- Tuesday, April 22. Review exams, development and acquisition
processes
- Friday, April 25. Unary relationships
- Tuesday, April 29. Finish development and acquisition, security
- 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.