Relational databases & Normalisation Flashcards

1
Q

Relational database

A

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

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

Entity name

A

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

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

Primary key

A

Is underlined

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

Normalisation

A

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

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