Deck 5: Data and Knowledge Management

Question 1

Modality is the minimum number of times an instance of one entity can be associated with an instance of a related entity.

Answer 1

True

Question 2

A relational database is one big table that contains all the company's records.

Answer 2

False

Question 3

Data rot refers to the quality of the data itself.

Answer 3

False

Question 4

The secondary key is a field that identifies a record with complete uniqueness.

Question 5

Information technologies and systems support organizations in managing data, when this data is managed properly; it becomes information and then knowledge.

Question 6

The biggest problem today is gathering data and then using it properly.

Question 7

Managing the massive amounts of data that are critical to organizational success comes at a huge cost.

Question 8

Master data are a set of core data that span all of an enterprise's information systems.

Question 9

It is important for applications and data to be dependent on each other.

Question 10

You would be an instance of your university's STUDENT class.

Question 11

For the following entity-relationship diagram, the Student entity would have the foreign key.

Computer
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_1.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_2.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_3.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_4.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_5.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_6.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_7.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_8.jpg

Question 12

An attribute is any characteristic or quality that describes a particular entity.

Question 13

Managing data is easier nowadays since there is so much of it.

Question 14

A negative value for a student's grade point average is an example of a data integrity problem.

Question 15

After the data is stored in your organization's databases, it must be accessible to users in a data warehouse in order to help your organization to make decisions.

Question 16

The relational database model is based on the concept of three-dimensional tables.

Question 17

Secondary keys have some identifying information but do not identify a file with complete accuracy.

Question 18

Entity-relationship diagrams are documents that show the primary and secondary keys associated with a conceptual data model.

Question 19

An entity is a person, place, thing, or event about which information is maintained.

Question 20

Data governance is an approach to managing functional area information systems.

Question 21

Which of the following has (have)the broadest impact on an organization?

A)Decisions about hardware.
B)Decisions about software.
C)Decisions about data.
D)Both "decisions about hardware" and "decisions about software."
E)All of these have an equal impact.

Question 22

Master data are generated and captured by operational systems.

Question 23

Refer to Case 5.1 Data Problems at Target Canada. In order for SAP ERP system to work properly, data needs to be:

A)accurate.
B)managed properly.
C)contain RFID information.
D)reenginered.
E)All of the above.

Question 24

In a data warehouse, existing data are constantly purged as new data come in.

Question 25

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Question 26

Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

Question 27

Tacit knowledge is the more objective, rational, and technical types of knowledge.

Question 28

The data dictionary stores definitions of data elements, business functions that use the data elements, formats of the data elements, information on each attribute of an element and how the attribute should be updated.

Question 29

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge.

Question 30

A data mart can be implemented more quickly than a data warehouse.

Question 31

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

Question 32

It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________.

A)Data degradation
B)Data rot
C)Data security
D)Scattered data

Question 33

Knowledge is information in action.

Question 34

An organization's data warehouse generally maintains its operational data.

Question 35

Which of the following is NOT a problem with Big Data?

A)Gathering data
B)Privacy
C)Security
D)Decision-making

Question 36

A data mart is a low-cost, scaled-down version of a data warehouse.

Question 37

When you start a job, you are given an employee handbook which contains the company's tacit knowledge.

Question 38

Which of the following is not a source for external data?

A)Commercial databases
B)Corporate databases
C)Corporate websites
D)Clickstream data
E)Government reports

Question 39

Online analytical processing (OLAP)involves the analysis of accumulated data by end users.

Question 40

Data marts are designed for the end-user needs in a strategic business unit or department.

Question 41

Data ___________ ensures data meets system constraints.

A)Consistency
B)Independence
C)Integrity
D)Security

Question 42

Which of the following is not a reason why managing data is difficult over time?

A)New systems are developed.
B)The media the data are stored on becomes problematic.
C)New sources of data are created.
D)The amount of data increases exponentially.
E)All of these are reasons why managing data is difficult over time.

Question 43

_____ occurs when the same data are stored in many places.

A)Data isolation
B)Data integrity
C)Data consistency
D)Data redundancy
E)Application/Data dependence

Question 44

_____ occurs when various copies of the data agree.

A)Data isolation
B)Data integrity
C)Data consistency
D)Data redundancy
E)Application/Data dependence

Question 45

A(n)_____ is a logical grouping of related records.

A)Byte
B)Field
C)Record
D)File
E)Database

Question 46

_____ occurs when applications cannot access data associated with other applications.

A)Data isolation
B)Data integrity
C)Data consistency
D)Data redundancy
E)Application/Data dependence

Question 47

For the following entity-relationship diagram, the attributes you would NOT expect to see in the Computer entity are:
Computer
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_10.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_11.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_12.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_13.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_14.jpg
Student
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_15.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_16.jpg
C:\Users\USER\Desktop\TB5445,Introduction to Information Systems 4th Canadian Edition by R. Kelly Rainer\Images\C3230 (5)_17.jpg

A)manufacturer.
B)type (laptop or desktop).
C)memory size.
D)disk size.
E)student's dorm room.

Question 48

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation?

A)The entities Customer and Order have a one to many relationship.
B)The entities Customer and Order have a many to many relationship.
C)The entities Customer and Jewelry Item have a one to many relationship.
D)The entities Order and Jewelry Item have a one to many relationship.
E)The entities Order and Jewelry Item have a many to many relationship.

