Databases

Recommended Prerequisites

Computer Programming and Data Structures and Algorithms. 

Teaching Methods

Theoretical classes with detailed presentation, using audiovisual means, of the concepts, principles and fundamental theories and solving of basic practical exercises to illustrate the practical interest of the subject and exemplify its application to real cases. Laboratory classes where practical aspects of database design will be addressed, allowing the student to consolidate the theoretical background involved on a typical database design project. Two assignments will be proposed covering all stages of database design.

Learning Outcomes

This curricular unit main goal is to provide students with important theoretical knowledge fundamental for the project of a database system. After attending this course, the student should understand the background theory behind a database project, namely requirement analysis, data analysis and modeling and data manipulation using an appropriate query language like SQL.

After attending this course, the student should be able to develop an application that integrates a database, taking into account all the methodologies learned.

Special care will be put in the practical component of the course. The student will be introduced to a set of tools typically used on a database project.

Work Placement(s)

No

Syllabus

Introduction  to Database Management Systems;

Conceptual data models: ER model;

The relational model;

Normalization theory;

Relational algebra;

SQL Query Language;

Development of Database applications;

Integrity and Security in a DBMS;

PL/SQL, NoSQL engine.

Head Lecturer(s)

Catarina Helena Branco Simões da Silva

Assessment Methods

Assessment
Project: 20.0%
Frequency: 80.0%

Bibliography

- Ramez Elmasri e Shamkant B. Navathe (2015), Fundamentals of Database Systems (7th Edition), Addison-Wesley Publishing

- Raghu Ramakrishnan e Johannes Gehrke (2003) Database Management Systems (3rd Edition), McGraw-Hill

- Pedro Furtado (2018) – Diapositivos das aulas teóricas de Bases de Dados, DEI-FCTUC.

- Pedro Furtado (2018) – Folhas Laboratoriais de Bases de Dados, DEI-FCTUC.