2018/2019 - 2rd Year, 2nd Semester
Course: Bases de Dados (BDAD) | Databases
Authors: Bernardo Santos (bernas670) , David Silva (daviddias99) and Luís Cunha (luispcunha)
Description: For the database course we were challenged with creating a database for a proposed context. We decided on creating a database for a Movie/TV Show database similar do IMDB. The work was split into three checkpoints:
- Checkpoint 1: Conceptual model
- Checkpoint 2: Relacional schema, functional dependency analysis, db creation in SQL, constraint adding in SQL and populating database
- Checkpoint 3: SQL querries and triggers
Between checkpoints we were given feedback and we were allowed to improve for next checkpoints.
For a more detailed description of the deliveries please read the checkpointX/EX-Relatório-T3g01.pdf files (in portuguese).
Technologies: SQL, SQLite3, UML
Skills: Relational database design, SQL database creation, SQL queries, triggers
Grade:
- Delivery 1: 16.1/20
- Delivery 2: 19.3/20
- Delivery 3: 17.4/20
- Final: 17.6/20