Subject: Database Management Systems

Scientific area:

Computer Science

Contact hours:

64 Hours

Number of ECTS:

6 ECTS

Language:

Portuguese

General Objectives:

1 - Recognize the need/functionality of database management systems.
2 - Know concepts regarding the structures of databases.
3 - Identify the models used in database management.
4 - Know data modeling techniques and their basic concepts.
5 - Implement systems and applications with databases and associated technologies.

Contents / Syllabus:

1 - Introduction to DBMS
2 - Entity-Association Model
3 - Relational Model - Structure of Databases
4 - Model and Relational Algebra
5 - Structured Query Language (SQL)
6 - Normalization
7 - Files and Indexing
8 - Transactions
9 - Applications development

Bibliography / Information Sources:

A. Silberschatz, H. Korth, S. Sudarshan , 2005 , Database System Concepts (5ª ed.) , McGraw-Hill Education

Assessment Methods and Criteria:

Classification Type: Quantitativa (0-20)

Evaluation Methodology:
This course combines theoretical and laboratory classes, using the presentation of fundamental concepts and the performance of practical exercises in database modeling and implementation. Activities include the creation of data models, development of SQL queries, standardization, and deployment of applications with database access. Assessment integrates a practical project (50%), focused on the development of a database, and a written exam (50%), designed to evaluate the understanding of the concepts and techniques covered.