Self-Test 4-3: Relational Database Concepts

Unlimited tries

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