07 Relational Databases and SQL Required Vocabulary

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/12

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 8:14 AM on 10/2/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

13 Terms

1
New cards

Database

A structured collection of data that can be organised

2
New cards

Relational Database

A database that stores data in related tables and uses relationships between those tables to organise data.

3
New cards

Table

A structure within a database that stores related data organised into records and fields.

4
New cards

Record

A single row in a database table containing all the data about one item or instance.

5
New cards

Field

A single item of data within a record. A field forms a column in a database table.

6
New cards

Primary Key

A field that uniquely identifies each record in a table.

7
New cards

Foreign Key

A field in one table that links to the primary key of another table to create a relationship between the tables.

8
New cards

Data Redundancy

The unnecessary duplication of data within a database. Relational databases help to eliminate data redundancy.

9
New cards

Data Inconsistency

A situation where duplicate copies of data have different values. Relational databases help to eliminate data inconsistency.

10
New cards

Relationship

A link between tables created using primary keys and foreign keys

11
New cards

SQL (Structured Query Language)

A language used to retrieve, insert, edit and delete data in a relational database.

12
New cards

Query

A request to retrieve or manipulate data in a database using SQL commands.

13
New cards

Flat File Database

A database that contains ONLY one table.