This document contains an entity relationship diagram describing the relationships between entities in a grant/subsidy management system. The entities include subsidies, invoices, components, employees, rules, applications, participants, administrators, banks, intermediation, management of subsidies and applications. Primary and foreign keys are defined for each entity along with non-key attributes. Relationships defined include manages, appears in, has, creates, invoices, approves, manages application, manages subsidies.
1 of 1
Download to read offline
More Related Content
entidad relacion.doc
1. 9.2.10.- Modelo Entidad Relaci坦n
SUBVENCIONES
Pri mary Key
"IDENT IFICADOR SUBVENCION" [PK1]
Non-Key Attri butes
IDSUBVENCION
IDSOLICIT UD [FK]
"DNI/NIF" [FK]
FACT URA
Pri mary Key
IDFACT URA [PK1]
IDADM IN [PK2] [FK]
Non-Key Attri butes
"CODIGO EM PRESA"
CIF
IDSOLICIT UD [FK]
"DNI/NIF" [FK]
COM PONENT ES
Pri mary Key
IDCOM PONENT E [PK1]
Non-Key Attri butes
NOM BRE
DESCRIPCION
PRECIOconIVA
PRECIOsinIVA
"PRECIO SUBVENCION APLICABLE "
EM PLE ADO VENDEDOR
Pri mary Key
IDADM IN [PK1] [FK]
Non-Key Attri butes
CODIGOEM PRESA
CIF
T ELEFONO
REGLAS
Pri mary Key
IDREGLA [PK1]
IDADM IN [PK2] [FK]
Non-Key Attri butes
"DESCRIPCION REGLA"
SOLICIT UDES
Pri mary Key
IDSOLICIT UD [PK1]
"DNI/NIF" [PK2] [FK]
Non-Key Attri butes
"EST ADO SOLICIT UD"
PART ICIPANT ES
Pri mary Key
"DNI/NIF" [PK1]
Non-Key Attri butes
NOM BRE
DIRECCION
T ELEFONO
PASWORD
ADM INIST RADORES
Pri mary Key
IDADM IN [PK1]
Non-Key Attri butes
LOGIN
PASWORD
NIVEL
BANCO
Pri mary Key
IDBANCO [PK1]
Non-Key Attri butes
"OFICINA PRINCIPAL"
SEDE
NOM BRE
INT ERM EDIACION SUBVENCIONES
Pri mary Key
IDREM ESA [PK1] [FK]
"IDENT IFICADOR SUBVENCION" [PK2] [FK]
GEST ION DE SUBVENCIONES
Pri mary Key
IDADM IN [PK1] [FK]
"IDENT IFICADOR SUBVENCION" [PK2] [FK]
GEST ION DE SOLICIT UDES
Pri mary Key
IDADM IN [PK1] [FK]
IDSOLICIT UD [PK2] [FK]
"DNI/NIF" [PK3] [FK]
EM PLE ADO AYUNT AM IENT O
Pri mary Key
IDADM IN [PK1] [FK]
ADM INIST RADOR HACIENDA
Pri mary Key
IDADM IN [PK1] [FK]
REM ESAS
Pri mary Key
IDREM ESA [PK1]
Non-Key Attri butes
EST ADO
LINEA PEDIDO
Pri mary Key
IDFACT URA [PK1] [FK]
IDADM IN [PK2] [FK]
IDCOM PONENT E [PK3] [FK]
COBROS
Pri mary Key
IDREM ESA [PK1] [FK]
IDBANCO [PK2] [FK]
REM ESAS APROBADAS
COBRA
COBRA DA
SUBVENCIONES EN REMESA
SUBVENCION GEST IONADA
GEST IONA SUBVENCIONES
EST ABLECE
APARECE
T IENE
CREA
FACT URADO
APROB ADA
SOLICIT UD GEST IONADA
GEST IONA SOLICIT UD
SOLICIT A