Databases

About this course

This Databases (BDDAD) course unit addresses Database Systems suited to the needs and objectives of organizations; it focuses on modeling, creating and exploring relational databases via SQL.
It implements an international collaborative teaching model, integrating its counterparts at the Polytechnic University of Porto (Portugal), Hellenic Mediterranean University (Greece), University of Maribor (Slovenia) and University of Siegen (Germany). Direct international contact between students and teachers is promoted through joint activities carried out in hybrid mobility mode. It is expected that students become able to develop a project, from analysis and modeling to implementation, using a relational database over a commercially available database management system.

Expected learning outcomes

LO 1 – Distinguish between different database technologies and their applicability

LO 2 – Design relational data models following a systematic process

LO 3 – Apply SQL to create and manage a data schema, develop new scripts from scratch and modify existing scripts

LO 4 – Build, modify and explain SELECT queries for querying a relational database

LO 5 – Program functions, procedures and triggers to interact with the DBMS

LO 6 – Explain the rationality of database transactions, describe related concepts, design and implement database transactions

LO 7 – Create an integrated database application in a team project to satisfy certain functional requirements and constraints

Indicative Syllabus

Course content (title per week)

Database Concepts; data and information systems; db technology and applications; DBMS

Data Modeling; data model design procedure; relational data model introduction

Functional dependencies and normalization

Structured Query Language (SQL). DDL, DML, DCL. Data Definiton Language (DDL): CREATE, ALTER, DROP statements.

Ddta Manipulation Language (DML). INSERT, UPDATE, DELETE, SELECT statements.

SELECT queries.

Database transactions. Concurrent data access.

Oracle PL/SQL. Stored procedures. Functions.

Oracle PL/SQL. Triggers

Multidimensional databases: star model, snowflake model. OLAP versus OLTP.

Case study A

Case study B

Oracle PL&SQL programming

Oracle PL&SQL programming

Oracle PL&SQL programming

Assessment

Teaching / Learning Methodology

Learning Materials: Application exercises, Discussions/Debates, Lab tools, Lessons presentations, Moodle, Videoconference