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

Leaderboard

Visual style

Options

Switch template

Continue editing: ?