Exam 2: Database Development Process

____________________ is the process that establishes the need for, and the extent of, an information system.

The company ____________________ describes the general conditions in which a company operates, its organizational structure, and its mission.

The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance.

Problems defined during the planning phase are examined in greater detail during the analysis phase.

User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.

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

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

The ____ design is the process of selecting the data storage and data access characteristics of the database.

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

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

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

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

When selecting DBMS ____________________, consider processor(s), RAM, disk space, and so on.

What are the classical approaches to database design?

The database contents may be loaded interactively or in ____________________ mode.

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

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

The last step in the DBLC is ____.

Coding, testing, and debugging are part of the ____ phase of the SDLC.

The database initial study phase of the DBLC involves ____.