Skip to content

Latest commit

 

History

History
36 lines (29 loc) · 1.06 KB

README.md

File metadata and controls

36 lines (29 loc) · 1.06 KB
Raw

BD_T07_G06 - Online Clothing Store

2021/2022 - 2nd Year, 1st Semester

Course - BD (Base de Dados | Databases)

Project developed by

  • Ana Rita Carneiro (up202008569)
  • Milena Gouveia (up202008862)
  • Sofia Moura (up201907201)

Project Description

The goal of this project was to create and query a database for an online clothing store. The project was divided into three parts:

Part 1:

  • Conceptual Model Definition

Part 2:

  • Relational Schema Definition
  • Functional Dependencies Analysis and Normal Forms
  • Database Creation in SQLite
  • Adding Constraints to the Database
  • Data Loading

Part 3:

  • Database querying
  • Adding Triggers to the Database

Project Structure

  • criar.sql - SQL statements for creating all the database tables
  • povoar.sql - SQL statements for populating the tables created
  • queries/ - files with SQL statements for querying the database
  • triggers/ - files with SQL statements for creating, removing and testing triggers
  • report.pdf - project report (pt)