This course has CIS 280 (Software Design) as a prerequisite which in turn has prerequisites of CIS 181 and CIS 180. It is required that students enrolling in CIS 452 be proficient in the object-oriented paradigm and in Java programming. It is also required that students be familiar with software analysis and design techniques including use case modeling and data modeling with UML class diagrams.
Use of DBMS software in the development of an information system. Overview of the ANSI/SPARC Study Group on Database Management Systems model. Relational database model techniques. Emphasis on user views necessary to support data management and retrieval.
| Week Of | Topics | Reading | Notes |
|---|---|---|---|
| Jan 26 | History and Future of Database/IT Systems Architecture of DBMS Systems |
Ch 1 Appendix A |
|
| Feb 2 | The E/R Approach to Data Modeling | Ch 2, 3.1 | |
| Feb 9 | The Relational Data Model Relational Algebra |
Ch. 4.1, 4.2, 6.1 | |
| Feb 16 | From E/R to Relational Introduction to SQL Introduction to JDBC |
Ch. 4.3, 7, 8, 10 | Monday holiday (Presidents' Day). Monday's class on Tuesday. No Tuesday classes. |
| Feb 23 | Introduction to Client/Server Programming for the Web Applications, Applets, and Servlets Multi-tier Client/Server Architectures |
TBA | |
| Mar 2 | Introduction to HTML Servlet Details and HTML Forms |
Ch. 9 | |
| Mar 9 | Java Server Pages (JSP) Midterm Exam (Friday) |
TBA | |
| Mar 16 | Spring Vacation, No Classes | - | |
| Mar 23 | SQL | Ch. 7 | |
| Mar 30 | SQL | Ch. 7 | |
| Apr 6 | Javascript Style Sheets |
Ch. 16.1 | |
| Apr 13 | Other Technologies: CORBA, RMI, Beans, EJB's, XML, etc. | TBA | |
| Apr 20 | Functional Dependencies and Normalization | Ch. 5 | Monday holiday (Patriots' Day). No Monday classes. |
| Apr 27 | Object-Oriented Databases Data Modeling with ODL |
Ch. 3.2, 3.3, 17 | |
| May 4 | Project Demonstrations | ||
| May 11 | Project Demonstrations | Last class on Monday. No Wednesday or Friday class. | |
| Final Exam Wednesday, May 20, 8:00 - 11:00am |