What is a variable?
A storage location whose value can change while a program runs
What is a constant?
A value that never changes during processing
Integers store…
Whole numbers
Floating point numbers store…
Decimal values
Strings store…
Text
Boolean values store…
Whether something is true or false
Characters store…
Single letters and symbols
What is an algorithm?
A finite, step-by-step set of instructions used to solve a problem or perform a task
An algorithm must:
- Have a finite number of steps
- Be precise with clear and exact instructions
- Be unambiguous, have one interpretation
- Have a clear flow of instruction
- Must terminate
In flowcharts, the ________ ________ showed calculations and the ________ ________ showed the flow of control
process symbol and directional arrows
How does pseudocode communicate?
With simple English-like commands
DIV divides numbers and…
Only returns the whole number
MOD divides numbers and…
Only returns the remainder
Relational operators…while logical operators…
Relational operators compare values while logical operators combine conditions
What is a database?
A repository of information, a central place where large amounts of data are stored in an organized way so it can be retrieved and managed efficiently
A database can also be…
A collection of tables that are related to each other
A database ensures data is…
Organized, accurate, consistent, and easy to retrieve
Some benefits of a database are:
Storing large amounts of data efficiently
Reducing redundancy
Supporting fast retrieval
Maintaining accuracy
Generating useful reports
What is a table?
A collection of related data
What is a row/record?
A single entry in a table
What is a column/field?
A single type of information
A primary key is…
A field that uniquely identifies each record
A candidate key is…
Any field that can serve as a primary key
A secondary key is…
A field used to sort or search
