Database Management Systems

Flashcards covering vocabulary terms related to database concepts and SQL.

Structured Data

Data that has a defined structure, often based on the data type, making it easily searchable.

Unstructured Data

Data that does not have a set structure or format and may contain a mixture of data types; often qualitative rather than quantitative.

Data

Text, values, symbols, images, or sounds that have not been given any meaning.

Information

Data that has been processed and given a context to provide meaning.

Data Extraction

The process of taking the most beneficial data from a large set and processing it to create meaningful information.

Table

A collection of related data, usually structured in columns and rows.

Field

A column in a database.

Record

A row in a database.

Primary Key

A field in the database where every piece of data stored is unique for each record, making it a unique identifier.

Relational Database

A database with multiple tables linked together through the use of keys.

Foreign Key

A primary key from one table that appears in another table to create a link between the two tables.

Composite Key

A unique identifier created by combining two or more fields in a table.

One-to-One Relationship

A link where one record in an entity is related to just one record in another entity.

One-to-Many Relationship

A link where one record in an entity is related to multiple records in another entity.

Many-to-Many Relationship

A link where many records in one table can be linked to many records in another table; this relationship usually involves a middle table that creates two one-to-many relationships.

Query

A search created to find specific data in a database.

Structured Query Language (SQL)

The programming language used to create queries.

OR

Outputs records meeting either of the conditions.

AND

Outputs records meeting both conditions.

NOT

Outputs records that do not meet the stated condition.