Course Notes: CSCI 273
Table of Contents
| Topic | Beginning Page in Notes | Text Chapter |
| Use Cases | 1 | N/A |
| Sequence Diagrams/ Event Traces |
17 | N/A |
| Overview of Databases/ Database Users |
19 | 1 |
| DBMS Concepts/ Architecture |
29 | 1 |
| Entity-Relationship Modeling | 43 | 2 |
| ER to Relational Mapping | 59 | 3 |
| Relational Model and Algebra | 74 | 3 |
| SQL | 90 | 4 |
| QBE | 128 | 5 |
| Data Normalization | 133 | 7 |
| Transactions | N/A | 13 |
| Concurrency Control | N/A | 14 |
| Recovery | N/A | 15 |
| Appendix A - OO Modeling Basics | 145 | |
| Appendix B - Rational Rose Demo Walkthrough | 169 | |
| Appendix C - Wally's Warehouse Design E.g. | 178 | |
| Appendix D - The Dynamic Model in OOAD | 210 | |
| Appendix E - Student E.g. OOAD Project, Personal Finance Manager | 232 | |
| Appendix F - Role of OODBs | 260 | |
| Appendix G - Sample HW/Exams | 279 |