DB-Final-Project

Final project for the Databases course

We had to create a system that would use around 15 to 20 tables.

It was decided to create a movie rental service with clients, workers, movies, actors and directors.

Each movie has a limited amount of copies. There are also payments and late fees.

Files:

• BaseDeDados.sql: SQL code with tables, sequences, views, triggers, functions and initial data.
• ER.png: Entity Relatioship diagram.
• bd.png: Relational Schema.
• Interface.sql: Interface made in Oracle APEX.
• Relatório Final_Grupo 12.pdf: Final report written in portuguese.

Final grade: 18/20