# joaoptoaldo/implementacao-banco-de-dados architecture
> Architecture diagram of the GitHub repository joaoptoaldo/implementacao-banco-de-dados, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-10). It is an AI-made overview: check details against the source.
- Interactive diagram: https://gitdiagram.com/joaoptoaldo/implementacao-banco-de-dados
- Repository: https://github.com/joaoptoaldo/implementacao-banco-de-dados
## Overview
This is a Portuguese-language collection of database implementation coursework: SQL examples, database scripts, and topic notes. Its documented purpose is to centralize projects, labs, and practical activities, rather than describe a single runtime product or user-to-result workflow. The files cover schemas, queries, programmable SQL, data integrity, access control, and transactions. No source excerpts or README-described relationships were provided, so the graph groups these materials by topic without asserting execution order, calls, or data flow.
## Diagram (Mermaid)
```mermaid
flowchart TD
subgraph group_schemas["Database schemas"]
node_empresa["Empresa schema
[EMPRESA.sql]"]
node_empresa26["Empresa 2026 schema
[EMPRESA_2026.sql]"]
node_faculdade["Faculdade schema
[FACULDADE_2.sql]"]
end
subgraph group_queries["Queries and views"]
node_consultas["SQL Server queries
[ConsultasSQL.sql]"]
node_clausulas["General clauses"]
node_joins["Joins
[JOINS.sql]"]
node_views["Views
[views.sql]"]
node_mysqlconsultas["MySQL queries
[ListaConsultas.sql]"]
end
subgraph group_programmable["Programmable SQL"]
node_funcoes["Functions
[funcoes.sql]"]
node_condicionais["Conditionals
[condicionais.sql]"]
node_cursores["Cursors
[cursores.sql]"]
node_variaveis["Variables and conversions"]
node_while["While loops
[while.sql]"]
end
subgraph group_operations["Integrity and operations"]
node_integridade["Integrity constraints
[LOJA_DB.sql]"]
node_acessos["Access management"]
node_transacoes["Transactions
[transactions.sql]"]
node_triggers["Triggers
[triggers.sql]"]
end
subgraph group_guides["Topic notes"]
node_ativosnote["Active databases notes"]
node_functionsnote["Functions and procedures notes"]
node_accessnote["Access management notes"]
node_integritynote["Data integrity notes"]
node_transactionsnote["Transactions and errors notes"]
node_triggersnote["Triggers notes
[Triggers.md]"]
end
click node_empresa "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/EMPRESA.sql"
click node_empresa26 "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/EMPRESA_2026.sql"
click node_faculdade "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/FACULDADE_2.sql"
click node_consultas "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Consultas/ConsultasSQL.sql"
click node_clausulas "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Consultas/clausulas_gerais.sql"
click node_joins "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Joins/JOINS.sql"
click node_views "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Views/views.sql"
click node_mysqlconsultas "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/ConsultasSQL%20-%20revis%C3%A3o/MySQL/ListaConsultas.sql"
click node_funcoes "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Fun%C3%A7%C3%B5es/funcoes.sql"
click node_condicionais "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/condicionais.sql"
click node_cursores "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/cursores.sql"
click node_variaveis "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/variaveis_conversoes.sql"
click node_while "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/while.sql"
click node_integridade "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Restri%C3%A7%C3%B5es%20de%20Integridade/LOJA_DB.sql"
click node_acessos "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Gerenciamento%20de%20Acessos/gerencia_acessos_usuario.sql"
click node_transacoes "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Transa%C3%A7%C3%B5es/transactions.sql"
click node_triggers "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Triggers/triggers.sql"
click node_ativosnote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Banco%20de%20Dados%20Ativos.md"
click node_functionsnote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Functions%20e%20Procedures.md"
click node_accessnote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Gerenciamento%20de%20Acessos.md"
click node_integritynote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Integridade%20de%20Dados.md"
click node_transactionsnote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Transa%C3%A7%C3%B5es%20e%20Tratamento%20de%20Erros.md"
click node_triggersnote "https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Triggers.md"
classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_empresa,node_empresa26,node_faculdade toneBlue
class node_consultas,node_clausulas,node_joins,node_views,node_mysqlconsultas toneAmber
class node_funcoes,node_condicionais,node_cursores,node_variaveis,node_while toneMint
class node_integridade,node_acessos,node_transacoes,node_triggers toneRose
class node_ativosnote,node_functionsnote,node_accessnote,node_integritynote,node_transactionsnote,node_triggersnote toneIndigo
```
## Components
### Database schemas
- [Empresa schema](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/EMPRESA.sql): `Microsoft SQL Server/BANCOS/EMPRESA.sql`
- [Empresa 2026 schema](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/EMPRESA_2026.sql): `Microsoft SQL Server/BANCOS/EMPRESA_2026.sql`
- [Faculdade schema](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/BANCOS/FACULDADE_2.sql): `Microsoft SQL Server/BANCOS/FACULDADE_2.sql`
### Queries and views
- [SQL Server queries](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Consultas/ConsultasSQL.sql): `Microsoft SQL Server/Consultas/ConsultasSQL.sql`
- [General clauses](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Consultas/clausulas_gerais.sql): `Microsoft SQL Server/Consultas/clausulas_gerais.sql`
- [Joins](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Joins/JOINS.sql): `Microsoft SQL Server/Joins/JOINS.sql`
- [Views](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Views/views.sql): `Microsoft SQL Server/Views/views.sql`
- [MySQL queries](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/ConsultasSQL%20-%20revis%C3%A3o/MySQL/ListaConsultas.sql): `ConsultasSQL - revisão/MySQL/ListaConsultas.sql`
### Programmable SQL
- [Functions](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Fun%C3%A7%C3%B5es/funcoes.sql): `Microsoft SQL Server/Funções/funcoes.sql`
- [Conditionals](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/condicionais.sql): `Microsoft SQL Server/Variáveis - Conversões - If Else - While/condicionais.sql`
- [Cursors](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/cursores.sql): `Microsoft SQL Server/Variáveis - Conversões - If Else - While/cursores.sql`
- [Variables and conversions](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/variaveis_conversoes.sql): `Microsoft SQL Server/Variáveis - Conversões - If Else - While/variaveis_conversoes.sql`
- [While loops](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Vari%C3%A1veis%20-%20Convers%C3%B5es%20-%20If%20Else%20-%20While/while.sql): `Microsoft SQL Server/Variáveis - Conversões - If Else - While/while.sql`
### Integrity and operations
- [Integrity constraints](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Restri%C3%A7%C3%B5es%20de%20Integridade/LOJA_DB.sql): `Microsoft SQL Server/Restrições de Integridade/LOJA_DB.sql`
- [Access management](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Gerenciamento%20de%20Acessos/gerencia_acessos_usuario.sql): `Microsoft SQL Server/Gerenciamento de Acessos/gerencia_acessos_usuario.sql`
- [Transactions](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Transa%C3%A7%C3%B5es/transactions.sql): `Microsoft SQL Server/Transações/transactions.sql`
- [Triggers](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Microsoft%20SQL%20Server/Triggers/triggers.sql): `Microsoft SQL Server/Triggers/triggers.sql`
### Topic notes
- [Active databases notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Banco%20de%20Dados%20Ativos.md): `Banco de Dados Ativos.md`
- [Functions and procedures notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Functions%20e%20Procedures.md): `Functions e Procedures.md`
- [Access management notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Gerenciamento%20de%20Acessos.md): `Gerenciamento de Acessos.md`
- [Data integrity notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Integridade%20de%20Dados.md): `Integridade de Dados.md`
- [Transactions and errors notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Transa%C3%A7%C3%B5es%20e%20Tratamento%20de%20Erros.md): `Transações e Tratamento de Erros.md`
- [Triggers notes](https://github.com/joaoptoaldo/implementacao-banco-de-dados/blob/main/Triggers.md): `Triggers.md`