May 18, 2021
CS 331 - Database Systems
The course covers the fundamental concepts of database systems. It teaches students the internals of database systems including data model, database design, relational model, relational algebra, SQL, indexing, concurrency control, query processing, transaction management and recovery. This course also aims to teach the new directions involving NoSQL persistence models.
Prerequisite(s): CS 211 and admission to BC CS program, or instructor’s permission.
- Explain the components of a database system
- Develop an entity-relationship (ER) model based on user requirements
- Use the Structured Query Language (SQL) for database definition and manipulation
- Generate an index file for a collection of resources
- Convert an entity-relationship diagram to a set of normalized relations
- Explain the ACID properties of a transaction
- Describe techniques that are used for recovery
- Design and implement a relational database system
- Distinguish the differences and similarities between NoSQL databases and relational databases
Find out when this course is offered
Add to Favorites (opens a new window)