Question 1

Sometimes in data storage design there will need to be trade-offs between storage efficiency and processing speed and efficiency.

Accepted Answer

A) True 
 B)False

Question 2

Transaction processing systems and decision support systems will generally have very different data storage needs.

Accepted Answer

A) True 
 B)False

Question 3

DB2 is a enterprise database management system.

Accepted Answer

A) True 
 B)False

Question 4

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Accepted Answer

A) True 
 B)False

Question 5

Systems that support decision making will probably:

Accepted Answer

A) Do a lot of updating of data 
B) Be transaction processing systems 
C) Be audit files 
D) Use Gantt charts 
E) Usually just read data - and often in ad hoc ways 
A) Do a lot of updating of data 
B) Be transaction processing systems 
C) Be audit files 
D) Use Gantt charts 
E) Usually just read data - and often in ad hoc ways

Question 6

Which of the following is NOT a file type described in the textbook?

Accepted Answer

A) History files 
B) Audit files 
C) Look-up files 
D) Algebra files 
E) Transaction files 
A) History files 
B) Audit files 
C) Look-up files 
D) Algebra files 
E) Transaction files

Question 7

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

Accepted Answer

A) True 
 B)False

Question 8

The most popular kind of database for applications development today is the relational database.

Accepted Answer

A) True 
 B)False

Question 9

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

Accepted Answer

CRUD stands for create,read,update and d

Question 10

Systems to support decision making generally need to update data frequently with a large volume of data.

Accepted Answer

A) True 
 B)False

Question 11

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

Accepted Answer

An end-user database can reside on the e

Question 12

When moving from logical data models to physical data models,you should update your CRUD matrix.

Accepted Answer

A) True 
 B)False

Question 13

Jasmine is an example of an object-oriented database system.

Accepted Answer

A) True 
 B)False

Question 14

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

Accepted Answer

A) True 
 B)False

Question 15

The data storage design activity is done in which phase of the Systems Development Life Cycle?

Accepted Answer

A) Planning 
B) Analysis 
C) Design 
D) Implementation 
E) Evaluation 
A) Planning 
B) Analysis 
C) Design 
D) Implementation 
E) Evaluation

Question 16

FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

Accepted Answer

A) Executive support system (ESS) 
B) Barcode processing system (BPS) 
C) Management information system (MIS) 
D) Transaction Processing system (TPS) 
E) A grocery store processing system (GSPS) 
A) Executive support system (ESS) 
B) Barcode processing system (BPS) 
C) Management information system (MIS) 
D) Transaction Processing system (TPS) 
E) A grocery store processing system (GSPS)

Question 17

If you were considering a media rich database (like the example of Tune Source in the textbook),what type of database organization might be best and why?

Accepted Answer

Object Databases would be a wi

Question 18

Most relational database systems support:

Accepted Answer

A) Referential integrity 
B) Pop-up menus 
C) Customizable user-interface colors and graphics 
D) The 'three-clicks' rule 
E) Broadband connectivity 
A) Referential integrity 
B) Pop-up menus 
C) Customizable user-interface colors and graphics 
D) The 'three-clicks' rule 
E) Broadband connectivity

Question 19

Generally,the best way to optimize data storage for efficiency is:

Accepted Answer

A) Normalization B) Redundancy C) Null values D) Insertion of hard returns after all fields E) Through minimizing the data to be collected to no more than seven fields per table A) Normalization B) Redundancy C) Null values D) Insertion of hard returns after all fields E) Through minimizing the data to be collected to no more than seven fields per table

Question 20

Files are paper files that have been scanned into PDF files for quicker access.

Accepted Answer

A) True 
 B)False

Sometimes in data storage design there will need to be trade-offs between storage efficiency and processing speed and efficiency.

Transaction processing systems and decision support systems will generally have very different data storage needs.

DB2 is a enterprise database management system.

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Systems that support decision making will probably:

Which of the following is NOT a file type described in the textbook?

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

The most popular kind of database for applications development today is the relational database.

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

Systems to support decision making generally need to update data frequently with a large volume of data.

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

When moving from logical data models to physical data models,you should update your CRUD matrix.

Jasmine is an example of an object-oriented database system.

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

The data storage design activity is done in which phase of the Systems Development Life Cycle?

FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

If you were considering a media rich database (like the example of Tune Source in the textbook),what type of database organization might be best and why?

Most relational database systems support:

Generally,the best way to optimize data storage for efficiency is:

Files are paper files that have been scanned into PDF files for quicker access.

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters

Exam 11: Data Storage Design

Sometimes in data storage design there will need to be trade-offs between storage efficiency and processing speed and efficiency.

Transaction processing systems and decision support systems will generally have very different data storage needs.

DB2 is a enterprise database management system.

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Systems that support decision making will probably:

Which of the following is NOT a file type described in the textbook?

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

The most popular kind of database for applications development today is the relational database.

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

Systems to support decision making generally need to update data frequently with a large volume of data.

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

When moving from logical data models to physical data models,you should update your CRUD matrix.

Jasmine is an example of an object-oriented database system.

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

The data storage design activity is done in which phase of the Systems Development Life Cycle?

FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

If you were considering a media rich database (like the example of Tune Source in the textbook),what type of database organization might be best and why?

Most relational database systems support:

Generally,the best way to optimize data storage for efficiency is:

Files are paper files that have been scanned into PDF files for quicker access.

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters