1.3.2 Databases Flashcards

(a) Relational database, flat file, primary key, foreign key, secondary key, entity relationship modelling, normalisation and indexing. See appendix 5f. (b) Methods of capturing, selecting, managing and exchanging data. (c) Normalisation to 3NF. (d) SQL – Interpret and modify. See appendix 5d. (e) Referential integrity. (f) Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), record locking and redundancy.

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

What is a primary key?

A

A field which has a unique value for every record.

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

What is a entity?

A

An entity is a category of data to be recorded in a database, entities have attributes.

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

What is a flat file database?

A

A database that consists of a single file.

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

What is an attribute?

A

The data attached to an entity. For example the entity Dentist might have the attribute name.

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

Write the entity description format out.

A

Entity (Attribute1, Attribute2)

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

What is the need for a secondary key?

A

A secondary key is indexed allowing for faster

searching.

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

How can an entity relationship be modeled?

A

|Entity|(One/Many)—-(Name of the relationship)—(One/Many)|Entity|

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

What are the three degrees of relationships in a relational database?

A

One to one, One to many, Many to many.

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

How does a relational database work?

A

In a relational database a separate table is created for each entity identified, where a relationship exists between entities an extra field is added to the tables to link them.

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

What is a foreign key?

A

An attribute that creates a join between two tables and will be the primary key of one of the tables and the foreign in the other.

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

What needs to be done in the case of a many to many relationship?

A

An extra table is needed in order to link both tables consisting of foreign keys.

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

What is a composite key?

A

A primary key that consists of more than one attribute.

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

What is an issue likely to arise when using a flat file structure?

A

Redundant data and data inconsistencies.

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