Course Syllabus
Spring, 2006
Instructor: Dr. Julian. M. Scher
Office: Room 4102 GITC (Office Hours will be on Wednesday afternoon, 4:00
- 6:00, and Monday, 4:00-5:00; other times for meeting with Dr. Scher may be
arranged by contacting him through email well in advance of a desired meeting
time)
Phone: (973) 596-3395; ( if urgent, you can also leave a msg. for Dr. Scher at
the CCS Secretary (973)
596-3368 )
E-Mail: CIS431@GMAIL.COM
(Please do NOT send CIS431 email to Dr. Scher's NJIT account!)
Textbook:
D. Kroenke, DATABASE PROCESSING:
FUNDAMENTALS, DESIGN & IMPLEMENTATION, (Tenth Edition), Pearson/Prentice-Hall, 2006.
(Earlier editions of this text will NOT satisfy the course requirements - only
purchase and use the current edition, which has a copyright date of 2006).
ISBN: 0-13-167267-3
Other readings for the Honors Sections may be assigned at the discretion of the instructor.
Prerequisite: CIS114 (or equivalent)
Class Meetings: CIS431H is being taught in Hybrid Learning Mode, which is a combination of regular face-to-face class meetings, combined with computer-based learning (Flash movies and Powerpoint slides) and on-line activities. CIS431H will meet on Wednesday nights, at 6:00PM, for about an hour and a half, and there will be another hour and a half of computer-based learning and on-line activities, as well as Team Investigative Database Projects.
Lecture Notes: Slides covering the lectures will be made available to students.
Course Grade Components:
Midterm Exam (closed book) 33%
Final Exam (open book) 34%
Database Design Projects (Conceptual Assignments, Database Design Application projects, Honors Team Investigations) 33%
Policy on Collaboration/Cheating: Every assignment/project is to be viewed as an exam. The NJIT Honor Code will be upheld. Students found cheating//plagiarizing in any aspect of the coursewill be immediately referred to the Dean of Students and the NJIT Committee on Professional Conduct and subject to possible Disciplinary Probation, a permanent marking on the record, possible dismissal and a grade of 'F' in the course. All submitted assignments and Database Projects are carefully checked for similarities, and plagiarism and guilty students will be identified.
Policy on Lateness of Submission: Every assignment/project will have a due date, and all submissions must be made by this due date in person (email attachments, etc. will not be accepted, unless otherwise stated). NO EXCEPTIONS. Assignments/projects submitted after the due date will not be accepted.
Team Projects: Some projects may be assigned to student "teams" of two students. Team members are expected to have a team spirit and contribute to the success of the team. "Freeloading" on a team will not be tolerated, either by your partner on the team, or by Dr. Scher. As a general rule, the identical grade will be awarded to both members of the team (but, in unusual circumstances, exceptions can and will be made.) Each team project submission must include a "Team Project Management" statement, specifying the overall management of the database project, and identifying "who did what?"
Course Description:
CIS431H is an honors version of our regular course in Database Design, CIS431,
and not only will we cover the topics normally covered in CIS431 (see topical
coverage below), but will expand on this, and there will be several supplemental
Honors Investigative Projects which will delve deeper into the Database Design
course material.
Below are the TOPICs covered in the course, and the related TEXTBOOK readings. Remember one of the keys to success in CIS431H is your own self-discipline - your goal should be to maintain currency each week, and NEVER fall behind! (Note: this is a tentative schedule, and we reserve the privilege to modify and edit these topics for the benefit of the course.)
| CLASS MEETING | TOPIC | TEXTBOOK, PRESENTATION VIDEOS |
|---|---|---|
| 1/18 | Welcome, File Processing, Introduction to Database Concepts | Chapter 1 & Presentation Slides |
| 1/25 | Entity Relationship Data Modeling (Chen E-R model, and Extended E-R model) | Chapter 5, pp. 120-153 & Presentation Slides |
| 2/1 | Relational Database Design With MS Access | Presentation Slides, and Appendix A, pp. 561-574 |
| 2/8 | The Relational Algebra for Query Design, and Querying a Database with GQBE | Presentation Slides |
| 2/15 | Introduction to Structured Query Language (SQL) | Chapter 2, pp. 28-62 & Presentation Slides |
| 2/22 | Semantic Object Data Modeling, and Cool Strategy.com's Table Designer 1.0a | Appendix B, pp. 636 - 661, & Presentation Slides |
| 3/1 | Functional Dependencies and Decompositions | Chapter 3, pp. 70 - 81, Presentation Slides, |
| 3/8 | Midterm Exam | |
| 3/15 | NJIT Spring Recess | |
| 3/22 | Database Normalization (1NF, 2NF, 3NF, BCNF, 4NF) | Chapter 3, pp. 81-95, & Presentation Slides |
| 3/29 | Domain Key Normal Form and Relational Design | Presentation Slides |
| 4/5 | Database Design Using Normalization, & Denormalization | Chapter 4, pp. 102 - 113 & Presentation Slides |
| 4/12 | Database Design, and the Transforming of Data Models into Relational Database Designs | Chapter 6 and Presentation Slides |
| 4/19 |
Chapter 7 and Presentation Slides | |
| 4/26 |
Chapter 7, Presentation Slides | |
| 5/3 | Reading Day (No Class Scheduled) | |
| 5/10 | Comprehensive Final Examination Open Book/Open Notes |
|