Deck 9: Database Design

Question 1

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

Answer 1

True

Question 2

After testing is concluded,end-user training is not necessary.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

Because every request for structural changes requires retracing the SDLC steps,the system is always at some stage of the SDLC.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

The primary objective in database design is to create complete,denormalized,redundant,and fully integrated conceptual,logical,and physical database models.

Question 12

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

Question 13

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

Question 14

The SDLC traces the history of an information system.

Question 15

The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.

Question 16

The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.

Question 17

Training principles and methodologies are planned during the implementation phase.

Question 18

The term "database development" is used to describe the process of database design and implementation.

Question 19

In the detailed systems design phase,the designer starts the design of the system's processes.

Question 20

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

Question 21

Database performance is one of the least important factors in all database implementations.

Question 22

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

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 23

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

Question 24

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

Question 25

The process of database design and implementation is ____ development.

A) systems
B) database
C) network
D) transformation

Question 26

Evaluation,maintenance,and enhancement are part of the ____ phase of the SDLC.

A) planning
B) maintenance
C) detailed systems design
D) implementation

Question 27

The testing and evaluation phase occurs after applications programming.

Question 28

Detailed system specification is part of the ____ phase of the SDLC.

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 29

The database administrator must be prepared to perform routine maintenance activities within the database.

Question 30

The traditional SDLC is divided into ____ phases.

A) two
B) three
C) four
D) five

Question 31

After the initial declarations in a study,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.

Question 32

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

Question 33

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

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 34

The primary objective of database design is ____.

A) To create the most efficient database possible
B) To create complete,normalized,nonredundant,and fully integrated conceptual,logical,and physical database models
C) To create the fastest queries
D) To be able to add data quickly

Question 35

The process of creating an information system is known as ____ development.

A) systems
B) database
C) network
D) transformation

Question 36

To analyze the company situation,the database designer must discover what the company's operational components are,how they function,and how they interact.

Question 37

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

Question 38

Coding,testing,and debugging are part of the ____ phase of the SDLC.

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 39

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

Question 40

Installation and fine tuning are part of the ____ phase of the SDLC.

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 41

There are ____ stages in the DBLC.

A) four
B) five
C) six
D) seven

Question 42

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

A) planning
B) analysis
C) implementation
D) maintenance

Question 43

The implementation and loading phase of the DBLC involves ____.

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 44

Analyzing the company situation is part of the ____ phase of the DBLC.

A) database initial study
B) database design
C) implementation and loading,testing,and evaluation
D) operation

Question 45

The logical systems design is created during the ____ phase of the SDLC.

A) planning
B) analysis
C) implementation
D) maintenance

Question 46

The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.

A) database
B) network
C) CASE
D) design

Question 47

The conceptual design step that determines end-user views,outputs,and transaction-processing requirements is ____.

A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design

Question 48

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

A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation

Question 49

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

A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation

Question 50

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

A) database initial study
B) database design
C) operation
D) testing and evaluation

Question 51

The conceptual design step that defines entities,attributes,and relationships is ____.

A) database analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design

Question 52

The database is loaded during the ____ phase of the SDLC.

A) analysis
B) detailed systems design
C) implementation
D) maintenance

Question 53

The maintenance and evolution phase of the DBLC involves ____.

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 54

The SDLC is most important to the ____.

A) programmer
B) manager
C) system designer
D) database administrator

Question 55

The last step in the DBLC is ____.

A) maintenance and evolution
B) operation
C) testing and evaluation
D) implementation and loading

Question 56

The first step in the DBLC is ____.

A) operation
B) database initial study
C) database design
D) implementation and loading

Question 57

The database initial study phase of the DBLC involves ____.

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 58

The design of the system's processes is completed during the ____ phase of the SDLC.

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 59

"Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.

A) planning
B) analysis
C) implementation
D) maintenance

Question 60

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.

A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation

Question 61

In addition to system scope,which defines the extent of the design,the proposed system is subject to ____________________,which are external to the system.

Question 62

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

A) initial
B) verification
C) conceptual
D) logical

Question 63

The designer must recognize the existence of two sets of limits: scope and ____________________.

Question 64

The conceptual design step that identifies ER modules and validates insert,update,and delete rules is ____.

A) database analysis and requirements
B) ER modeling and normalization
C) data-model verification
D) distributed database design

Question 65

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

Question 66

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

A) Verification
B) Process
C) Module
D) Cohesive

Question 67

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

A) normalize the entities
B) complete the initial ER diagram
C) identify,analyze,and refine the business rules
D) define the attributes,primary keys,and foreign keys for each of the entities

Question 68

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

Question 69

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

Question 70

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

Question 71

The first step in the ER model verification process is to ____.

A) identify each module and its components
B) identify the ER model's central entity
C) verify all processes against the ER model
D) identify each module's internal transaction requirements

Question 72

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

Question 73

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

A) database analysis and requirements
B) ER modeling and normalization
C) data-model verification
D) distributed database design

Question 74

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

Question 75

____ allow(s)physical access to areas by authorized personnel only.

A) Physical security
B) Password security
C) Access rights
D) Data encryption

Question 76

An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.

Question 77

There are ____ classical approaches to database design.

A) two
B) three
C) four
D) five

Question 78

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) programmer
B) manager
C) database administrator
D) systems administrator

Question 79

The ____ design is the process of selecting the data storage and data access characteristics of the database.

A) time
B) network
C) logical
D) physical

Question 80

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