CIS 431- Honors
  Database System Design and Management 

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:

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:

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 Advanced SQL Design, Triggers and Oracle

Chapter 7 and Presentation Slides

4/26 Advanced SQL Design, Triggers and Oracle (Continued)

Chapter 7,  Presentation Slides

5/3 Reading Day (No Class Scheduled)  
5/10 Comprehensive Final Examination  Open Book/Open Notes