AQA Paper 2 - Fundamentals of databases

?
What is an attribute?
A changeable property
1 of 5
What is a primary key?
A key that is unique for each record
2 of 5
What is a composite primary key?
A key that uses two or more fields from a table to make a unique value
3 of 5
What is a foreign key?
A column in a table that connects to another table's primary key
4 of 5
Why are databases normalised?
+To reduce redundancy (duplicate data) and to ensure only relevant data is stored in each table

+Prevents any issues to do with database modifications
5 of 5

Other cards in this set

Card 2

Front

A key that is unique for each record

Back

What is a primary key?

Card 3

Front

A key that uses two or more fields from a table to make a unique value

Back

Preview of the back of card 3

Card 4

Front

A column in a table that connects to another table's primary key

Back

Preview of the back of card 4

Card 5

Front

+To reduce redundancy (duplicate data) and to ensure only relevant data is stored in each table

+Prevents any issues to do with database modifications

Back

Preview of the back of card 5

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »