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.
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
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.
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.


