Exam 2- Chapters 5 and 12 Flashcards
T or F: The process of acquiring, keeping, and managing data is becoming increasingly difficult.
True
All information technology applications require:
data
Data should be of high quality, meaning it should be what 7 things?
- Accurate
- Complete
- Timely
- Consistent
- Accessible
- Relevant
- Concise
What are the 8 difficulties of managing data?
- The amount of data is increasing with time.
- Data is frequently stored in numerous servers and locations
- Data are generated from multiple resources
- New data is constantly being developed, and this data must be managed; data also becomes less current over time
- Data are subject to data rot
- Data security, quality, and integrity are easily jeopardized.
- Federal regulations complicate data management and companies are drowning in data
- Big Data
Inconsistent data prevents a company from what?
Developing a unified view of core business information
a collection of data held by one group that is not easily accessible by other groups
data silo
One major method to remove data silos is through ________ ________ _________.
cloud data management
What are three issues with data silo’s?
- Hinder the process of gaining actionable insights from organizational data
- Create barriers to an overall view of the enterprise and its data
- Delay digital transformation efforts
Data that are continuously generated by point-of-sale systems, clickstream data, social media, and sensors
Data streams
Point of Sale systems collect data in _____ _____.
real time
the information that is collected during the customer sales transaction (like name, product identification number, unit price of each item, etc.)
point-of-sale data
What are the four types of data streams?
- Point-of-Sale Data
- Clickstream Data
- Social Media Data
- Sensor Data
the data that visitors and customers produce when they visit a website and click on hyperlinks
clickstream data
What type of data stream would this be: data that includes shares, likes and dislikes, ratings, reviews, recommendations, and comments.
social media data
a system in which any object, natural or manmade, contains internal or external wireless sensor(s) that communicate with each other without human interaction. What type of data stream does this relate to?
The Internet of Things (IoT); sensor data
monitors and reports data on physical and environmental conditions around it, such as temperature, sound, pressure, vibration, and movement
sensor data
What can sensors do?
Control physical systems, such as opening and closing a valve and adjusting the fuel mixture in your car
T or F: Being able to collect massive amounts of data from many different sources is a double-edged sword.
True
problems with the media on which the data are stored
data rot
What are the two aspects of data rot?
- Over time, temp, humidity, and exposure to light can cause physical problems with storage media and make it difficult to access data
- Finding the machines needed to access the data can be difficult
What three things are critical for data, yet easily jeopardized?
Security, quality, and integrity
Today capturing data is (hard/easy) and storing that data is relatively (expensive/inexpensive).
easy; inexpensive
An increasing number of companies are turning to ________ to help them make sense of their data.
Enigma
a data management and business intelligence company that specializes in data integration and analytics.
Enigma
Enigma notes that it has always been difficult for banks to share data, principally due to ________ ______.
privacy concerns
a set of programs that provide users with tools to create and manage a database
database management system (DMS)
the process of accepting liability under an insurance policy, thus guaranteeing payment in case loss or damage occurs
underwriting
T or F: Databases and database management systems are essential to all areas of business, so they must be carefully managed.
True
Why do we focus on the RELATIONAL database model?
Because it is popular and easy to use
Database models, like the hierarchical and network models, are the responsibility of the _____ _____ and are NOT used by ___________ ________.
MIS function; organizational employees
What are two examples of relational databases?
- Microsoft Access
- Oracle
The relational database model is based on the concept of _____-________ tables.
two-dimensional
A relational database is usually designed with which of the following:
1. a big table that contains all of the records and attributes
2. a number of related tables
- a number of related tables
Relational database rows contain ____ and columns contain _____.
records; attributes
A key to designing an effective database is the _____ ______.
data model
a diagram that represents entities in the database and their relationships
data model
a person, place, a thing, or an event– such as a customer, an employee, or a product– about which an organization maintains information.
entity
Entities can typically be identified in the user’s _____ _____. A ______ generally describes an entity.
work environment; record
each row in a relational table, which is a specific, unique representation of the entity
instance of an entity
A student in a universities student database would be an ______. A particular student would be an ______ of the student entity.
entity; instance
each characteristic or quality of a particular entity
attribute
T or F: an example of an entity attribute of a customer would be customer name
True
T or F: entity attribute of a product could be product color
True
one field that uniquely identifies a record so that it can be retrieved, updated and sorted
primary key
What’s an example of a primary key?
a unique student id number
another field that has some identifying information but typically does not identify the record with complete accuracy
secondary key
What’s an example of a secondary key?
a students major
a field (or group of fields) in one table that uniquely identifies a row of another table; used to establish and enforce a link between two tables
foreign key