Database and Spreadsheet Fundamentals

Vocabulary flashcards covering key terms related to databases, spreadsheets, and query languages based on the lecture notes.

Database

A collection of data stored in a computer system

Formula

A set of instructions used to perform a calculation using the data in a spreadsheet

Function

A preset command that automatically performs a specified process or task using the data in a spreadsheet

Query

A request for data or information from a database

Query language

A computer programming language used to communicate with a database

Stakeholders

People who invest time and resources into a project and are interested in its outcome

Structured Query Language

A computer programming language used to communicate with a database

Spreadsheet

A digital worksheet

SQL

A computer programming language used to communicate with a database

Attribute

A characteristic or quality of data used to label a column in a table.

Observation

The attributes that describe a piece of data contained in a row of a table.