Intro to Business Information Systems: Ch 6

Question 1

data granularity

Answer 1

refers to extent of detail within data (fine/detailed or coarse/abstract)

Question 2

Levels of organizational data

Answer 2

individual, department, enterprise

Question 3

Formats of organizational data

Answer 3

Document, Presentation, Spreadsheet, Database

Question 4

Granularities

Answer 4

Detail (Fine) - reports for a salesman, Summary - reports for all salespeople, Aggregate (Coarse) - reports across departments/organizations

Question 5

4 Primary traits of value of data

Answer 5

Data type, data timeliness, data quality, data governance

Question 6

transactional data

Answer 6

all data contained in a single business process/unit of work and its primary purpose is to support daily operational tasks

Question 7

analytical data

Answer 7

all organizational data, and primary purpose is to support performing of managerial analysis tasks

Question 8

real time data

Answer 8

immediate, up to date data

Question 9

real time systems

Answer 9

provide real time info in response to requests

Question 10

data inconsistency

Answer 10

when some data elements has different values

Question 11

data integrity

Answer 11

measure of quality of data

Question 12

high quality data

Answer 12

accurate, complete, consistent, timely, unique

Question 13

low quality data

Answer 13

missing, incomplete, inaccurate, wrong, duplicate

Question 14

data gap analysis

Answer 14

when company examines data to determine if can meet business expectations, while identifying possible data gaps or missing data

Question 15

data steward

Answer 15

responsible for ensuring policies/procedures are implemented across organizations and activities as a liaison between MIS department and business

Question 16

data stewardship

Answer 16

management and oversight of organizations data assets to help provide business users with high quality data that is easily accessible in consistent manner

Question 17

data governance

Answer 17

refers to overall management of availability, usability, integrity, and security of company data

Question 18

master data management

Answer 18

practice of gathering data and ensuring it is uniform, accurate, consistent, and complete including entities of customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated a ross organizational systems

Question 19

data validation

Answer 19

includes tests and evaluations used to determine compliance with data governance policies to ensure correctness of data

Question 20

database

Answer 20

maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)

Question 21

database management system (DBMS)

Answer 21

creates, reads, updates, and deletes (CRUD) data in a database while controlling access and security

Question 22

structured query language (SQL)

Answer 22

asks users to write lines of code to answer questions against a database

Question 23

Query by example (QBE) tool

Answer 23

helps users graphically design answers to questions against a database

Question 24

Data dictionary

Answer 24

compiles all metadata about data elements in the data model

Question 25

data element (data field)

Answer 25

logical data structures that detail relationships among data elements by using graphics or pictures

Question 26

metadata

Answer 26

provides details about data

Question 27

relational database model

Answer 27

stores data in form of logically related, 2D tables

Question 28

relational database management system

Answer 28

allows users to create, read, update, and delete (CRUD) data in relational database

Question 29

entity

Answer 29

table that stores data about a person, place, thing, transaction, or event

Question 30

attributes (columns and fields)

Answer 30

data elements associated with an entity

Question 31

record

Answer 31

collection of related data elements

Question 32

primary key

Answer 32

field or group of fields that uniquely identifies a given entity in a table

Question 33

foreign key

Answer 33

primary key of one table that appears as an attribute in another table and acts to provide logical relationship between two tables

Question 34

Business advantages of relational database

Answer 34

increased flexibility, increased scalability and performance, reduced data redundancy, increased data integrity (quality), increased data security

Question 35

physical view of data

Answer 35

physical storage of data on storage device such as hard disk

Question 36

logical view of data

Answer 36

focuses on how users logically access data to meet particular business needs

Question 37

data latency

Answer 37

time it takes for data to be stored or retrieved

Question 38

Business rule

Answer 38

defines how company performs certain aspects of business where the results are yes or no or true or false

Question 39

Data redundancy

Answer 39

duplication of data or storage of same data in multiple places

Question 40

data integrity

Answer 40

measure the quality of data

Question 41

integrity constraints

Answer 41

rules that help ensure the quality of data

Question 42

relational integrity constraints

Answer 42

rules that enforce basic or fundamental information based constraints

Question 43

business critical integrity constraints

Answer 43

enforce rules vital to organizations success, these require more insight and knowledge than relational integrity constraints

Question 44

identity management

Answer 44

broad administration area that deals with identifying individuals in system and controlling their access to resources in that system by associating user rights or restrictions with established identity