liniis / lab-bd-oracle Goto Github PK
View Code? Open in Web Editor NEWProjeto desenvolvido para a disciplina de Banco de Dados - Oracle
lab-bd-oracle's Introduction
lab-bd-oracle's People
Contributors
Watchers
lab-bd-oracle's Issues
Adicionar comentários às colunas e tabelas de historiamento
Criar functions e procedures de auditoria
- function que resgata o usuário do bd para ser usada na tabela de auditoria
- procedure para inserção na tabela de auditoria
Mudar o tipo do doc_cliente
- mudar de CHAR pra VARCHAR
- corrigir função decode pra utilizar length
Criar tabelas de historiamento (tabelas temporais)
Criar triggers dos eventos de auditoria
- triggers para as tabelas:
- fornecedores
- funcionarios
- cargos
- categorias
- produtos
- vendas
- itens_vendas
- eventos:
- 'U' update
- 'I' insert
- 'D' delete
verificar quais campos serão utilizados, não precisa ser todos apenas os mais estratégicos para gerar relatórios.
Criar triggers e sequences para as tabelas
Criação Modelo Lógico e Relacional do mini-mundo: petshop
Revisar Stage_table Joins
- vnd_id 32 missing após os joins
Adicionar comentários às tabelas e colunas
Criar tabela de auditoria
Criar tabelas modeladas
Popular as tabelas
Povoamento das tabelas:
- cargos
- categorias
- funcionarios
- fornecedores
- produtos
- vendas
- itens vendidos (itens_venda)
Criar tabela Stage
Tabela de Stage
- com comentários
- adicionar constraints
- conter dados essenciais trabalhar com data warehouse
Criar triggers para tabelas de historiamento
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.