Chapter 9 (True/False)

Question 1

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

Answer

true

Question 2

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

Answer

true

Question 3

3. The term “database development” is used to describe the process of database design and implementation.

Answer

true

Question 4

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

Answer

true

Question 5

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

Answer

true

Question 6

6. The SDLC traces the history of an information system.

Answer

true

Question 7

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

Answer

true

Question 8

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

Answer

true

Question 9

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

Answer

true

Question 10

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

Answer

true

Question 11

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

Answer

true

Question 12

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

Answer

true

Question 13

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

Answer

true

Question 14

14. Training principles and methodologies are planned during the implementation phase.

Answer

true

Question 15

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

Answer

true

Question 16

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

Answer

true

Question 17

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

Answer

true

Question 18

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

Answer

true

Question 19

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

Answer

true

Question 20

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

Answer

true

Question 21

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

Answer

true

Question 22

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

Answer

true

Question 23

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

Answer

true

Question 24

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

Answer

true

Question 25

25. The testing and evaluation phase occurs after applications programming

Answer

true

Question 26

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

Answer

true

Question 27

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

Answer

true

Question 28

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

Answer

true

Question 29

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

Answer

true

Question 30

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

Answer

true

Chapter 9 (True/False)

Crea una cuenta gratis para terminar este test

Preguntas del test (30)

Información

Escríbenos

¿Qué te parece el nuevo diseño?