FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is .

A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design

E) All of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The main purpose of a backup is to guarantee database restoration following a hardware or software failure.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Database performance is one of the least important factors in all database implementations.

A rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.

Installation and fine tuning are part of the phase of the Systems Development Life Cycle (SDLC) .

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

After testing is concluded, the final is reviewed and printed and end users are trained.

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

The system's defines the extent of the design according to operational requirements.

The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

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

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

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

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

is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.

In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.

Explain the differences between a centralized and decentralized approach to database design.

Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is .

When selecting DBMS , items to consider include processors, RAM, and disk space.