Databases

Learning Outcomes:

  • Understanding the logistics, overview, examples, and history of databases
  • Learning ER modelling and ER design
  • Understanding the relational model and translation of ER-diagrams to relational model
  • Learning relational algebra, select, project, and queries
  • Understanding the basics of SQL
  • Learning intermediate SQL
  • Understanding JDBC
  • Learning normalisation theory

Skills for module:

Relational Databases (SQL)

Normalisation

Indexing

PostgreSQL

Java

Database Management Systems

Problem Solving

Critical Thinking

Time Management

Databases

Databases

CS2855

Learning Outcomes

  • Understanding the logistics, overview, examples, and history of databases
  • Learning ER modelling and ER design
  • Understanding the relational model and translation of ER-diagrams to relational model
  • Learning relational algebra, select, project, and queries
  • Understanding the basics of SQL
  • Learning intermediate SQL
  • Understanding JDBC
  • Learning normalisation theory