ICS 311 Database Management Systems
Covers concepts and methods in the definition, creation and management of relational databases. Emphasis is placed on usage of appropriate methods and tools to design and implement relational databases to meet identified business needs. Topics include conceptual database design, use of Entity Relationship Diagrams, query tools and SQL; database integrity, security and privacy; query optimization; transaction management, concurrency control, and recovery; and emerging data management trends. Use of database management systems such as MySQL.
First day attendance is mandatory.
Overlap: ICS 311T Database Management Systems. Note: Students are responsible to both be aware of and abide by prerequisites for ICS courses for which they enroll, and will be administratively dropped from a course if they have not met prerequisites.
Prerequisites
Special information
Overlap: ICS 311T Database Management Systems. Note: Students are responsible to both be aware of and abide by prerequisites for ICS courses for which they enroll, and will be administratively dropped from a course if they have not met prerequisites.
4 Undergraduate credits
Effective January 1, 2003 to present
Learning outcomes
General
- Explain the components and the defining characteristics behind the relational data model.
- Examine requirements and produce Entity Relationship Diagrams based on requirements.
- Construct SQL queries that incorporate select, project, join, union, intersection, set difference, insert, update, and delete.
- Produce correct database schemas by applying normalization theory.
- Relate database query language constructs to relational algebra operators.
- Explain transaction management, concurrency control, and recovery.
- Identify the purpose and organization of indexes like B+ tree and hash index.
- Explain query optimization alternatives.
- Develop applications to programmatically access databases.
Spring 2025
| Section | Title | Instructor | books | eservices |
|---|---|---|---|---|
| 50 | Database Management Systems | Goyal, Rajeev | Books for ICS-311-50 Spring 2025 | Course details for ICS-311-50 Spring 2025 |
| 51 | Database Management Systems | Mekonnen, Tsion Fekadu | Books for ICS-311-51 Spring 2025 | Course details for ICS-311-51 Spring 2025 |
| 52 | Database Management Systems | Raghe, Mohamed Abdi | Books for ICS-311-52 Spring 2025 | Course details for ICS-311-52 Spring 2025 |
| 53 | Database Management Systems | Mekonnen, Tsion Fekadu | Books for ICS-311-53 Spring 2025 | Course details for ICS-311-53 Spring 2025 |
Summer 2025
| Section | Title | Instructor | books | eservices |
|---|---|---|---|---|
| 01 | Database Management Systems | Vue, Kenji M | Books for ICS-311-01 Summer 2025 | Course details for ICS-311-01 Summer 2025 |
| 51 | Database Management Systems | Mekonnen, Tsion Fekadu | Books for ICS-311-51 Summer 2025 | Course details for ICS-311-51 Summer 2025 |
| 52 | Database Management Systems | Raghe, Mohamed Abdi | Books for ICS-311-52 Summer 2025 | Course details for ICS-311-52 Summer 2025 |
Fall 2025
| Section | Title | Instructor | books | eservices |
|---|---|---|---|---|
| 01 | Database Management Systems | Raghe, Mohamed Abdi | Books for ICS-311-01 Fall 2025 | Course details for ICS-311-01 Fall 2025 |
| 50 | Database Management Systems | Mekonnen, Tsion Fekadu | Books for ICS-311-50 Fall 2025 | Course details for ICS-311-50 Fall 2025 |
| 51 | Database Management Systems | Li, Ji | Books for ICS-311-51 Fall 2025 | Course details for ICS-311-51 Fall 2025 |
| 52 | Database Management Systems | Mekonnen, Tsion Fekadu | Books for ICS-311-52 Fall 2025 | Course details for ICS-311-52 Fall 2025 |
| 53 | Database Management Systems | Das, Sudeep | Books for ICS-311-53 Fall 2025 | Course details for ICS-311-53 Fall 2025 |