Question 49

Not including alphabetic characters in a Social Security Number field is an example of _____.

A)Data isolation.
B)Data integrity.
C)Data consistency.
D)Data redundancy.
E)Application/data dependence.

Question 50

A(n)_____ is a logical grouping of characters into a word, a small group of words, or a complete number.

A)Byte
B)Field
C)Record
D)File
E)Database

Question 51

You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

A)Data redundancy
B)Data inconsistency
C)Data isolation
D)Data security
E)Data dependence

Question 52

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

A)Primary key in Student entity
B)Primary key in Course entity
C)Its own primary key.
D)Primary key made up of the primary keys in Student entity and Course entity
E)It doesn't need a primary key.

Question 53

A(n)_____ is a logical grouping of related fields.

A)Byte
B)Field
C)Record
D)File
E)Database

Question 54

In the data hierarchy, the smallest element is the _____.

A)Record
B)Bit
C)Byte
D)Character
E)File

Question 55

In Canada, Bill 198 legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

A)IT policies
B)HR rules
C)financial controls
D)sales goals

Question 56

A _______ is eight ________.

A)bit, digits
B)Byte, characters
C)Bit, bytes
D)Byte, bits

Question 57

Place the following members of the data hierarchy in their correct order:

A)Bit - byte - field - record - database - file
B)Bit - field - byte - record - file - database
C)Byte - bit - record - field - database
D)Bit - byte - field - record - file - database
E)Bit - record - field - byte - file - database

Question 58

The amount of data we collect is ____________ over time, making it ________ difficult to manage data.

A)Decreasing, less
B)Decreasing, more
C)Increasing, less
D)Increasing, more

Question 59

Data ___________ ensures applications cannot access data associated with other applications.

A)Hermitting
B)Inconsistency
C)Isolation
D)Redundancy

Question 60

Data __________ is a problem minimized by databases.

A)Independence
B)Integrity
C)Isolation
D)Security

Question 61

In a database, the primary key field is used to _____.

A)Specify an entity
B)Create linked lists
C)Identify duplicated data
D)Uniquely identify a record
E)Uniquely identify an attribute

Question 62

A standardized language used to search for data is _____.

A)MS-Access
B)Oracle
C)Query-by-example language
D)Structured query language
E)Data-manipulation language

Question 63

Normalized data occurs when attributes in the table depend only on the _______.

A)Data dictionary
B)Primary key
C)Record information
D)Secondary key

Question 64

The data in a data warehouse have which of the following characteristics?

A)They are organized by subject.
B)They are coded in different formats.
C)They are updated in real time.
D)They are typically retained for a defined, but limited, period of time.
E)They are organized in a hierarchical structure.

Question 65

_____________ reduces a relational database to its most streamlined form.

A)A data dictionary
B)A database management system
C)Normalization
D)Streamlining

Question 66

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

A)Primary keys
B)Secondary keys
C)Duplicate keys
D)Attribute keys
E)Record keys

Question 67

A database management system is primarily a(n)_____.

A)File-handling program
B)Data-modeling program
C)Interface between applications and a database
D)Interface between data and a database
E)Interface between queries and a database

Question 68

A(n)_____ represents a single character, such as a letter, number, or symbol.

A)Byte
B)Field
C)Record
D)File
E)Database

Question 69

_____ is a method for analyzing and reducing a relational database to its most streamlined form.

A)Structured query
B)Normalization
C)Query by example
D)Joining
E)Relational analysis

Question 70

Data dictionaries provide which of the following advantages to the organization?

A)They reduce data inconsistency.
B)They enable faster program development.
C)They make it easier to modify data and information.
D)Both "They enable faster program development." and "They make it easier to modify data and information."
E)All of these

Question 71

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

A)One-to-one
B)One-to-many
C)Many-to-one
D)Many-to-many
E)Some-to-many

Question 72

As an individual student in your university's student database, you are a(n)_____ of the STUDENT class.

A)Instance
B)Individual
C)Representative
D)Entity
E)Relationship

Question 73

__________________ allows users to perform complicated searches by using relatively simple statements or keywords.

A)DBMS
B)QBE
C)SQL
D)SSK

Question 74

In a relational database, every row represents a(n)_____.

A)File
B)Record
C)Attribute
D)Primary key
E)Secondary key

Question 75

In a university's relational database, the student record contains information regarding the student's last name. The last name is a(n):

A)Attribute.
B)Entity.
C)Primary key.
D)Object.
E)File.

Question 76

When data are normalized, attributes in the table depend only on the _____.

A)Secondary key
B)Common attribute
C)Primary key
D)Common row
E)Common record

Question 77

Data dictionaries perform all of the following functions except:

A)Providing information on each record.
B)Providing information on why attributes are needed in the database.
C)Defining the format necessary to enter data into the database.
D)Providing information on the name of each attribute.
E)Providing information on how often attributes should be updated.

Question 78

_____ tell the database management system which records are joined with others in related tables.

A)Primary keys
B)Secondary keys
C)Common attributes
D)Common files
E)Common fields

Question 79

_______________ uses drag-and-drop features to search a database.

A)DBMS
B)QBE
C)SQL
D)DDF

Question 80

In the relational database model, related tables can be joined when they contain common _____.

A)Primary keys
B)Rows
C)Records
D)Columns
E)Files