1. Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.
2. Systems analysis is used to determine the need for an information system and to establish its limits.
3. The term “database development” is used to describe the process of database design and implementation.
4. The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.
5. The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.
6. The SDLC traces the history of an information system.
7. The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.
8. The SDLC's planning phase yields a general overview of the company and its objectives.
9. Problems defined during the planning phase are examined in greater detail during the analysis phase.
10. The existing hardware and software systems are studied during the planning phase.
11. The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.
12. In the detailed systems design phase, the designer starts the design of the system's processes.
13. In the detailed systems design phase, steps are laid out for conversion from the old system to the new system.
14. Training principles and methodologies are planned during the implementation phase.
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.
16. During the implementation phase, the hardware, the DBMS software, and application programs are installed and the database design is implemented.
17. During the testing phase, the system is subjected to exhaustive testing until it is ready for use.
18. After testing is concluded, end-user training is not necessary.
19. Because every request for structural changes requires retracing the SDLC steps, the system is always at some stage of the SDLC.
20. A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.
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.
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.
23. In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.
24. Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.
25. The testing and evaluation phase occurs after applications programming
26. Database performance is one of the least important factors in all database implementations.
27. Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.
28. The database administrator must be prepared to perform routine maintenance activities within the database
29. Physical design becomes simpler when data is distributed at different locations.
30. Decentralized design is typical of relatively simple and/or small databases and can be successfully done by a single person.
