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.