10 - Fundamentals of Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What does it mean for relations to be in Third Normal Form.

Why is it important that the relations in a relational database are in Third Normal Form?

A

3NF means every non-key attribute is dependent on the key, the whole key and nothing but the key. There are also no repeating groups.

This is important to eliminate update anomalies, eliminate insertion anomalies, eliminate deletion anomalies, eliminate data inconsistency and minimise data duplication.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

State the properties that the relations in a fully normalised database must have.

A
  • There are no repeating groups of attributes.
  • All non-key attributes depend on the whole key.
  • All non-key attributes depend on nothing but the key.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Describe a problem when a table is not normalised.

A

It is difficult to query as it contains repeating groups of attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the name given to a key that is made up of multiple attributes?

A

Composite key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why is it important for a database to be in third normal form?

A
  • Eliminate update anomalies
  • Eliminate insertion anomalies
  • Eliminate deletion anomalies
  • Eliminate data inconsistency
  • Eliminate data redundancy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly