MIS 5-1 Review Questions - Complete Answers

5 -1 MIS REVIEW QUESTIONS

How does a relational database organize data, and how does it differ from an object-oriented database?

• Define and explain the significance of entities, attributes, and key fields.
• Define a relational database and explain how it organizes and stores information.
• Explain the role of entity-relationship diagrams and normalization in database design.
• Define an object-oriented database and explain how it differs from a relational database.

What are the principles of a database management system?

• Define a database management system (DBMS), describe how it works, and explain how it benefit organizations.
• Define and compare the logical and a physical view of data.
• Define and describe the three operations of a relational database management system.
• Name and describe the three major capabilities of a DBMS.

What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?

• Define a data warehouse and describe how it works.
• Define business intelligence and explain how it is related to database technology.
• Describe the capabilities of online analytical processing (OLAP).
• Define data mining, describe what types of information can be obtained from it, and explain how does it differs from OLAP.
• Explain how text mining and Web mining differ from conventional data mining.
• Explain how users can access information from a company’s internal databases through the Web.

What is the role of information policy and data administration in the management of organizational data resources?

• Define information policy and data administration and explain how they help organi-zations manage their data.

Why is data quality assurance so important for a business?

• List and describe the most common data quality problems.
• List and describe the most important tools and techniques for assuring data quality.