European Union Portugal 2020 - Agriculture and Rural Development Foundation for Science and Technology European University Foundation
Suggestions, Compliments, Complaints Terms & Conditions of Use Projects Co-financed by the European Union
©2026 Universidade Politécnica de Coimbra. Todos os direitos reservados.

Search

Bases de Dados I

Home / Oferta Formativa / Coimbra Institute of Engineering / CTeSP / Higher Technical Course in Technologies and Programming of…

Base Knowledge

Basic knowledge of computer science and programming logic, as well as familiarity with basic concepts of mathematics.

Teaching Methodologies

Theoretical Classes: Presentation of content using slides and practical examples, complemented with case study discussions and exercise resolution.

Practical Classes: Application of concepts through exercises and development of a practical project, using Oracle SQL Developer and Oracle Data Modeler.

Learning Results

The Base de Dados I course aims to teach the fundamental concepts of database management systems (DBMS) and relational databases, enabling students to specify, model, and query databases using SQL, promoting understanding of normalization techniques, data integrity, and conceptual modeling.

Skills include identifying normalization concepts (1NF, 2NF, 3NF, BCNF), understanding the relational model and DBMS architecture, and applying knowledge through SQL code development and database modeling using the Entity/Relationship (ER) model, being that students will also justify modeling and normalization decisions, prepare technical documentation, and present database projects clearly and critically.

Program

  1. Introduction to Databases: Definition of DBMS and databases. DBMS architecture: external, conceptual, and internal levels.
  2. Relational Databases: Relational model, tables, domains, and relationships. Data integrity: primary keys, foreign keys, and nulls.
  3. SQL Language: Basics (SELECT, INSERT, UPDATE, DELETE). Joins, functions, subqueries, and set operations.
  4. Entity/Relationship Model: Entities, relationships, cardinality, and ER diagrams.
  5. Normalization: Functional dependencies and normal forms (1NF, 2NF, 3NF, BCNF).
  6. Advanced Topics: Transactions, concurrency, and data recovery. Types of databases: SQL, NoSQL, and current trends.

Grading Methods

Regarding the evaluation, this will be continuous, comprising the carrying out of:

  • Theoretical Tests: 2 written tests, each worth 6 points (total: 12 points).

  • Practical Project: Development of a functional database, including ER diagram, SQL scripts, and descriptive report, followed by an oral defense (8 points).

    Internship(s)

    NAO

    Bibliography

    Damas, L. (2013). SQL (14th ed.). FCA.

    Date, C. (2003). An Introduction to Database Systems (8th ed.). Pearson.

    Elmasri, R., & Navathe, S. (2015). Fundamentals of Database Systems (7th ed.). Pearson.

    Connolly, T., & Begg, C. (2014). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson.

    Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill.