Exam 9: Database Design

The implementation and loading phase of the Database Life Cycle (DBLC)involves .

Coding,testing,and debugging are part of the phase of the Systems Development Life Cycle (SDLC).

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

Decentralized design is typical of relatively simple,small databases and can be successfully done by a single person.

allows the assignment of access rights to specific authorized users.

Because real-world database design is generally done by teams,the database design is probably divided into major components known as .

The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC)must address the:

The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

In the Systems Development Life Cycle (SDLC),after testing is concluded,end-user training is not necessary.

Explain the differences between a centralized and decentralized approach to database design.

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

can render data useless to unauthorized users who might have violated some of the database security layers.

is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity,security,and performance.

Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

The result of analysis phase of the Systems Development Life Cycle (SDLC)should be a better understanding of the system's functional areas,actual and potential problems,and opportunities.

A(n)is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.

The term describes the strength of the relationships found among a module's entities.

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

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

Systems analysis establishes the need for an information system and its extent.