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
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[...]
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)
- 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.