Data Base

This repository contains materials and projects developed during the Data Base course, offered by the Federal University of Alfenas. Credits to professor Mariane Moreira for the provided materials.

💻 Contents

The course covers the following topics:

1. Relational Algebra

   • Basic operations (selection, projection, join, etc.)
   • Relational calculus

2. Database System Architecture

   • Components of a database system
   • Client-server architecture

3. Data Models

   • Relational model
   • Entity-Relationship model (ER)

4. Conceptual Database Design

   • Entity-Relationship Diagram (ERD)

5. Logical Database Design

   • Database normalization
   • SQL (Structured Query Language)

6. Formal Database Languages

   • Query languages (SQL, QBE)
   • Data definition languages (DDL)

📁 Developed Assignments

The following assignments were developed as part of this course:

1. Assignment 1: Hotel Management

   • Assignment 1

2. Assignment 2: Simple Application

   • Assignment 2