---

This course provides students with an introduction to the design of databases and the use of database management systems in support of applications. It covers the entity-relationship (E-R) approach to logical database design. It then covers the relational data model, mapping of E/R designs to relations, relational database design principles, abstract query languages such as the relational algebra and relational calculus, and the industry-standard query language, SQL. It also covers indexing and physical database design. Students will gain exposure to how relational database management systems are used to manage an actual database. Time permitting, the course will also touch briefly on advanced database management topics such as semi-structured data management and/or transactions.

Topics covered include:

• Entity-Relationship (E-R)
• Relational Data Model & Design Principles
• Relational Algebra
• SQL
• Indexing and Physical Database Design
• Transactions

Examples of past Relational Databases built & utilized throughout the course:

• Spotify-like Music Server
• Robot Delivery Service
• Gym membership, appointment, and equipment management system
• COVID-19 vaccination tracker

---