Databases Flashcards

1
Q

What is a relational database?

A

A database which recognises the difference between entities by using
different tables for each entity.

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

Define attributes

A

Characteristics of an entity

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

Define flat file

A

A database where a single table data structure is used to store all the data.

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

Define primary key

A

A unique identifier, which identifies each record in a table.

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

How is the primary key shown?

A

By underlining it.

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

Define foreign key

A

A linking attribute that joins two tables in a relational database, by being a primary key in one and a foreign key in another.

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

How is the foreign key shown?

A

Using an asterisk.

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

Define secondary key

A

A key that can be used as an alternative index to access or sort records in the table in a quicker, but less accurate than the primary key.

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

What is the entity-relationship modelling method?

How can it be used?

A

A method of abstractly describing the data tables and the relationships between them visually.

It can be used to reduce redundancy and construct a relational database.

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

ER: One-to-one

A

Each entity can only be linked to one other entity.
EG: Husband and Wife

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

ER: One-to-many

A

One table can be assosciated with many other tables.
EG: Mother and Multiple Children

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

ER: Many-to-many

A

One entity can be assosciated with many other entities, and the same applies the other way around.
EG: Students and courses.

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

Define normalisation

A

The formal process of optimally designing data tables by reducing data redundancy and repetition by converting them into normal forms.

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

What does normalisation try to accomplish?

A
  • No redundancy (unnecessary duplicates)
  • Consistent data throughout linked tables
  • Records can be added and removed without isues.
  • Complex queries can be carried out
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

First Normal Form (1NF)

A

A table with no repeating attributes. The intersection of each record and attribute produces exactly one value.

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

Second Normal Form (2NF)

A

A table in 1NF that has data that repeats across multiple records removed, and put into a new table with appropriate relationships (no partial dependencies)

17
Q

Third Normal Form (3NF)

A

A table in 2NF where all attributes that aren’t the primary key are fully dependent on the primary key (no non-key dependencies)