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.
The course covers the following topics:
-
Relational Algebra
- Basic operations (selection, projection, join, etc.)
- Relational calculus
-
Database System Architecture
- Components of a database system
- Client-server architecture
-
Data Models
- Relational model
- Entity-Relationship model (ER)
-
Conceptual Database Design
- Entity-Relationship Diagram (ERD)
-
Logical Database Design
- Database normalization
- SQL (Structured Query Language)
-
Formal Database Languages
- Query languages (SQL, QBE)
- Data definition languages (DDL)
The following assignments were developed as part of this course:
-
Assignment 1: Hotel Management
-
Assignment 2: Simple Application