null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
43511
Chapter 5
Descrição
ICT Mapa Mental sobre Chapter 5, criado por smita089 em 11-04-2013.
Sem etiquetas
ict
ict
Mapa Mental por
smita089
, atualizado more than 1 year ago
Mais
Menos
Criado por
smita089
aproximadamente 11 anos atrás
74
0
0
Resumo de 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.
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
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
Explore a Biblioteca