Question 1

Perry mentions that data in a file processing system may be repeated in several different files. He points out that problems can arise if updates to the data are not applied in every file. What is the name of this type of problem?
A) a data redundancy problem
B) a data integrity problem
C) a data modeling problem
D) a data rigidity problem

Accepted Answer

This is a data integrity problem because the data is not consistent across all files, leading to potentially incorrect or inconsistent results. Data redundancy (A) refers to the storage of the same data in multiple locations or files, and while it can contribute to data integrity problems, it is not the specific issue described in the question. Data modeling (C) and data rigidity (D) are not relevant to the scenario described.

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Kind of storage that refers to information as seen through a user's eyes, regardless of how or where the information actually is organized or stored.
A)UML
B)cardinality
C)secondary key
D)data mining
E)orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Accepted Answer

This is referring to logical data storage, where the organization of the data reflects how a user would think about and access it, as opposed to physical storage which refers to the physical medium or location where the data is stored.

Question 3

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?
A) candidate key
B) concatenated key
C) foreign key
D) secondary key

Accepted Answer

The answer of Malia asks if it is possible to...

Question 4

List at least 6 guidelines for developing a code.

Accepted Answer

The answer of List at least 6 guidelines for developing...

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A widely used method of visualizing and documenting software systems design.
A)UML
B)cardinality
C)secondary key
D)data mining
E)orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Accepted Answer

UML (Unified Modeling Language) is a widely used method of visualizing and documenting software systems design. It consists of a set of diagrams and symbols that represent various aspects of the system being designed.

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-As an analyst, you must understand this in order to create a data design that accurately reflects all relationships among system entities.
A)UML
B)cardinality
C)secondary key
D)data mining
E)orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Accepted Answer

Cardinality refers to the relationship between entities in a database and is important in designing the data model. Understanding the cardinality helps in creating an accurate data design that reflects all relationships among system entities.

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.
A)UML
B)cardinality
C)secondary key
D)data mining
E)orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Accepted Answer

The phrase describes physical storage, which is strictly hardware-related.

Question 8

Michelle tells Malia that a primary key is a field or combination of fields that uniquely and minimally identifies a particular entity. She explains that there may be a choice of fields or field combinations to use as the primary key. What is the term used for a possible primary key?
A) candidate key
B) concatenated key
C) foreign key
D) secondary key

Accepted Answer

A possible primary key is referred to as a candidate key.

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-In e-commerce, this works best when a goal is to reduce clicks to close, which means average page views to accomplish a purchase or obtain desired information.
A)UML
B)cardinality
C)secondary key
D)data mining
E)orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 10

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

Accepted Answer

The answer of Four kinds of problems are found with...

Question 11

Briefly describe (including examples in your answer) at least six of the common coding methods.

Accepted Answer

The answer of Briefly describe (including examples in your answer)...

Question 12

Perry tells Eamon that systems that interact with a database management system do not need to know about the underlying data structures used to store the physical data. As a result, a database administrator has the flexibility to change these underlying data structures without modifying the systems that use the data. What is the name of this feature of database management systems?
A) data scalability
B) data authorization
C) data flexibility
D) data independence

Accepted Answer

Data independence is the feature of a database management system that allows for flexibility in changing underlying data structures without affecting the systems that use the data. This allows for easier maintenance and updates to the database system.

Quiz 9: Data Design

Perry mentions that data in a file processing system may be repeated in several different files. He points out that problems can arise if updates to the data are not applied in every file. What is the name of this type of problem?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Kind of storage that refers to information as seen through a user's eyes, regardless of how or where the information actually is organized or stored.

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?

List at least 6 guidelines for developing a code.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A widely used method of visualizing and documenting software systems design.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -As an analyst, you must understand this in order to create a data design that accurately reflects all relationships among system entities.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.

Michelle tells Malia that a primary key is a field or combination of fields that uniquely and minimally identifies a particular entity. She explains that there may be a choice of fields or field combinations to use as the primary key. What is the term used for a possible primary key?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In e-commerce, this works best when a goal is to reduce clicks to close, which means average page views to accomplish a purchase or obtain desired information.

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

Briefly describe (including examples in your answer) at least six of the common coding methods.