Diseño y aplicación de una base de datos
No Thumbnail Available
Date
2017-11-02
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad Nacional de Educación Enrique Guzmán y Valle
Abstract
El objetivo de este trabajo de investigación fue un modelo conceptual de datos (Modelo de datos), es un conjunto de conceptos y
reglas que permiten estructurar los datos resultantes de la observación de la realidad, de
forma que queden representadas todas sus propiedades, tanto estáticas como dinámicas.
En todo sistema o aplicativo lo más estable, es el modelo conceptual de datos. Si
cambia o se modifica el modelo conceptual de datos, cambia el concepto y el sistema, por
ello no se recomienda actualizaciones en el diseño de la base de datos, está compuesta por
entidades y relaciones por ello se le conoce también como el modelo entidad relación a
nivel lógico.
Del modelo realidad percibida definida por relaciones de datos con estructuras
complejas se infiere el modelo conceptual de datos aplicando las tres formas normales, la
que garantiza relaciones más pequeñas, sencillas y fáciles de mantener.
El modelo interno de datos, llamado frecuentemente como diseño físico de la base
de datos es el perfil de la futura base de datos.
La estructura del modelo interno de datos es muy distinta a la del nivel externo y
están soportados por:
Método de acceso
Estructuras de base de datos
Base de datos
En el modelo interno se minimiza la redundancia y compactan datos.
La naturaleza de esta investigación es altamente tecnológica, para su desarrollo se
ha instalado y utilizado las siguientes plataformas tecnológicas:
Para modelamiento: PLATINUM ERwin ERX 3.5.2
Para el Motor de Base de Datos: SQL SERVER 2008 Express R2
Para el Lenguaje de Programación: netBeans IDE 6.9 (JAVA)
Para interconectar Java- SQL : ODBC 64 bits
The objective of this research work was a conceptual data model (Data Model), it is a set of concepts and rules that allow structuring the data resulting from the observation of reality, so that all its properties, both static and dynamic, are represented. In any system or application, the most stable is the conceptual data model. Yes changes or modifies the conceptual data model, changes the concept and the system, for This is not recommended updates in the design of the database, it is composed of entities and relationships, for this reason it is also known as the entity-relationship model. logical level. From the perceived reality model defined by data relationships with structures complex data, the conceptual data model is inferred by applying the three normal forms, the that guarantees smaller, simpler and easier to maintain relationships. The internal data model, often called the physical design of the database database is the profile of the future database. The structure of the internal data model is very different from that of the external level and are supported by: Access method Database structures Database In the internal model, redundancy is minimized and data is compacted. The nature of this research is highly technological, for its development has installed and used the following technological platforms: For modeling: PLATINUM ERwin ERX 3.5.2 For the Database Engine: SQL SERVER 2008 Express R2 For the Programming Language: netBeans IDE 6.9 (JAVA) To interconnect Java-SQL: ODBC 64 bits
The objective of this research work was a conceptual data model (Data Model), it is a set of concepts and rules that allow structuring the data resulting from the observation of reality, so that all its properties, both static and dynamic, are represented. In any system or application, the most stable is the conceptual data model. Yes changes or modifies the conceptual data model, changes the concept and the system, for This is not recommended updates in the design of the database, it is composed of entities and relationships, for this reason it is also known as the entity-relationship model. logical level. From the perceived reality model defined by data relationships with structures complex data, the conceptual data model is inferred by applying the three normal forms, the that guarantees smaller, simpler and easier to maintain relationships. The internal data model, often called the physical design of the database database is the profile of the future database. The structure of the internal data model is very different from that of the external level and are supported by: Access method Database structures Database In the internal model, redundancy is minimized and data is compacted. The nature of this research is highly technological, for its development has installed and used the following technological platforms: For modeling: PLATINUM ERwin ERX 3.5.2 For the Database Engine: SQL SERVER 2008 Express R2 For the Programming Language: netBeans IDE 6.9 (JAVA) To interconnect Java-SQL: ODBC 64 bits
Description
Keywords
Rendimiento académico
Citation
Cabrera Quichua, J. C. (2017). Diseño y aplicación de una base de datos (Monografía de pregrado). Universidad Nacional de Educación Enrique Guzmán y Valle, Lima, Perú.