Description: Design and implementation of database systems. Semantic modeling, relational database theory, including normalization, indexing and query construction, SQL.
Textbook:
Fundamentals of Database Systems (2004)
Elmasri, R. & Navathe, S.
Concepts:
- Simple Entity Relationship Model
- Relational Data Model
- Mapping from Simple ER constructs to the Relational Model
- Enhanced Entity Relationships
- Mapping Enhanced ER Constructs to the Relational Model
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Advanced SQL
- Relational Algebra
- Relational Algebra & SQL
- General Good Database Design
- Functional Dependencies
- Normal Forms
- Data Mining