Description

Theory
1

Theory/Practice
1

Laboratory
2

Instructors

Angelo Martins

Contents

1. General Database Concepts
1.1. Data and Information Systems
1.2. Technologies and Applications
1.3. Database Management Systems

2. Data Modeling
2.1. Data modeling process
2.2. Relational Data Model
2.3. Functional dependencies and normalization
2.4. Data integrity

3. Definition and manipulation of data
3.1. Structured Query Language (SQL)
3.2. DDL - Data Definition Language
3.3. DML - Data Manipulation Language
3.4. DCL - Data Control Language

4. Constituent objects and Oracle database programming
4.1. Structural: table, index, sequence, view
4.2. Behavioral: trigger, stored procedure, function
4.3. Oracle Data Dictionary
4.4 Unit testing of stored procedures and functions

5. Transactions
5.1. Database transaction concept and desirable properties
5.2. Concurrent access to data

Learning Outcomes

The student, in a team, should be able to develop a project of a relational database, from analysis and modeling to implementation, using a commercially available DBMS.

CO1. Discuss the different database (DB) technologies and their applicability
CO2. Design a relational BD following a systematic process
CO3. Apply SQL to create and manage a DB, develop and modify scripts
CO4. Build, modify and explain queries for querying a DB
C05. Develop and test functions, procedures and triggers to interact with the DBMS, including unit testing of functions and procedures
CO6. Explain the rationality of transactional processes and describe related concepts
CO7. Create an integrated DB in a team project based on functional requirements and constraints