DATA 2100 FINAL EXAM LATEST
UPDATED
Tables - ANSWER Includes information about a category of "object" for
which data are stored in the database
Fields - ANSWER Columns of the table (up and down things)
Records - ANSWER Another name for rows in SQL (side to side)
SELECT - ANSWER Performing math
Analytical Functions
Aggregate Functions (Sum, count, average, max, min)
Renaming columns
FROM - ANSWER Identifies the table you need for the query
WHERE - ANSWER AND and OR
BETWEEN/AND
IN and NOT IN
IS/IS NOT
GROUP BY - ANSWER Allows us to calculate aggregate functions for a
certain group
goes immediately after the WHERE clause in our queries
HAVING - ANSWER Similar to the WHERE clause, except that it applies to
grouped data formed as the result of an aggregate function rather than individual
records.
Unless there is a GROUP BY clause in the query, there should not be this
clause.
ORDER BY - ANSWER Using Pointers
, Ascending vs. Descending
Use in conjunction with analytical functions
Multi-Table SELECT Queries - ANSWER How to join in the WHERE clause
Aliases
Confirmation Bias - ANSWER a tendency to search for information that
supports our preconceptions and to ignore or distort contradictory evidence
Flowchart - ANSWER A diagram that maps out the steps taken during the
execution of a process.
Flow Line (arrow) - ANSWER Points to the next step
Terminator (oval/pill shape) - ANSWER Used to start and end the flow
flow in: 0 (for start) or 1 (for end)
flow out: 1 (for start) or 0 (for end)
Action/Process (Rectangle) - ANSWER Signifies an action occurring, usually
results in a change of state
flow in: 1
flow out: 1
Input/Output (parallelogram) - ANSWER items or information are added to
the overall process for use within the process
flow in: 1
flow out: 1
Decision (diamond) - ANSWER used any time that the process needs to decide
between heading one route and another
flow in: 1
flow out: 2
Connector - ANSWER deals with situations that have multiple inflows all
trying to get into an object that only allows one inflow.
UPDATED
Tables - ANSWER Includes information about a category of "object" for
which data are stored in the database
Fields - ANSWER Columns of the table (up and down things)
Records - ANSWER Another name for rows in SQL (side to side)
SELECT - ANSWER Performing math
Analytical Functions
Aggregate Functions (Sum, count, average, max, min)
Renaming columns
FROM - ANSWER Identifies the table you need for the query
WHERE - ANSWER AND and OR
BETWEEN/AND
IN and NOT IN
IS/IS NOT
GROUP BY - ANSWER Allows us to calculate aggregate functions for a
certain group
goes immediately after the WHERE clause in our queries
HAVING - ANSWER Similar to the WHERE clause, except that it applies to
grouped data formed as the result of an aggregate function rather than individual
records.
Unless there is a GROUP BY clause in the query, there should not be this
clause.
ORDER BY - ANSWER Using Pointers
, Ascending vs. Descending
Use in conjunction with analytical functions
Multi-Table SELECT Queries - ANSWER How to join in the WHERE clause
Aliases
Confirmation Bias - ANSWER a tendency to search for information that
supports our preconceptions and to ignore or distort contradictory evidence
Flowchart - ANSWER A diagram that maps out the steps taken during the
execution of a process.
Flow Line (arrow) - ANSWER Points to the next step
Terminator (oval/pill shape) - ANSWER Used to start and end the flow
flow in: 0 (for start) or 1 (for end)
flow out: 1 (for start) or 0 (for end)
Action/Process (Rectangle) - ANSWER Signifies an action occurring, usually
results in a change of state
flow in: 1
flow out: 1
Input/Output (parallelogram) - ANSWER items or information are added to
the overall process for use within the process
flow in: 1
flow out: 1
Decision (diamond) - ANSWER used any time that the process needs to decide
between heading one route and another
flow in: 1
flow out: 2
Connector - ANSWER deals with situations that have multiple inflows all
trying to get into an object that only allows one inflow.
