Relational databases & Normalisation

Question 1

Relational database

Answer 1

A collection of tables, in which relationships are modeled by shared attributes.

Question 2

Entity name

Answer 2

Is shown outside brackets of table description e.g. Books (BookID, DeweyCode, Title, Author, DatePublished)

Question 3

Primary key

Answer 3

Is underlined

Question 4

Normalisation

Answer 4

A process used to come up with the best possible design for a relational database.