Computer Science Exam Review: Arrays, Flowcharts, and Data Structures

This set of vocabulary flashcards covers essential concepts from the lecture notes including pseudocode syntax, flowchart symbols, verification methods, data types, and basic SQL commands.

1D Array

A one-dimensional data structure with a specified size and data type where values are stored and accessed via an index.

Oval symbol

A standard flowchart symbol used to represent the START or END of an algorithm.

Rectangle symbol

A standard flowchart symbol used to represent a process or an assignment.

Parallelogram symbol

A standard flowchart symbol used to represent input or output operations.

Diamond symbol

A standard flowchart symbol used to represent a decision or a condition.

Trace Table

A tool used to follow an algorithm step by step by tracking how each variable changes with each input value and recording final outputs.

Verification

A process that checks that data has been entered correctly and matches the original source.

Double entry verification

A check where a set of values is entered twice and compared; if they match, the process continues, otherwise the user is prompted to re-enter the data.

Variable

A named storage location in memory whose value can change while the program runs.

Constant

A named storage location whose value is set once and does not change.

INTEGER

A data type that stores whole numbers only.

REAL

A data type that stores numbers with a decimal point.

CHAR

A data type that stores a single character.

BOOLEAN

A data type that stores only TRUE or FALSE values, often used as a flag.

Primary Key

A field that uniquely identifies each record in a database table; it must be unique and cannot be left empty.

SELECT

An SQL command used to choose which fields to display from a table.

FROM

An SQL command used to specify the table name in a query.

WHERE

An SQL command used to filter records based on a specific field value.

STRING

A pseudocode data type used for a name or text value.