Database Systems (INF-239)

University: Universidad Técnica Federico Santa María (UTFSM)
Program: Civil Engineering in Informatics
Course: Bases de Datos (INF-239) [1° Semester/2025]

📄 Overview

This repository contains laboratory assignments, projects, and coursework developed for the
Database Systems course. The objective of this coursework was to design, build, and manage databases to
solve real-world information management problems.

The projects focus on the conceptual modeling of data, logical and physical design of relational databases,
and the implementation of robust software solutions.

🛠 Tech Stack

The solutions implemented in this repository utilize a modern stack for database management,
containerization, and backend integration:

• Relational DBMS: SQL Server, MySQL.
• NoSQL: MongoDB, PyMongo.
• Backend & Scripting: Python, PHP.
• Infrastructure & Tools: Docker, Docker Compose, Apache2, XAMPP, PHPMyAdmin, Jupyter Notebooks.

📚 Key Competencies & Learning Outcomes

According to the course syllabus, the work in this repository demonstrates the following competencies:

• Data Modeling: Designing data models for diverse systems using standard notations like UML and
  Entity-Relationship (ER) diagrams.
• Database Architecture: Designing and building databases using specialized industry software.
• Query Optimization: Utilizing SQL and Relational Algebra for complex queries and transaction
  processing.
• System Integration: Developing applications that interact with databases to solve specific business
  problems.
• NoSQL Implementation: Extending traditional relational concepts to document-oriented databases using
  MongoDB.