relational, A type of database that uses more than one linked table to reduce data redundancy., record, Each row in a database table represents one of these., flat file, Type of database with only one table, often leading to data duplication., integrity, A rule or condition that keeps data accurate and consistent., field, A column in a table that stores one piece of data about a record., table, An arrangement of columns and rows used to store data in a database., primary key, A unique identifier for each record in a table., foreign key, A field that links one table to another table’s primary key., redundancy, When the same data is stored multiple times unnecessarily., inconsistency, When two or more copies of data don’t match due to poor updating., one to many, A type of relationship where one record in a table links to many in another., data type, A category that decides the kind of data a field can hold (e.g., text, number, date)., database, A bad seat

Y11 Relational databases

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?