DATABASE MANAGEMENT SYSTEMS: DESIGN AND IMPLEMENTATION
What a database management system is; different data models currently used to structure the logical view of the database: relational, hierarchical, and network. Hands-on experience with relational and network-based database systems. Implementation techniques for database systems. File organization, query processing, concurrency control, rollback and recovery, integrity and consistency, and view implementation.
Prerequisites & course information
Requisites: E C E/COMP SCI 354 and (COMP SCI 367 or 400 ) or graduate/professional standing or declared in the Capstone Certificate in Computer Sciences for Professionals Course Designation: Core GenEd - Natural Science & Wellness Breadth - Physical Science Level - Intermediate L&S Credit - L&S Liberal Arts and Science Repeatable for Credit: No Last Taught: Fall 2026 Learning Outcomes: 1. Articulate and apply the foundations of relational database management systems (RDBMS). Audience: Undergraduate 2. Explain the concepts of data models, including the Entity-Relationship (ER) and Relational models, express application in these models, and translate between models Audience: Undergraduate 3. Use SQL to express complex queries over a relational database. Audience: Undergraduate 4. Describe how an RDBMS stores, indexes, and accesses data. Audience: Undergraduate 5. Explain how an RDBMS optimizes query execution and efficiently implements various operators. Audience: Undergraduate 6. Explain the motivations for transactions, concurrency control, and crash recovery. Audience: Undergraduate 7. Modify and extend the functionality of RDBMS. Audience: Undergraduate Learning Outcomes: 1. Articulate and apply the foundations of relational database management systems (RDBMS). Audience: Undergraduate 2. Explain the concepts of data models, including the Entity-Relationship (ER) and Relational models, express application in these models, and translate between models Audience: Undergraduate 3. Use SQL to express complex queries over a relational database. Audience: Undergraduate 4. Describe how an RDBMS stores, indexes, and accesses data. Audience: Undergraduate 5. Explain how an RDBMS optimizes query execution and efficiently implements various operators. Audience: Undergraduate 6. Explain the motivations for transactions, concurrency control, and crash recovery. Audience: Undergraduate 7. Modify and extend the functionality of RDBMS. Audience: Undergraduate
Sources
- Course catalogue ↗2026-2027