ENGR 2404 - Exam 1 - Data Management

identify; interest; develop; store

Data management is to (a) _______ what types of data are of _______and (b)_______ suitable methods to acquire,_______ , and use data.

smallest

Each cell = the ________ item with some information/data about an object of interests

unique

Each row = the ________ collection of cells containing information about an object of interests

label

Each column = the ________ identifying a particular type of data/information

entity

Each table = the collection of rows with the same columns about the same type of ________

optimized; concurrent; access control

Advantages of databases: (a) highly specialized and for ________ storage, searching, and updating; (b) support a large number of ________users; (c) support more about robust ________ ________

rules; queries; access control; maintain

Disadvantages of databases: (a) requires many______ for operations, writing _______, and________ _________; (b) higher costs to implement software and infastructure, and to operate and __________

specialized

ISEs can use Excel for many analytical and technical tasks, but it may not be sufficent for _______ tasks.

querying

Store data: less suitable than MS SQL Server for structured storage, _______, and multi-user access

OpenSolver; scalable

Optimization: solve small-medium problems with _______, but not _______as compared to CPLEX

connections

Dashboards: support basic dashboards and database _________ , but not as advanced as Tablaeu/Power BI

tests; advanced

Statistics: can run some basic statistical __________ , but RS Studio, Minitab, and SAS provide more ______ tests.

absolute; shifting

With LOOKUP functions, the lookup column and the retrieve column must come from the same data table, covering all rows of the table. Applying _______ cell references (full F4 lock) prevent these columns from _______ when the formula is copied and pasted

argument; exact

With INDEX+MATCH and VLOOKUP, the 4th ________ must be set to 0 or false. This setting tells the function to find an ________ match, because approximating can return the wrong row/value.

repeated

In a two-column unique identifier, each individual column may still contain ________ values.

ordered

However, the ________ pair of values across the two columns must be unique for every row

Primary Key

Later, when we talked about databases, we call the chosen unique identifier of a table the test _______ _______