ProjetoBD --- Database Systems Project

Final practical project developed for the Database Systems ("Bases de Dados") course.

Final Grade: 17/20

This project demonstrates the full workflow of relational database development, including data modelling, schema design, SQL implementation, and querying.

---

Overview

The objective of this project was to design and implement a relational database system capable of storing and managing structured data efficiently.

The work covers the complete database engineering pipeline:

• conceptual modelling
• logical schema design
• relational implementation
• query development

This repository illustrates practical experience with:

• relational database design
• entity--relationship modelling
• SQL data definition and manipulation
• database normalization

---

Repository Structure

ProjetoBD/
│
├── sql/
│   ├── schema.sql        # Database schema creation
│   ├── inserts.sql       # Sample data population
│   └── queries.sql       # Query examples
│
├── diagrams/
│   └── ER_diagram.png    # Entity–Relationship model
│
├── documentation/
│   └── report.pdf        # Project documentation
│
└── README.md

(Folder structure may vary depending on repository contents.)

---

Database Design

The system was designed following the Entity--Relationship (ER) modelling approach, which was later translated into a relational schema.

The design methodology followed these steps:

1. Requirements analysis\
2. ER modelling\
3. Normalization\
4. Relational schema implementation\
5. Query development and validation

The final schema ensures:

• referential integrity
• minimal redundancy
• efficient query execution

---

Setup and Execution

1. Clone the repository

git clone https://github.com/diogocsilva12/ProjetoBD.git
cd ProjetoBD

2. Create the database

Example using MySQL or MariaDB:

CREATE DATABASE projetobd;
USE projetobd;

3. Import the database schema

mysql -u username -p projetobd < sql/schema.sql

4. Populate the database with sample data

mysql -u username -p projetobd < sql/inserts.sql

5. Run example queries

mysql -u username -p projetobd < sql/queries.sql

---

Technologies Used

• SQL
• Relational Databases
• Entity--Relationship Modelling
• Database Normalization

---

Learning Outcomes

This project demonstrates practical competencies in:

• relational schema design
• database normalization
• implementation of integrity constraints
• SQL querying and data manipulation
• structured database project organization

---

Author

Diogo Coelho da Silva Pedro Miguel Ramôa Oliveira

MSc in Advanced Computing
University of Minho

---

Academic Context

Developed as part of the Database Systems ("Bases de Dados") course at the University of Minho.