BCOR 2205 Info MGMT Zikmund Final
Exam Questions With Correct Answers
Internal Data
|
Data that is procured and consolidated from different branches within
| | | | | | | | | |
your organization
|
External Data |
Data that is not collected by your organization (can be public or bought)
| | | | | | | | | | | |
The Four Primary Traits of the Value of data
| | | | | | | |
data type, data timeliness, data quality, data governance
| | | | | | |
Data base
|
Maintains data about various types of objects (inventory),events
| | | | | | | |
(transactions), people (employees), and places (warehouses) as well as
| | | | | | | | |
data about data (metadata)
| | |
,Data-Based Management System (DBM) | | |
Allows users to create, read, update, and delete data in a relational
| | | | | | | | | | | |
database
relational database |
contains many tables of data that relate to one another through special
| | | | | | | | | | | |
key fields
|
flat file database
| |
contains a single table of data (ex: zip file)
| | | | | | | |
CSVs
comma separated values
| |
Entity Relationship (ER) modeling
| | |
,the process of designing a database by organizing data entities to be
| | | | | | | | | | | |
used and identifying the relationships among them
| | | | | |
ER Modeling: "Entities"
| |
a person, place, think, transaction, or event about which data is stored;
| | | | | | | | | | | |
entity describes a set of attributes
| | | | |
ER Modeling: "Relationships"
| |
an association among entities
| | |
Attributes (fields, columns) | |
the data elements associated with an entity
| | | | | |
attribute instance |
a single value of an attribute for an instance of an entity
| | | | | | | | | | |
Primary key |
, A field (or group of fields) that uniquely identifies a given entity in a
| | | | | | | | | | | | | |
table (ex: SSN/customer ID)
| | |
Foreign Key |
A primary key of one table that appears as an attribute in another table
| | | | | | | | | | | | | |
and acts to provide a logical relationship between the two tables
| | | | | | | | | |
Entities/Attributes and Primary/Foreign Keys | | |
Access level |
Determines who has access to the different types of data
| | | | | | | | |
Access control
|
Determines types of user access, such as read-only access
| | | | | | | |
limitations of data from databases
| | | |
Inconsistent, poor quality, etc | | |
Exam Questions With Correct Answers
Internal Data
|
Data that is procured and consolidated from different branches within
| | | | | | | | | |
your organization
|
External Data |
Data that is not collected by your organization (can be public or bought)
| | | | | | | | | | | |
The Four Primary Traits of the Value of data
| | | | | | | |
data type, data timeliness, data quality, data governance
| | | | | | |
Data base
|
Maintains data about various types of objects (inventory),events
| | | | | | | |
(transactions), people (employees), and places (warehouses) as well as
| | | | | | | | |
data about data (metadata)
| | |
,Data-Based Management System (DBM) | | |
Allows users to create, read, update, and delete data in a relational
| | | | | | | | | | | |
database
relational database |
contains many tables of data that relate to one another through special
| | | | | | | | | | | |
key fields
|
flat file database
| |
contains a single table of data (ex: zip file)
| | | | | | | |
CSVs
comma separated values
| |
Entity Relationship (ER) modeling
| | |
,the process of designing a database by organizing data entities to be
| | | | | | | | | | | |
used and identifying the relationships among them
| | | | | |
ER Modeling: "Entities"
| |
a person, place, think, transaction, or event about which data is stored;
| | | | | | | | | | | |
entity describes a set of attributes
| | | | |
ER Modeling: "Relationships"
| |
an association among entities
| | |
Attributes (fields, columns) | |
the data elements associated with an entity
| | | | | |
attribute instance |
a single value of an attribute for an instance of an entity
| | | | | | | | | | |
Primary key |
, A field (or group of fields) that uniquely identifies a given entity in a
| | | | | | | | | | | | | |
table (ex: SSN/customer ID)
| | |
Foreign Key |
A primary key of one table that appears as an attribute in another table
| | | | | | | | | | | | | |
and acts to provide a logical relationship between the two tables
| | | | | | | | | |
Entities/Attributes and Primary/Foreign Keys | | |
Access level |
Determines who has access to the different types of data
| | | | | | | | |
Access control
|
Determines types of user access, such as read-only access
| | | | | | | |
limitations of data from databases
| | | |
Inconsistent, poor quality, etc | | |
