null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
43511
Chapter 5
Description
ICT Mind Map on Chapter 5, created by smita089 on 11/04/2013.
No tags specified
ict
ict
Mind Map by
smita089
, updated more than 1 year ago
More
Less
Created by
smita089
over 11 years ago
75
0
0
Resource summary
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.
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
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
Browse Library