Exam 9: Database Design

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

Producing the required information flow is part of the ____ phase of the DBLC.

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

Testing,fine-tuning,and evaluating the database and its applications are part of the ____ phase of the DBLC.

The last step in the DBLC is ____.

The testing and evaluation phase occurs after applications programming.

The ____________________ design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

There are ____ classical approaches to database design.

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

Because every request for structural changes requires retracing the SDLC steps,the system is always at some stage of the SDLC.

In the detailed systems design phase,the designer starts the design of the system's processes.

____ allow(s)physical access to areas by authorized personnel only.

Analyzing the company situation is part of the ____ phase of the DBLC.

____________________ security allows the assignment of access rights to specific authorized users.

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

The implementation and loading phase of the DBLC involves ____.

The implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a(n)_________________________.

Making sure that the final product meets user and system requirements is the most critical ____________________ phase.

The SDLC is most important to the ____.

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