Question 1

Ralph is looking at a table with the following key fields:
Order ID	Customer ID
2156	428
2157	873
2158	201
2159	428
2160	043
2161	195
This table:

Accepted Answer

A) Is table is not fully normalized 
B) Is in third normal form 
C) Has a primary key of customer id 
D) Has a foreign key of order id 
E) Cannot be fully evaluated from the data provided 
A) Is table is not fully normalized 
B) Is in third normal form 
C) Has a primary key of customer id 
D) Has a foreign key of order id 
E) Cannot be fully evaluated from the data provided

Question 2

The purpose of creating physical ERDs is to:

Accepted Answer

A) Show implementation details and to explain more about the 'how' of the final system 
B) Normalize the database to third normal form 
C) Do a new technology analysis 
D) Drive the users nuts 
E) Help junior analysts to find the transactions between systems 
A) Show implementation details and to explain more about the 'how' of the final system 
B) Normalize the database to third normal form 
C) Do a new technology analysis 
D) Drive the users nuts 
E) Help junior analysts to find the transactions between systems

Question 3

Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

Accepted Answer

A) An object database 
B) A relational database 
C) A red-green database 
D) A tree database 
E) A spanning database 
A) An object database 
B) A relational database 
C) A red-green database 
D) A tree database 
E) A spanning database

Question 4

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

Accepted Answer

A) ERD master 
B) DFD master 
C) Denormalization 
D) Pop-up menu 
E) CASE 
A) ERD master 
B) DFD master 
C) Denormalization 
D) Pop-up menu 
E) CASE

Question 5

Which is not a common data type?

Accepted Answer

A) Character 
B) Text 
C) Integer 
D) Date 
E) Video 
A) Character 
B) Text 
C) Integer 
D) Date 
E) Video

Question 6

Technical feasibility might play a major part in selecting a database system (for example,if a project group and development group are very familiar with relational databases,it might be best to stay with relational databases).

Accepted Answer

A) True 
 B)False

Question 7

Legacy databases might include ________ and ______________

Accepted Answer

A) Master files and transaction files 
B) Audit files and look-up files 
C) Hierarchical databases and network databases 
D) Tree databases and leaf databases 
E) Red databases and Green databases 
A) Master files and transaction files 
B) Audit files and look-up files 
C) Hierarchical databases and network databases 
D) Tree databases and leaf databases 
E) Red databases and Green databases

Question 8

A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.

Accepted Answer

A) True 
 B)False

Question 9

A relational database that is used extensively in data warehousing is a multidimensional database.

Accepted Answer

A) True 
 B)False

Question 10

Changing the logical data model into a physical data model is one of the activities of data storage design.

Accepted Answer

A) True 
 B)False

Question 11

What are the steps in moving from logical to physical data models?

Accepted Answer

Step 1 - change entities to ta

Ralph is looking at a table with the following key fields: Order ID Customer ID 2156 428 2157 873 2158 201 2159 428 2160 043 2161 195 This table:

The purpose of creating physical ERDs is to:

Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

Which is not a common data type?

Technical feasibility might play a major part in selecting a database system (for example,if a project group and development group are very familiar with relational databases,it might be best to stay with relational databases).

Legacy databases might include and ______

A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.

A relational database that is used extensively in data warehousing is a multidimensional database.

Changing the logical data model into a physical data model is one of the activities of data storage design.

What are the steps in moving from logical to physical data models?

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

Ralph is looking at a table with the following key fields: Order ID Customer ID 2156 428 2157 873 2158 201 2159 428 2160 043 2161 195 This table:

The purpose of creating physical ERDs is to:

Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

Which is not a common data type?

Technical feasibility might play a major part in selecting a database system (for example,if a project group and development group are very familiar with relational databases,it might be best to stay with relational databases).

Legacy databases might include ________ and ______________

A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.

A relational database that is used extensively in data warehousing is a multidimensional database.

Changing the logical data model into a physical data model is one of the activities of data storage design.

What are the steps in moving from logical to physical data models?

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

Legacy databases might include and ______