Databases Keywords

?
  • Created by: mrkhan
  • Created on: 24-10-13 15:42
1. Database
A collection of organised data relating to a particular topic allowing the data to be interrogated (Searched) etc.
1 of 15
2. Flat File Database
This is an organised set of data all put together in ONE table.
2 of 15
3. Relational Database
This is an organised set of data with MORE than ONE table in it. These tables are all linked together.
3 of 15
4. A Record
This data about one person or object (Row in a database)
4 of 15
5. A field
This is one data item of a record
5 of 15
6. A Primary Key Field
This is a data item that uniquely identifies a record in a database
6 of 15
7. A Foriegn Key Field
This is a primary key field in one table that is repeated in another table to join them together.
7 of 15
8. Data Redundancy
This happens when data is repeated and hence more disc space is taken up.
8 of 15
9. Data Inconsistancy
This happens because data is repeated and when data needs to be changed not all records that need to be changed are changed hence the data will be wrong
9 of 15
10. Entity
A person or object about whom data is kept
10 of 15
11. Relationship between entities
The links between tables in a database
11 of 15
12. Entity Relationship Diagrams
This is a diagrammatic way of showing how entities are linked to each other.
12 of 15
13. First Normal Form (1NF)
Data is said to be in this form if there are no repeating groups. In other words, each column must contain only a single value and each row must have an item in every column
13 of 15
14. Second Normal Form (2NF)
Data is said to be in this form if it is in 1NF and it has no partial dependencies
14 of 15
15. Third Normal Form (3NF)
Data is said to be in this form if it is in 2NF and have no transitive dependencies
15 of 15

Other cards in this set

Card 2

Front

2. Flat File Database

Back

This is an organised set of data all put together in ONE table.

Card 3

Front

3. Relational Database

Back

Preview of the front of card 3

Card 4

Front

4. A Record

Back

Preview of the front of card 4

Card 5

Front

5. A field

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »