Databases (BD) - NOVA FCT 🗄️

Bachelor in Computer Science and Engineering (LEI) | 2nd Year - 2nd Semester

This repository contains the database project developed for the Databases (Bases de Dados) course at the Faculty of Sciences and Technology of the NOVA University of Lisbon (NOVA FCT).

✍️ Authors

• Tomás Alves (Student No. 68681)
• Miguel Carmo (Student No. 65871)
• Felipe Magno (Student No. 67994)

📌 About the Course and Project

The Database course focuses on the design, implementation, and management of relational databases. It covers the Entity-Relationship (ER) model, relational algebra, SQL, normalization, and the development of web-based database applications.

Project: Formula 1 Database Management System 🏎️

The goal of this project was to build a complete database system from scratch to manage data related to a Formula 1 season. The project was developed using Oracle 18c and the interface was built using Oracle APEX.

• Documentation: Projectl (PDF)

The repository is structured around the different phases of the project's lifecycle:

1. Initial Proposal

• Description: The initial pitch for the database domain, outlining the scope of tracking F1 teams, drivers, cars, circuits, races, and sponsorships.
• Documentation: Initial Proposal (PDF)

2. Phase 1: Conceptual and Logical Design

• Description: Development of the Entity-Relationship (ER) model and its translation into the Relational Model. This phase includes the definition of strong and weak entities, ISA relationships, and aggregations.
• Documentation: Phase 1 Report (PDF)

3. Phase 2: Physical Implementation & APEX Interface

• Description: The final implementation phase. It involved writing the SQL scripts for table creation, constraints, advanced PL/SQL triggers, procedures, and views. Finally, a web interface was built using Oracle APEX to allow users to interact with the database dynamically.
• Documentation & Code:
  • Final Documentation & User Manual (PDF)
  • Database Creation Script (SQL)
  • Oracle APEX Application Export (SQL)

🧠 Concepts and Acquired Skills

• Database Modeling: Creating complex ER diagrams and mapping them to relational schemas.
• SQL & PL/SQL Programming: Writing advanced queries, creating views, and developing triggers/procedures for data validation and automation.
• Integrity & Normalization: Ensuring data consistency through primary/foreign keys and functional dependencies analysis.
• Web Application Development: Using Oracle APEX to build interactive dashboards, forms, and reports directly linked to the underlying database.

📄 License

Copyright © 2026 Alvesss04. All Rights Reserved.