Exam 9: Database Design

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

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 design of the system's processes is completed during the ____ phase of the SDLC.

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.

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

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

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 ____.

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

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

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

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

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 first step in ____________________ design is to discover the data element characteristics.

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

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

There are ____ stages in the DBLC.

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