Back to marketplace

1.3.2 Databases

No description yet. This curated deck is ready for daily study.

Total cards: 24•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (24)

#1
Front (Question)

Database

Back (Answer)

A collection of data or information which is held together in an organised way

#2
Front (Question)

Flat file database

Back (Answer)

Consist of a single table which stores all the data within that database

#3
Front (Question)

Relational Database

Back (Answer)

A database that has a separate table for each entity.

#4
Front (Question)

Primary Key

Back (Answer)

A field in a table which is unique and allows you to identify every record

#5
Front (Question)

Foreign Key

Back (Answer)

Used to link tables together and create relationships

#6
Front (Question)

Compound/composite primary key

Back (Answer)

Combines more that one field to make a unique value

#7
Front (Question)

Secondary key

Back (Answer)

A key made on a field to be indexed for faster searches

#8
Front (Question)

Referential integrity

Back (Answer)

Making sure you cannot delete record that are used by other tables

#9
Front (Question)

Entity relationship modelling/diagram

Back (Answer)

A diagram that represents the relationships between entities in a database

#10
Front (Question)

Normalisation

Back (Answer)

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

#11
Front (Question)

Indexing

Back (Answer)

Creating a database index that improves the speed of data retrieval in a database

#12
Front (Question)

0NF

Back (Answer)

A table with no normalisation

#13
Front (Question)

1NF/ First Normal Form

Back (Answer)

A table containing no repeated attributes

#14
Front (Question)

2NF/ Second Normal Form

Back (Answer)

A table that’s is in first normal form and contains no partial dependencies

#15
Front (Question)

3NF / Third Normal Form

Back (Answer)

A table that is in 2NF and all non key elements are fully dependent on the primary key

#16
Front (Question)

Normal Forms

Back (Answer)

Ways for structuring data in a relational database according to formal rules

#17
Front (Question)

SQL / Structured Query Language

Back (Answer)

A declarative language used for querying and updating tables in a relational database

#18
Front (Question)

Database transaction

Back (Answer)

A set of operations that update one or more databases in some way

#19
Front (Question)

ACID

Back (Answer)

Atomicity Consistency Isolation Durability

#20
Front (Question)

Atomic transaction

Back (Answer)

An atomic transaction is indivisible

#21
Front (Question)

Consistent transaction

Back (Answer)

Follows all of the established rules of the database

#22
Front (Question)

Isolated transaction

Back (Answer)

Cannot be interfered with while underway

#23
Front (Question)

Durable transaction

Back (Answer)

Is recorder is such a way that the result cannot be easily lost

#24
Front (Question)

Record locking

Back (Answer)

Preventing simultaneous access to record in a database