🌍 English | 🇵🇹 Português

BSc in Informatics and Computing Engineering
L.EIC012 - Databases
2024/2025

---

Collaborators 🤝

Name	Number
Elton Vaz	up202309925
Henrique Vilarinho	up202307037
Tomás Morais	up202304692

Grade : 15,6

Driving Exam Center SQLite Relational Database Report

To see the full report click here: First Report & Second Report

• UML Diagram
• Relational Schema

UML Diagram

Relational Schema

Escola (IDEscola, Nome, Morada, CodigoPostal, AlvaraDeFuncionamento)

Instrutor(IDInstrutor,Nome,DataDeNascimento,NIF,NumeroCartaoCidadao, CodigoPostal, Morada, LicencaDeInstrucao,IDEscola-->Escola,IDCarta-->CartadeConducao)

Proprietario (IDInstrutor-->Instrutor, IDEscola-->Escola, Proprietario ?)

Veiculo (IDVeiculo, Matricula, Marca, NumeroKmPercorridos,DataDeInspecao, Seguro, IDEscola-->Escola, IDInstrutor-->Instrutor,IDCategoria-->Categoria)

Categoria (IDCategoria, Designacao)

CategoriaCarta (IDCarta-->CartaDeConducao, IDCategoria-->Categoria)

CartaDeConducao (IDCarta, Numero, DataDeEmissao)

Percurso (IDPercurso, Nome, Perimetro, PontoDeTroca)

Examinador(IDExaminador,Nome,DataDeNascimento,NIF,CartaoCidadao,CodigoPostal, Morada, CredencialDeExaminador,IDCarta-->CartaDeConducao)

Examinando (IDExaminando, Nome, DataDeNascimento, NIF,NumeroCartaoCidadao, CodigoPostal, Morada, LicencaDeAprendizagem,IDEscola-->Escola, IDInstrutor-->Instrutor)

Exame (IDExame, Data, Hora, IDExaminando--> Examinando,IDExaminador-->Examinador, IDPercurso-->Percurso)

Aprovacao (IDAprovacao,Duracao, Avaliacao, Ordem, IDExaminando-->Examinando, IDExame-->Exame,IDCarta-->CartaDeConducao)

Reprovacao (IDReprovacao,Duracao, Motivo, Ordem, IDExaminando-->Examinando, IDExame-->Exame)

⚠ Disclaimer:

This project had originally two "create" and two "populate" files, with the difference being that one included the use of generative AI. To simplify, only oe of the versions was included in this repository.