Exam 9: Database Design

What are the factors affecting the purchasing decision for DBMS software?

During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

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

The database contents are loaded during the _____ phase of the Systems Development Life Cycle (SDLC).

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

The first step in developing the conceptual model using ER diagrams is to _____.

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

The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.

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

A designer must have a thorough understanding of the company's data types, extent, and uses in order to develop an accurate _____.

A(n) _____ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.

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

The advent of very sophisticated application generators and _____ has substantially decreased coding and testing time.

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

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

The _____ phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

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

A(n) _____ is an information system component that handles a specific business function, such as inventory, orders, or payroll.

After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.