BCOR 2020 EXAM 2 Que & Answ
1. What are what-if models?: what if models are spreadsheets used for decision making;
mathematical and logic based models
2. Building good spreadsheet models: influence diagrams; building a mathemat- ical model;
spread sheet design and implementing the model in a spreadsheet
3. Data: raw facts; numbers, letters, etc; audio video, image
4. Information: a collection of data organized in such a away that they have value beyond the
facts themselves
5. Knowledge: awareness and understanding of a set of information and the ways it can be
made useful to support a task
6. Value of information: the value of information is directly linked to how decision makers
achieve organizational needs
7. Characteristics of Quality information: information should be accurate or com- plete
8. What is IS?: an information system is a single set of hardware, software, data- bases,
networks, people and procedure that collect, manipulate, store, and process data into
information
9. What are the three types of information systems: - Personal IS
- Group IS
- Enterprise IS
10.Value Chains: A series of activities that an organization performs to turn inputs into outputs
11.Supply Chain: key value chain in a manufacturing organization
12.What is a database?: an organized collection of data
13. What does DBMS stand for?: DBMS stands for data base management system
14.What is DBMS?: a group of programs that manipulate the database and provide an interface
between the database and its users and other application processes
15.Hierarchy of data: bit -> byte/characteristic -> field -> record -> file
16.byte: made up of 8 bits
17.field: name, number, or combination of characters that describes an aspect of a business
object or activity
18.record: a collection of related data fields
19.file: a collection of related records
20.Data entities: a person, place, or thing for which data is collected, stored, and maintained
21.Attributes: a characteristic of an entity
22.Keys: a field or set of fields that uniquely identifies the record
23.Data Item: the specific value of an attribute
1/
6
, BCOR 2020 EXAM 2 Que & Answ
24.The database approach: information systems share a pool of related data, offers the ability to
share data and information resources, a database management system is required
25.Data modeling: a diagram of data entities and their relationships
26.Relational database model: - a simple but highly useful way to organize data into collection
of two-dimensional tables called relations;
- columns - (vertical) represents an attribute of an entity
- rows - (horizontal) represents an entity
27.Database administration: skilled and trained information system professionals
28.What does the database administration do?: works with users to define their data needs,
applies database programming languages to craft a set of databases to meet those needs, tests
and evaluates databases, implements changes to improve their databases performances, &
assures that data is secure from unauthorized access
29.Big Data: extremely large and complex data collections
30.Characteristics of Big Data: volume, velocity, and variety
31.Challenges of Big Data: - how to choose what subset of the data to store
- where and how to store the data
- how to find the nuggets of data that are relevant to the decision making at hand
- how to derive value from the relevant data
- how to identify which data needs to be protected from unauthorized access
32.Data warehouses: a large database that collect business information from many sources
in the enterprise in support of management decision making
33.Data marts: a subset of a data warehouse that is used by small and medi-
um-sized businesses and departments within large companies to support decision making
34.Data lakes: takes a "store everything" approach to big data, saving all data in its raw and
unaltered form (AKA enterprise data hub)
35.What is a computer network?: The communications media, devices, and software
needed to connect two or more computer systems or devices
36.Network topology: the shape or structure of a network, including the arrange- ment of the
communications links and hardware devices on the network
37.Network Topology Types: - Star network
- Bus network
- Mesh network
38.Network types: 1. Personal Area Network (PAN)
2. Local Area Network (LAN)
3. Metropolitan Arean Network (MAN)
4. Wide Area Network (WAN)
2/
6
1. What are what-if models?: what if models are spreadsheets used for decision making;
mathematical and logic based models
2. Building good spreadsheet models: influence diagrams; building a mathemat- ical model;
spread sheet design and implementing the model in a spreadsheet
3. Data: raw facts; numbers, letters, etc; audio video, image
4. Information: a collection of data organized in such a away that they have value beyond the
facts themselves
5. Knowledge: awareness and understanding of a set of information and the ways it can be
made useful to support a task
6. Value of information: the value of information is directly linked to how decision makers
achieve organizational needs
7. Characteristics of Quality information: information should be accurate or com- plete
8. What is IS?: an information system is a single set of hardware, software, data- bases,
networks, people and procedure that collect, manipulate, store, and process data into
information
9. What are the three types of information systems: - Personal IS
- Group IS
- Enterprise IS
10.Value Chains: A series of activities that an organization performs to turn inputs into outputs
11.Supply Chain: key value chain in a manufacturing organization
12.What is a database?: an organized collection of data
13. What does DBMS stand for?: DBMS stands for data base management system
14.What is DBMS?: a group of programs that manipulate the database and provide an interface
between the database and its users and other application processes
15.Hierarchy of data: bit -> byte/characteristic -> field -> record -> file
16.byte: made up of 8 bits
17.field: name, number, or combination of characters that describes an aspect of a business
object or activity
18.record: a collection of related data fields
19.file: a collection of related records
20.Data entities: a person, place, or thing for which data is collected, stored, and maintained
21.Attributes: a characteristic of an entity
22.Keys: a field or set of fields that uniquely identifies the record
23.Data Item: the specific value of an attribute
1/
6
, BCOR 2020 EXAM 2 Que & Answ
24.The database approach: information systems share a pool of related data, offers the ability to
share data and information resources, a database management system is required
25.Data modeling: a diagram of data entities and their relationships
26.Relational database model: - a simple but highly useful way to organize data into collection
of two-dimensional tables called relations;
- columns - (vertical) represents an attribute of an entity
- rows - (horizontal) represents an entity
27.Database administration: skilled and trained information system professionals
28.What does the database administration do?: works with users to define their data needs,
applies database programming languages to craft a set of databases to meet those needs, tests
and evaluates databases, implements changes to improve their databases performances, &
assures that data is secure from unauthorized access
29.Big Data: extremely large and complex data collections
30.Characteristics of Big Data: volume, velocity, and variety
31.Challenges of Big Data: - how to choose what subset of the data to store
- where and how to store the data
- how to find the nuggets of data that are relevant to the decision making at hand
- how to derive value from the relevant data
- how to identify which data needs to be protected from unauthorized access
32.Data warehouses: a large database that collect business information from many sources
in the enterprise in support of management decision making
33.Data marts: a subset of a data warehouse that is used by small and medi-
um-sized businesses and departments within large companies to support decision making
34.Data lakes: takes a "store everything" approach to big data, saving all data in its raw and
unaltered form (AKA enterprise data hub)
35.What is a computer network?: The communications media, devices, and software
needed to connect two or more computer systems or devices
36.Network topology: the shape or structure of a network, including the arrange- ment of the
communications links and hardware devices on the network
37.Network Topology Types: - Star network
- Bus network
- Mesh network
38.Network types: 1. Personal Area Network (PAN)
2. Local Area Network (LAN)
3. Metropolitan Arean Network (MAN)
4. Wide Area Network (WAN)
2/
6
