Back to Modules

CS130

DATABASES

Credits
5
Year
2
Semester
1
Department
COMPUTER SCIENCE

Overview

Conceptual data modelling; relational database model; data structures; Structured Query Language (SQL); data integrity; data manipulation; relational algebra; techniques for data analytics and data science; basic transaction processing; database security; alternative database models.

Learning Outcomes

  • Identify major Database Management Systems (DBMS) functions and describe their role in a database system
  • Design a relational schema from a conceptual model developed using the entity-relationship model
  • Demonstrate the creation of databases from external data sources such as files
  • Explain and demonstrate the concepts of entity integrity constraints and referential integrity constraints
  • Demonstrate queries in relational algebra
  • Use a declarative query language (SQL) to extract information from a database
  • Demonstrate use of SQL to work with many different data types (strings, timestamps, numerical, etc) in large databases
  • Explain the concepts of database security in the context of web-based database applications