Database systems are central to most organizations’ operations. At any organizational level, users can expect to have frequent interaction with databases, and to use then to prepare useful analytics. Therefore, understanding capabilities and limitations of databases, knowing how to access data, knowing how to effectively use the information stored in such database systems, and skills in designing database systems is a distinct advantage and necessity today. The Relational Database Management System (RDBMS) is the dominant type of database systems and is the primary focus of this course.
This core course will cover topics such as: the relational data model (data structure, data integrity, and data manipulation), entity-relationship modelling, normalization, as well as the structured query language (for creating data structures and constraints, for managing tables’ content, and for creating variety of queries that address business scenarios).
Further, to provide students with opportunity to apply the knowledge learnt from lectures, various homework assignments, SQL assignments, and a database implementation project will be given.
- Gain an understanding of relational data models in terms of data structure, data integrity, and data manipulation.
- Understand and create conceptual database models utilizing entity-relationship modeling.
- Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology.
- Understand the theory behind the relational data model as it applies to interactions with current database management systems
- Read and interpret a given data model to query the database and transform the data into information using Structured Query Language (SQL).
- Implement a data model in a current relational database management system.
- Create SQL queries, based on transactional data, including elements such as data groupings and summary values.
There are no pre-requisites for this class.