/final-task-database-subject

Here in this repository is the final task referring to the subject of "Projeto e implementação de banco de dados".

FINAL TASK DATABASE SUBJECT

📙 About

Academic work developed in the subject of Projeto e Implementação de Banco de Dados in the course of Tecnologia em Analise e Desenvolvimento de Sistemas in Instituto Federal do Paraná using SQL, MySQL and MySQL Workbench.

College: Instituto Federal do Paraná - campus Londrina
Course: Tecnologia em Analise e Desenvolvimento de Sistemas
Subject: Database design and implementation
Professor: Luciana Pöttker

📙 Task Description

  1. Propose a database, with at least 6 tables/entities, about the theme that each of you find most interesting. Creativity will be evaluated.

  2. What must be delivered:
    2.1) the file with the DER
    2.2) the script with:
    2.2.1) DDL commands for building the database/tables;
    2.2.2) DML commands for inserting at least 10 records into each of the tables;
    2.2.3) DML commands to implement 15 queries to the database data with the respective statements.

  3. Final Delivery Date: 12/05/2021 - through the classroom