null
US
Iniciar Sesión
Regístrate Gratis
Registro
Hemos detectado que no tienes habilitado Javascript en tu navegador. La naturaleza dinámica de nuestro sitio requiere que Javascript esté habilitado para un funcionamiento adecuado. Por favor lee nuestros
términos y condiciones
para más información.
Siguiente
Copiar y Editar
¡Debes iniciar sesión para completar esta acción!
Regístrate gratis
43511
Chapter 5
Descripción
ICT Mapa Mental sobre Chapter 5, creado por smita089 el 11/04/2013.
Sin etiquetas
ict
ict
Mapa Mental por
smita089
, actualizado hace más de 1 año
Más
Menos
Creado por
smita089
hace alrededor de 11 años
74
0
0
Resumen del Recurso
Chapter 5
Database Terminology
Table - a data structure made up of rows and columns that contains data about the items.
Record - a single row within a table.
Field - an individual data item within a record.
Entity - a table.
Attribute - fields within an entity.
Keys
Primary key - a field, in the table, that allows each record to be uniquely identified.
Simple - made up of a single field only.
Composite - combines more than one field to make a unique value.
Secondary key - a field that is identified as being suitable for indexing the data.
Foreign key - a field in one table that is linked to a primary key in another table.
Relationships
One to one - any instance of the entity X can be associated with only one instance of entity Y.
Many to many - single instance of an entity can be associated with many instances of another entity.
Referential Integrity
Referential integrity – for every foreign key there must be a related primary key value.
Makes sure that it is impossible to enter a reference to a link which does not exist.
Data Dictionary
Contains metadata (data about data).
Table name - name of table, must be unique.
Field name - each field uniquely identified.
Field data type - data type allocated to each field.
Field length - no. of characters allocated for field contents.
Field default value - value appears on creation of new record.
Field validation - any validation applied to field.
Table security - who has access to edit table.
Keys - primary and foreign keys.
Indexes - any field which is indexed.
Relationships - relationships between tables identified.
Queries
Simple - a query where there is only one parameter.
Complex - a query with more than one parameter. Makes use of AND, OR and NOT to join parameters.
Static - parameter is hard coded into the query and cannot be changed by the end user.
Dynamic - request for the parameter given to the end user at run time, usually by a dialogue box.
Normalisation
UNF
1NF
All data is atomic.
Record has a primary key.
Each field name is unique.
No repeating fields.
2NF
Table is in 1NF.
All non-key fields be found out by using the entire primary key.
3NF
Table is in 2NF.
All non-key items are fully dependent on the primary key.
Evaluation
Advantages
No redundant data.
Easier to maintain.
Efiicient structure.
Flexible, can be altered without major redesign.
Disadvanatges
Reduced performance.
Can't store historical data.
More storage space required.
Mostrar resumen completo
Ocultar resumen completo
¿Quieres crear tus propios
Mapas Mentales
gratis
con GoConqr?
Más información
.
Similar
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom
Explorar la Librería