chptr 3

What is a database management system (DBMS)?

• A collection of related data stored in a central location

• A method for accessing files in a random order

• A type of data hierarchy involving fields, records, and files

• Software for creating, storing, maintaining, and accessing database files

What is the purpose of a data warehouse?

• To create a logical view of information for users

• To support decision-making applications and generate business intelligence

• To store internal data collected from within an organization

• To manage a high demand for information from many users

What is the main goal of database marketing?

• To retrieve data in a sequential order based on a primary key

• To improve database efficiency and eliminate redundant data

• To use information within the database to implement marketing strategies

• To create a hierarchical model of relationships between records

What is the purpose of the data dictionary in the relational model?

• Eliminates redundant data and ensures related data is stored in a table

• Stores definitions such as data types for fields and default values

• Helps retrieve data from tables using operations like select and join

• Uniquely identifies every record in a relational database

What is the significance of the Big Data Era?

• Uses data and statistical methods to gain insight and provide information to decision makers

• Involves voluminous data with dimensions like volume, variety, and velocity

• Stores data on multiple servers throughout an organization for better reflection of the firm's structure

• Acts as an interface to a database and retrieves data for users

What is the purpose of prescriptive analytics in business analytics?

• Provides information to act on and improve decision making

• Reviews past events and analyzes data to prepare for the future

• Recommends a course of action for decision makers to follow

• Discovers patterns and relationships in data using data-mining analysis

What is the main advantage of using data marts over data warehouses?

• Improved response time for users with different needs

• Faster access to data due to its smaller size

• Effective targeting of users based on specific functions

• Easier creation process due to its size and simplicity

What is the purpose of ETL in a data warehouse?

• Analyzing large amounts of historical data quickly

• Creating and maintaining the data dictionary in the relational model

• Extraction, transformation, and loading of data from various sources

• Storing definitions and data types for fields in the database

What is the main function of the database engine in a DBMS?

• Responsible for data storage, manipulation, and retrieval

• Used for tasks such as backup and recovery, security, and change management

• Designs elements of an application using a database

• Used to add, delete, modify, and retrieve records from a database

What is the purpose of a hierarchical model in logical database design?

• Relationships between records form a tree-like structure

• Used to improve database efficiency and eliminate redundant data

• Records can be accessed in any order regardless of physical locations

• Determines how data is created, represented, and organized