CHAPTER 9: DATABASE DESIGN

1

1. Systems analysis establishes the need for an information system and its extent

1

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

1

3. The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

1

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

1

5. The Systems Development Life Cycle (SDLC) traces the history of an information system.

1

6. The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.

1

7. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.

1

8. The Systems Development Life Cycle’s (SDLC’s) planning phase yields a general overview of the company and its objectives.

1

9. The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system’s functional areas, actual and potential problems, and opportunities.

1

10. In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

1

11. The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.

1

12. In the Systems Development Life Cycle (SDLC), the design of the system’s processes begins in the detailed systems design phase.

1

13. In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system.

1

14. Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

1

15. The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

1

16. During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

1

17. The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

1

18. The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

1

19. In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.

1

20. A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

1

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

1

22. The overall purpose of the database initial study is to create the conceptual design.

1

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

1

24. After the initial declarations in Database Life Cycle (DBLC), 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.

1

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

1

26. The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.

1

27. Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.

1

28. The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.

1

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

1

30. Evaluation of database performance is rendered easier by the fact there are no standards to measure it.

1

31. The main purpose of a backup is to guarantee database restoration following a hardware or software failure.

1

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

1

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

1

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

1

35. The process of creating an information system is known as .

1

36. The traditional Systems Development Life Cycle (SDLC) is divided into phases.

1

37. Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).

1

38. Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC).

1

39. “Should the existing system be replaced?” is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).

1

40. “What are the requirements of the current system’s end users?” is a question asked during the phase of the Systems Development Life Cycle (SDLC).

1

41. The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the:

1

42. The logical systems design is created during the phase of the Systems Development Life Cycle (SDLC).

1

43. The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).

1

44. In DBLC, the phase after the database initial study is .

1

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

1

46. The maintenance and evolution phase of the Database Life Cycle (DBLC) involves .

1

47. Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC).

1

48. Producing the required information flow is part of the phase of the Database Life Cycle (DBLC).

1

49. is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

1

50. The implementation and loading phase of the Database Life Cycle (DBLC) involves .

1

51. In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is .

1

52. In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is .

1

53. can render data useless to unauthorized users who might have violated some of the database security layers.

1

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

1

55. In a(n) , only the objects that have been updated or modified since the last full backup are backed up.

1

56. Which of the following is a hardware-induced database failure?

1

57. The last step in the Database Life Cycle (DBLC) is .

1

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

1

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

1

60. is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.

1

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

CIS 3365 Quiz sobre CHAPTER 9: DATABASE DESIGN, criado por Miguel Lucero em 05-04-2017.

CHAPTER 9: DATABASE DESIGN

CHAPTER 9: DATABASE DESIGN

1. Systems analysis establishes the need for an information system and its extent

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

3. The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

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

5. The Systems Development Life Cycle (SDLC) traces the history of an information system.

6. The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.

7. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.

8. The Systems Development Life Cycle’s (SDLC’s) planning phase yields a general overview of the company and its objectives.

9. The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system’s functional areas, actual and potential problems, and opportunities.

10. In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

11. The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.

12. In the Systems Development Life Cycle (SDLC), the design of the system’s processes begins in the detailed systems design phase.

13. In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system.

14. Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

15. The detailed systems design phase of the Systems Development Life Cycle (SDLC) 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 of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

17. The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

18. The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

19. In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.