Exam 9: Database Design

List and briefly describe the three types of system maintenance activities.

The database contents may be loaded interactively or in ____________________ mode.

The SDLC traces the history of an information system.

Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.

User requirements,existing system evaluation,and logical system design are part of the ____ phase of the SDLC.

The result of analysis should be a better understanding of the system's functional areas,actual and potential problems,and opportunities.

The first step in ____________________ design is to discover the data element characteristics.

In the detailed systems design phase,steps are laid out for conversion from the old system to the new system.

During the testing phase,the system is subjected to exhaustive testing until it is ready for use.

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

The company ____________________ describes the general conditions in which a company operates,its organizational structure,and its mission.

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

What are the classical approaches to database design?

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

Systems analysis is used to determine the need for an information system and to establish its limits.

The conceptual design step that defines the DBMS and data model to use is ____.

Once the data has been loaded into the database,the ____ tests and fine-tunes the database for performance,integrity,concurrent access,and security constraints.

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

There are ____ stages in the DBLC.

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