Exam 9: Database Design

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

The system's ____________________ defines the extent of the design according to operational requirements.

The process of database design and implementation is ____ development.

Physical design becomes simpler when data is distributed at different locations.

____________________ design 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.

____ coupling describes the extent to which modules are independent of one another.

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

The existing hardware and software systems are studied during the planning phase.

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

During the implementation phase,the hardware,the DBMS software,and application programs are installed and the database design is implemented.

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 traditional SDLC is divided into ____ phases.

The SDLC's planning phase yields a general overview of the company and its objectives.

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

The initial assessment and the feasibility study are part of the SDLC's ____ phase.

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

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

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

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

A(n)____________________ is an information system component that handles a specific business function,such as inventory,orders,payroll,and so on.