IST 359 EXAM 1 QUESTIONS WITH COMPLETE
SOLUTIONS
Data - CORRECT ANSWER✔✔-raw processed facts or figures
| | | | | | |
Information - CORRECT ANSWER✔✔-data that has processed or interrupted
| | | | | | | |
Metadata - CORRECT ANSWER✔✔-data which describes or gives structure to
| | | | | | | | | |
other data
|
Data management - CORRECT ANSWER✔✔-the act of processing data (reading,
| | | | | | | | | |
adding, changing, or deleting data)
| | | |
CRUD - CORRECT ANSWER✔✔-the data management operations; create, read,
| | | | | | | | |
update, and delete | |
Database - CORRECT ANSWER✔✔-a collection of data, metadata and data
| | | | | | | | | |
management activities |
Query - CORRECT ANSWER✔✔-asking questions of data processing information
| | | | | | | |
DBMS - CORRECT ANSWER✔✔-software to facilitate the use of computerized
| | | | | | | | | |
databases
, Conceptual Model - CORRECT ANSWER✔✔-the global view of a database from
| | | | | | | | | | |
the user's perspective
| |
Logical Model - CORRECT ANSWER✔✔-a view of a database that is depended on
| | | | | | | | | | | | |
database model, but not specific implementation
| | | | |
Internal Model - CORRECT ANSWER✔✔-a view of a database as implemented
| | | | | | | | | |
External Model - CORRECT ANSWER✔✔-portions of a database implemented to
| | | | | | | | | |
facilitate the conceptual view
| | |
Physical Model - CORRECT ANSWER✔✔-how the database is implemented
| | | | | | | | |
through software, such as a DBMS
| | | | |
ARTC - CORRECT ANSWER✔✔-characteristics of data that make it useful;
| | | | | | | | | |
accurate, relevant, timely, and contextual
| | | |
Table - CORRECT ANSWER✔✔-a primary unit of storage in the relational model,
| | | | | | | | | | | |
2D structure consisting of rows and columns
| | | | | |
Relation - CORRECT ANSWER✔✔-A table with a column (or set of columns) for
| | | | | | | | | | | | |
which the data in those columns can be used to find one unique row
| | | | | | | | | | | | |
Column - CORRECT ANSWER✔✔-Represents a category of data in a relational
| | | | | | | | | | |
table. For example in a table of customers, this would be the customer phone
| | | | | | | | | | | | | |
number
SOLUTIONS
Data - CORRECT ANSWER✔✔-raw processed facts or figures
| | | | | | |
Information - CORRECT ANSWER✔✔-data that has processed or interrupted
| | | | | | | |
Metadata - CORRECT ANSWER✔✔-data which describes or gives structure to
| | | | | | | | | |
other data
|
Data management - CORRECT ANSWER✔✔-the act of processing data (reading,
| | | | | | | | | |
adding, changing, or deleting data)
| | | |
CRUD - CORRECT ANSWER✔✔-the data management operations; create, read,
| | | | | | | | |
update, and delete | |
Database - CORRECT ANSWER✔✔-a collection of data, metadata and data
| | | | | | | | | |
management activities |
Query - CORRECT ANSWER✔✔-asking questions of data processing information
| | | | | | | |
DBMS - CORRECT ANSWER✔✔-software to facilitate the use of computerized
| | | | | | | | | |
databases
, Conceptual Model - CORRECT ANSWER✔✔-the global view of a database from
| | | | | | | | | | |
the user's perspective
| |
Logical Model - CORRECT ANSWER✔✔-a view of a database that is depended on
| | | | | | | | | | | | |
database model, but not specific implementation
| | | | |
Internal Model - CORRECT ANSWER✔✔-a view of a database as implemented
| | | | | | | | | |
External Model - CORRECT ANSWER✔✔-portions of a database implemented to
| | | | | | | | | |
facilitate the conceptual view
| | |
Physical Model - CORRECT ANSWER✔✔-how the database is implemented
| | | | | | | | |
through software, such as a DBMS
| | | | |
ARTC - CORRECT ANSWER✔✔-characteristics of data that make it useful;
| | | | | | | | | |
accurate, relevant, timely, and contextual
| | | |
Table - CORRECT ANSWER✔✔-a primary unit of storage in the relational model,
| | | | | | | | | | | |
2D structure consisting of rows and columns
| | | | | |
Relation - CORRECT ANSWER✔✔-A table with a column (or set of columns) for
| | | | | | | | | | | | |
which the data in those columns can be used to find one unique row
| | | | | | | | | | | | |
Column - CORRECT ANSWER✔✔-Represents a category of data in a relational
| | | | | | | | | | |
table. For example in a table of customers, this would be the customer phone
| | | | | | | | | | | | | |
number
