ITM5300EXB01 Chapter 09 Database Design

1.What is the process that establishes the need for an information system and its extent?
A) Systems analysis

2. Which of the following is NOT a factor of the performance of an information system?
A) Database management functions and features

3. What is the primary objective in creating database design?
A) Create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

4. What are the System Development Life Cycle phases?
A) Planning, Analysis, Design, Implementation, and Maintenance

5. The feasibility study must address all of the following except _____.
A) the technical aspects of hardware and software cost

6. The database can be loaded using which methods and devices?
A) Customized user programs, database interface programs, and conversion programs that import the data from a different file structure

7. Which of the following is NOT true about the classical approaches to database design?
A) Top-down and bottom-up design methodologies are mutually exclusive.

8. Identify the three steps of a physical design.
A) Storage, Security, Performance

9. Which of the following is NOT a common factor for database management system selection?
A) Software requirements

10. Which of the following is NOT a benefit of business rules when designing a new system?
A) Business rules eliminate the company’s management problems.

Leave a Reply

Your email address will not be published. Required fields are marked *