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 31

True/False

Review LaterAdd Note

Review Later

The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

The _____ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

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

The first step in the ER model verification process is to _____.

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

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

List and briefly describe the three types of system maintenance activities.

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

The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

Once the data has been loaded into the database, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

The proposed system is subject to limits known as _____, which are external to the system.

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

List and describe the different levels at which database backups can be performed.

During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.

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

An initial assessment of the information flow-and-extent requirements must be made during the _____ portion of the Systems Development Life Cycle (SDLC).

_____ are usually provided by the database management system (DBMS) to check for access violations.

The result of the _____phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.