Information Management 2A (INMT201)

A set of flashcards covering key concepts in Information Management and Data Management.

Database Management System (DBMS)

A system that helps organizations manage and process data.

Relational Database

A database that stores data in a series of related tables with minimal duplication.

Entity

An object or concept about which data is stored in a database.

Primary Key

A unique identifier for a record in a table.

Foreign Key

A field in one table that is a primary key in another table, creating a relationship between the two.

Referential Integrity

A concept that ensures a foreign key must reference an existing primary key.

Records

Rows in a table that contain all the data about one specific entity.

Fields (or Attributes)

Columns in a table that store specific items of data.

Data Redundancy

The unnecessary duplication of data within a database.

Data Modelling

The process of creating a data model for the data to be stored in a database.