OIM2000: Data Management - Database Design

Flashcards covering key concepts related to data management and database design, based on the OIM2000 course lecture notes.

Relational Database Management System (RDBMS)

A type of database that stores data in a structured format, using rows and columns. It allows for easy access and management of data.

Entities

Objects or things in the database that can have data stored about them, such as students, courses, or orders.

Attributes

Characteristics or properties of an entity, represented as fields in a database table.

Primary Key

A unique identifier for a record in a table; it ensures that no two records have the same value.

Foreign Key

An attribute in one table that is a primary key in another table, used to establish a relationship between the two tables.

Entity Relationship Diagram (ERD)

A visual representation of the entities in a database and their relationships to each other.

Spreadsheet

A digital document in which data is arranged in rows and columns, often used for simple data management.

Data Integrity

The accuracy and consistency of stored data, ensured by relational databases.

Data Visualization

The graphical representation of information and data, helping to interpret complex data sets.

Big Data

Extremely large data sets that may be analyzed computationally to reveal patterns, trends, and associations.