OIM2000 DTE: Data Analytics (A) - Select Queries

This set of flashcards provides key vocabulary and definitions to help students prepare for the OIM2000 Data Analytics course focusing on select queries in databases.

Select Query

A query used to retrieve records from a database according to specified tables and fields.

Referential Integrity

A constraint that ensures relationships between tables remain consistent, such that foreign keys refer to existing primary keys.

Data Type

An attribute associated with a piece of data that determines how the data is interpreted by the system.

CSV File

Comma Separated Values file, a simple text file that can be easily imported and exported between different software.

SQL (Structured Query Language)

A programming language used to manage and manipulate relational databases.

Calculated Field

A field that is derived from other fields in a database, allowing for computational functions.

Wildcard Characters

Special characters used in SQL queries to represent one or more characters in a string search.

Incompatible Datatypes

Data types that cannot be successfully paired together in database relationships.

Big Data

Extensive datasets that traditional database systems are unable to process efficiently.

EBC Database

The specific database used for assignments and queries during the course.

Query Results

The outcome or data that is returned after executing a query.

Primary Key

A unique identifier for a table that ensures each record can be uniquely identified.

Foreign Key

A field in one table that links to the primary key of another table to establish a relationship.

Criteria in SQL

Conditions that specify which records should be retrieved in a query.

Normalization

The process of organizing data in a database to reduce redundancy and improve data integrity.

RDBMS (Relational Database Management System)

A database management system that is based on the relational model.

Data Visualization

The graphical representation of information and data to communicate insights clearly and effectively.

App Design

The process of creating the layout and user interface for software applications.

Internet of Things (IoT)

The interconnection of everyday devices to the internet to collect and exchange data.

Artificial Intelligence (AI)

The simulation of human intelligence in machines programmed to think and learn.

Evolution of Human + AI

The development of the collaboration between human intelligence and artificial intelligence.