Questions from Database Management


Q: List 10 potential benefits of the database approach over conventional file systems

List 10 potential benefits of the database approach over conventional file systems.

See Answer

Q: List five costs or risks associated with the database approach.

List five costs or risks associated with the database approach.

See Answer

Q: A database is referred to as “an organized collection of logically

A database is referred to as “an organized collection of logically related data.” What does “related data” mean? Why must data be related?

See Answer

Q: Figure 1-5 specifies categories for Operational and Informational data management

Figure 1-5 specifies categories for Operational and Informational data management systems. Describe the main difference between these two categories.

See Answer

Q: A relationship is established between any pair of entities in an enterprise

A relationship is established between any pair of entities in an enterprise data model. Explain why a relationship is necessary.

See Answer

Q: What is the purpose of designing an enterprise data model? How

What is the purpose of designing an enterprise data model? How is it different from the design of a particular database?

See Answer

Q: Specify the difference between database solutions supporting enterprise databases and departmental multitiered

Specify the difference between database solutions supporting enterprise databases and departmental multitiered databases.

See Answer

Q: What differentiates data lakes from traditional data warehouses?

What differentiates data lakes from traditional data warehouses?

See Answer

Q: Name the five phases of the traditional systems development life cycle and

Name the five phases of the traditional systems development life cycle and explain the purpose and deliverables of each phase.

See Answer

Q: In which of the five phases of the SDLC do database development

In which of the five phases of the SDLC do database development activities occur?

See Answer