🗄️ SIBD – Information Systems and Databases

This repository contains my work for the course Information Systems and Databases (SIBD), part of the Bachelor's degree in Computer Engineering. It includes exercises, exams, and a full project developed in four stages. The course covered relational database concepts, SQL, data modeling, normalization, and information systems fundamentals.

---

📚 Course Contents

• 📈 Entity-Relationship (ER) modeling
• 🧩 Relational model and schema design
• 🔄 Normalization (1NF, 2NF, 3NF)
• 🔍 SQL (queries, DDL, DML)
• ⚙️ Relational algebra
• 🧠 Conceptual vs Logical vs Physical models
• 💡 Fundamentals of Information Systems

---

📁 Repository Structure

SIBD/
├── exams/                   # Old exams and preparation materials
│   ├── 2022_exam.pdf
│   ├── 2023_exam.sql
│   └── ...
│
├── project/                 # Main course project divided in 4 phases
│   ├── phase1/              # Conceptual model and requirements
│   ├── phase2/              # Relational schema + constraints
│   ├── phase3/              # SQL queries and views
│   └── phase4/              # Final report and optimization
│
├── extras/                 # Additional exercises and practice sets
│   ├── normalization.sql
│   ├── relational_algebra.pdf
│   └── ...
│
└── README.md               # Repository documentation

---

✨ Highlights

• Complete ER-to-Relational workflow
• SQL queries designed for real-world scenarios
• Focus on data consistency, normalization, and optimization
• Structured learning with incremental project development

---

🚀 Tools Used

• PostgreSQL / MySQL
• DBMS (pgAdmin, DBeaver)
• SQL
• UML tools for modeling (draw.io, Lucidchart)

---

✨ Acknowledgments

This work was developed as part of the SIBD course at FCUL. Special thanks to the professors and classmates for the insightful discussions and guidance.

---

📄 License

This repository is for educational purposes only.