Week 1-10

Question 1

What is a recursive relationship?

Answer 1

An attribute that has a relationship whit another similar entity in another table

Question 2

What is the purpose of normalisation?

Answer 2

To eliminate redundant data within the data base

Question 3

What happens at the FIRST normal form of normalisation?

Answer 3

The table has a primary key, every row has the same data

Question 4

What happens at the SECOND normal from of normalisation?

Answer 4

Every table has a primary key

There are no “partial key dependencies”

Question 5

What happens at the THIRD normal form of normalisation?

Answer 5

Every table has a primary key

There are no “partial key dependencies”

There are no “transitive dependencies”

Question 6

What are the three stages of database design?

Answer 6

Conceptual, physical and logical

Question 7

Can primary key’s be NULL?

Answer 7

No

Question 8

What is locking used for?

Answer 8

A procedure used to control concurrent access to data

Question 9

What is a benefit of using the index, in terms of optimisation?

Answer 9

Improves the speed of data retrieval operations on a database table