Drag each tile and place it next to the principle it descibes in the table below.

A database table row that contains data about a specific item

Two­-dimensional table: each row is a unique entity (record) and each column is a field where data are stored

One or more database attributes that uniquely identifies each row in a table

The loss of all information about an entity when a row is removed from the table

A non-­null primary key ensures that every row in a table represents something that can be identified

An attribute that is a primary key in another table; used to link the two tables

Foreign keys must have values that correspond to the value of a primary key in another table

Following relational database creation rules in order to design a database free from delete, insert, and update anomalies

A non-­primary key item is stored multiple times; updating the item in only one location causes data inconsistencies

A database built using the relational data model

Inability to add records to a database

	Relational Data Model
	Tuple
	Primary Key
	Foreign Key
	Update Anomaly
	Insert Anomaly
	Delete Anomaly
	Relational Database
	Entity Integrity Rule
	Referential Integrity Rule
	Normalization