MIS 180 SDSU FINAL STUDY GUIDE
information granularity - Answers :the extent of detail within the information (fine and
detailed or coarse and abstract)
real-time information - Answers :immediate, up-to-date information
real-time system - Answers :provides real-time information in response to requests
information inconsistency - Answers :occurs when the same data element has different
values
information integrity issue - Answers :occurs when a system produces incorrect,
inconsistent, or duplicate data
data gap analysis - Answers :occurs when a company examines its data to determine if
it can meet business expectations, while identifying possible data gaps or where
missing data might exist
data stewardship - Answers :the management and oversight of an organization's data
assets to help provide business users with high-quality data that is easily accessible in a
consistent manner
data steward - Answers :responsible for ensuring the policies and procedures are
implemented across the organization and acts as a liaison between the MIS department
and the business
data governance - Answers :refers to the overall management of the availability,
usability, integrity, and security of company data
master data management (MDM) - Answers :the practice of gathering data and
ensuring that it is uniform, acurate, consistent and complete
including such entities as customers, suppliers, products, sales, employees, and other
critical entities that are commonly integrated across organizational systems
data validation - Answers :includes the tests and evaluations used to determine
compliance with data governance policies to ensure correctness of data
database - Answers :maintains information about various types of object (inventory),
events (transactions), people (employees), and places (warehouses)
database management system (DBMS) - Answers :creates, reads, updates, and deletes
data in a database while controlling access and security
query-by-example (QBE) tool - Answers :helps useers graphically design the answer to
a question against a database
, structured query language (SQL) - Answers :users write lines of code to answer
questions against a database
data element (data field) - Answers :smallest or basic unit of information
data models - Answers :logical data structures that detail the relationships among data
elements using graphics or pictures
metadata - Answers :details about data
relational database model - Answers :stores info in the form of logicallt related two-
dimensional tables
relational database management system - Answers :allows users to create, read,
update, and delete data in a relational database
entity - Answers :stores info about a person, place, thing, transaction, or event
attribute - Answers :the data elements associated with an entity
record - Answers :a collection of related data elements
a primary key - Answers :a field (or group of fields) that uniquely identifies a given
record in a table
foreign key - Answers :a primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between two tables
physical view of information - Answers :the physical storage of info on a storage device
logical view of information - Answers :shows how individual users logically access
information to meet their own particular business needs
data latency - Answers :the time it takes for data to be stored or retrieved
information redundancy - Answers :the duplication of data, or the storage of the same
data in mulitple places
information integrity - Answers :a measure of the quality of info
integrity constraint - Answers :rules that help ensure the quality of info
relational integrity constraint - Answers :rules that enforce basic and fundamental
information-based constraints
information granularity - Answers :the extent of detail within the information (fine and
detailed or coarse and abstract)
real-time information - Answers :immediate, up-to-date information
real-time system - Answers :provides real-time information in response to requests
information inconsistency - Answers :occurs when the same data element has different
values
information integrity issue - Answers :occurs when a system produces incorrect,
inconsistent, or duplicate data
data gap analysis - Answers :occurs when a company examines its data to determine if
it can meet business expectations, while identifying possible data gaps or where
missing data might exist
data stewardship - Answers :the management and oversight of an organization's data
assets to help provide business users with high-quality data that is easily accessible in a
consistent manner
data steward - Answers :responsible for ensuring the policies and procedures are
implemented across the organization and acts as a liaison between the MIS department
and the business
data governance - Answers :refers to the overall management of the availability,
usability, integrity, and security of company data
master data management (MDM) - Answers :the practice of gathering data and
ensuring that it is uniform, acurate, consistent and complete
including such entities as customers, suppliers, products, sales, employees, and other
critical entities that are commonly integrated across organizational systems
data validation - Answers :includes the tests and evaluations used to determine
compliance with data governance policies to ensure correctness of data
database - Answers :maintains information about various types of object (inventory),
events (transactions), people (employees), and places (warehouses)
database management system (DBMS) - Answers :creates, reads, updates, and deletes
data in a database while controlling access and security
query-by-example (QBE) tool - Answers :helps useers graphically design the answer to
a question against a database
, structured query language (SQL) - Answers :users write lines of code to answer
questions against a database
data element (data field) - Answers :smallest or basic unit of information
data models - Answers :logical data structures that detail the relationships among data
elements using graphics or pictures
metadata - Answers :details about data
relational database model - Answers :stores info in the form of logicallt related two-
dimensional tables
relational database management system - Answers :allows users to create, read,
update, and delete data in a relational database
entity - Answers :stores info about a person, place, thing, transaction, or event
attribute - Answers :the data elements associated with an entity
record - Answers :a collection of related data elements
a primary key - Answers :a field (or group of fields) that uniquely identifies a given
record in a table
foreign key - Answers :a primary key of one table that appears as an attribute in another
table and acts to provide a logical relationship between two tables
physical view of information - Answers :the physical storage of info on a storage device
logical view of information - Answers :shows how individual users logically access
information to meet their own particular business needs
data latency - Answers :the time it takes for data to be stored or retrieved
information redundancy - Answers :the duplication of data, or the storage of the same
data in mulitple places
information integrity - Answers :a measure of the quality of info
integrity constraint - Answers :rules that help ensure the quality of info
relational integrity constraint - Answers :rules that enforce basic and fundamental
information-based constraints
