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 1

True/False

Review LaterAdd Note

Review Later

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

The design of the system's processes is completed during the ____ phase of the SDLC.

A) planning
B) analysis
C) detailed systems design
D) implementation

E) A) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

The first step in ____________________ design is to discover the data element characteristics.

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.

The database initial study phase of the DBLC involves ____.

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

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

Database backups can be performed at different levels.List and describe these.

The implementation and loading phase of the DBLC involves ____.

The process of creating an information system is known as ____ development.

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

The conceptual design step that determines end-user views,outputs,and transaction-processing requirements is ____.

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

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

There are ____ stages in the DBLC.

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

From a database point of view,the collection of data becomes meaningful only when the business ____________________ are defined.

After testing is concluded,end-user training is not necessary.

Because real-world database design is generally done by teams,you should strive to organize the design's major components into ____________________.