Database System Development Lifecycle Quiz

What percentage of software projects do not meet their performance goals?

• 10-20%

• 40-50%

• 80-90%

• 90-100%

What is one of the major reasons for the failure of software projects?

• Lack of a complete requirements specification

• Lack of an appropriate development methodology

• Poor decomposition of design into manageable components

• All of the above

Which step of the Information Systems Lifecycle involves determining what data and information are required to perform business functions?

• Problem, opportunity, and objective identification

• Information requirements determination and requirements gathering

• System design

• System testing and maintenance

What is the purpose of the logical design phase in database design?

• To identify databases that will store required data

• To develop system applications including data entry forms and reports

• To test the system on real data to pinpoint faults

• To create a design that supports the enterprise's mission statement and objectives

Which phase of database design involves creating a data model representing all user views?

• Conceptual design

• Logical design

• Physical design

• DBMS selection

When should the selection of a DBMS be made in the database system development lifecycle?

• During the requirements collection and analysis phase

• During the system design phase

• During the testing phase

• Any time before logical design provides sufficient information regarding system requirements

What criteria can be used to evaluate a database system during testing?

• Learnability, performance, robustness, recoverability, adaptability

• Usability, efficiency, reliability, scalability, maintainability

• Accuracy, completeness, consistency, timeliness, security

• Flexibility, availability, durability, integrity, confidentiality

What does CASE stand for in the context of database system development?

• Computer-Aided Software Engineering

• Computer-Assisted System Evaluation

• Corporate Application Support Environment

• Customer Analysis and System Enhancement

Which stage of the database system development lifecycle may involve selecting suitable CASE tools?

• Database planning

• Requirements collection and analysis

• Database design

• Testing

What is the purpose of a mission statement in data planning?

• To define the major aims of the database system

• To clarify the purpose of the database system

• To provide a clearer path toward the creation of the required database system

• All of the above