Exam 9: Database Design

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

The database administrator must be prepared to perform routine maintenance activities within the database.

A designer must have a thorough understanding of the company's data types, extent, and uses in order to develop an accurate _____.

The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.

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

The process of creating an information system is known as .

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

Analyzing the company situation is part of the phase of the Database Life Cycle (DBLC).

The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain.

The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.

could become a very technical job that affects not only the accessibility of the data in the storage device(s) but also the performance of the system.

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

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

After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives.

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

The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

The design of the system's processes is completed during the phase of the Systems Development Life Cycle (SDLC).

The traditional Systems Development Life Cycle (SDLC) phases are , analysis, detailed systems design, implementation, and maintenance.