FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Essay

Review LaterAdd Note

Review Later

What are the classical approaches to database design?

Correct Answer

verified

There are two classical approaches to da...

View Answer

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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

There are ____ stages in the DBLC.

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

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 company ____________________ describes the general conditions in which a company operates,its organizational structure,and its mission.

The SDLC traces the history of an information system.