Projeto de Banco de Dados - 23.1

This is a full database project, starting from conceptual and going all over to the physical implementation in Oracle, passing throught the logical phase. Its related to an Veterinary Clinic system.

By: Lucas Florêncio, Luiz Roberto

Physical Project (Oracle)»

Conceptual Project · Logical Project

About

This project aims to design a database from side to side, starting from scratch, producing an EER diagram, that would be mapped to a relational database to finally build the physical Oracle project.

We are building an database for a Vet Clinic system that has[...]

Conceptual Project

Logical Project

TUTOR (*CPF*, NOME, LOG, ESTADO, CIDADE)

NUM_TELEFONE (*CPF, NUMERO*)
CPF -> TUTOR(CPF)

ANIMAL (*NOME, CPF*, NASCIMENTO)
CPF -> TUTOR(CPF)

PRONTUARIO(*IDP*, HISTORICO, [CPF, NOME]!)
CPF, NOME -> ANIMAL(CPF, NOME)

VETERINARIO(*CRVET*, NOME, CRVETSUP)
CRVETSUP -> VETERINARIO(CRVET)

ATENDIMENTO (*DATA, NOME, CPF, CRVET*)
NOME, CPF -> ANIMAL(NOME)
CRVET -> VETERINARIO(CRVET)

RECEITA(*IDR*, DESCRITIVO, DATA!, NOME!, CPF!, CRVET!)
DATA, NOME, CPF, CRVET -> ATENDIMENTO(DATA, NOME, CPF, CRVET)

PROCEDIMENTO(*IDP*, DESCRICAO, DATA, MEDICACAO, RECOMENDACAO)

CLINICO(*IDP*, EXAME)
IDP -> PROCEDIMENTO(IDP)

DOMICILIAR(*IDP*, DATAVOLTA)
IDP -> PROCEDIMENTO(IDP)

EXECUTA(*NOME, CPF, IDP, CRVET*)
NOME, CPF -> ANIMAL(NOME, CPF)
IDP -> PROCEDIMENTO(IDP)
CRVET -> VETERINARIO(CRVET)

Running the physical project

• We used LiveSQL tool from Oracle to host and run the DDL, DML and Procedures.
• Here you can see information about running/testing the actual physical model of this database project.