Course Syllabus

Course Description

This course aims to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems.

Course Objectives

The objective of this course is to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems.

Key Concepts

1. Understanding the Relational DB model
2. Understanding Entity-Relationship Diagrams and Relational Schemas
3. Mapping out an ER model out of a prompt.
4. Mastery of SQL.
5. Understanding of analytical databases (data warehouses) and building of the star schema.

Learning Outcomes

1. Learn the concepts of Relational Database Systems
2. Analyze database requirements and develop logically the design of database
3. Model a database through ER Modeling
4. Implement a database through DDL instruction (sql)
5. Interact with the database through DML instruction (queries)
6. Evaluate and normalize a database
7. Make use of assertions, views, procedures and functions

Recommended Textbooks

Database Systems: Introduction to Databases and Data Warehouses Edition 2.0 By Nenad Jukić, Susan Vrbsky, Svetlozar Nestorov, and Abhishek Sharma