Chapter 9

A module is an information system component that handles ______ buisness functions?

A specific

What does ACID stand for

Atomicity Consisticty Isolation Durability

The options below are advantages of the computer-aided software engineering(CASE)-produced applications except?

CASE incurs unreasonable costs

The database designer is working on creating the Entity Relationship model, but before doing so, the designer must ___ and enforce appropriate standards to be used in the documentation of the design.

Communicate

The first stage in the database design process is __?

Conceptual design

What is the first phase of the database design process?

Conceptual design

What are the three stages of database design?

Conceptual, logical, and physical

Josh is a database designer, which of the options below is not one of the primary objectives that he should consider in designing a database?

Create illogical database models

Jerry is a stakeholder in ABC company, he is considering ___ as one of the factors that will affect ABC company's purchasing decision of a DBMS, the items that he should consider include: some database software's variety of tools that facilitate application development.

DBMS features and tools

50. The first step of the conceptual design is __?

Data analysis and requirements

Julie is a database administrator, she can use _____ to render data useless to unauthorized users who might have violated some of the database security layers.

Data encryption

. In a situation whereby the data has been loaded into the database, John, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Database administrator

38. Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).

Database design

As a database developer, you could interpret that the term database development describes the process of __?

Database design and implementation

A __ is a subset of a database that is stored at a given location.

Database fragment

As a database designer, which of the options below would you not include in the implementation phase of a database design?

Designing the database

In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.

Differential backup

Well-defined and enforced standards make design work __?

Easier

29. The Systems Development Life Cycle (SDLC) is divided into __ phases.

FIVE

Logical design is the first stage in the database design process

False

he overall purpose of the database initial study is to create the conceptual design.

False

Which of the answers below is part of the composition of an information system?

Hardware

Joe is a database designer; his team is designing a database for a client. They should not consider ___ as one of the considerations to be taken as they design and implement the database.

Impenetrability over time

Below are some of the efforts that the designer focuses on during the data analysis and requirement step of the conceptual design except __?

Information design

The implementation and loading phase of the Database Life Cycle (DBLC) involves

Installing the DBMS

As a database designer, the first step that you would take in creating the logical design is to ___ the conceptual model.

Map

The term __ describes the strength of the relationships found among the module's entities.

Module Cohesivity

The term __ describes the extent to which modules are independent of one another.

Module Copuling

Jose wants to load his organization's database content; he can load the content interactively or in batch mode using a variety of methods and devices including the options below except?

Network interface programs

Communications failures often lead to __ work.

Poor design

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).

analysis

The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).

analysis

What is the purpose of database initial study

analyze the company situation; define problems, constraints, objectives, scope and boundaries.

in the detailed systems design phase, the designer __?

completes the design of the system's process

As one of the stakeholders of a company, which of the factors below will affect your company's purchasing decision of a DBMS?

cost

In the context of the database design process, Jasmine, the database designer could use ____ as the conceptual design step that determines end-user views, outputs, and transaction-processing requirements.

data analysis and requirements

Rick's team is creating a new database for a client. what is the next phase for his team in DBLC, after the database initial study is done?

database design

Jody is designing a new database for a client; she would like to let the client know that the performance of an information system depends on the following factors except:

database software and implementation

In the context of the database design process, Angie, the database designer, could use the ____ as the conceptual design step to define the fragmentation and allocation strategy.

distributed database design

The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.

false

The designer does not need to have a thorough understanding of the company's data types, their extent, and uses to be able to develop an accurate data model.

false

he Systems Development Life Cycle (SDLC) traces the history of an organization's system.

false

During the kickoff meeting for a new database project, which of the models below can John, the team lead indicate that the database can be based on?

graph data model

As a systems developer, you load the database contents during the _____ phase of the Systems Development Life Cycle (SDLC).

implementation

What phase of the SDLC is coding, testing, and debugging.

implementation phase

The maintenance and evolution phase of the DBLC involves

introducing changes

Jude is an experienced systems developer; Jude wants to make the system that they are developing a more efficient information generator during the detailed systems design phase of the Systems Development Life Cycle (SDLC). Which of the options below is not included in the necessary technical specification to help Jude achieve this?

keyboard

For Jared, a database consultant, to avoid false expectations, he must make the end user aware of the ___ of both the DBMS and the database.

limitations

Evaluation, maintenance, and enhancement are done during the __ phase of the Systems Development Life Cycle (SDLC).

maintenance

Which of the following is a hardware-induced database failure?

memory chip errors

Producing the required information flow is part of the _____ phase of the Database Life Cycle (DBLC).

operation

32. What are the requirements of the current system's end users? is a question you ask during the _____ phase of the Systems Development Life Cycle (SDLC).

planning

Should the existing system be replaced? is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).

planning

61. Pete is database consultant, in considering ___ as part of the factors that will affect the purchasing decision of a DBMS, items to consider include processor(s), RAM, and disk space.

portability

One of the factors that affect purchasing decisions is __. This means considering if a DBMS can be portable across platforms, systems, and languages.

portability

23. Anna leads a team of database designers and developers, she uses ___ because it is an iterative and incremental methodology that focuses on continuing improvement toward priority deliverables.

scrum

Tony is a database designer; in what stage of the database design process will he implement the logical design?

second

69. As a database designer, you would use the logical design to translate the software- independent conceptual model into a ___ model.

software dependent model

As a database designer, you should ensure that the logical design contains only properly normalized ___.

table

What does the systems development life cycle trace (SDLC)

the history of an information system

Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.

true

In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

true

Systems analysis establishes the need for an information system and its extent.

true

The first step in creating the logical design is to map the conceptual model to the chosen database constructs.

true

The term "database development" is used to describe the process of database design and implementation.

true

Siddarth is rounding up the logical design process, his final step is to ___ all logical model definitions against all end-user data, transaction, and security requirements.

validate

in a scenario during decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.

verification

As a database analyst, what technique would you use to create logical representations of computing resources that are independent of the underlying physical computing resources.

Virtualization

The designer must identify the company's business rules and analyze their impact on the nature, role, and __ of data.

Scope

Callie is an end-user. Callie might request the types of generated system maintenance activities below except:

Standardized maintenance

__ is the process that establishes the need for an information system and its extent.

Systems analysis

As a database architect, you usually explain that applications transform data into the information that forms the basis for decision making within the framework of __.

Systems development

The process of creating an information system is known as _____.

Systems development

__ is the process of creating an information system.

Systems development

48. During the kickoff meeting for a new database project, the project lead might explain that the database design will consist of __ stages.

Three

The selection of DBMS software is critical to the information systems smooth operation.

True

______ provides object-oriented tools to support the tasks associated with the development of information systems.

ULM