Databases And Business Intelligence

1. What is the role of a Database Management System (DBMS) in business intelligence?

Data visualization software - allows you to create visual representations of data to help analyze trends and patterns.

Supply chain management software - focuses on optimizing the flow of goods and services to meet customer requirements.

Customer relationship management (CRM) system - helps businesses manage interactions with customers and potential customers.

äDatabase management system (DBMS) – helps you specify the logical requirements for a database and access and use the information in a database.

A Database Management System (DBMS) plays a crucial role in business intelligence by providing the necessary infrastructure to store, manage, and access data effectively for making strategic business decisions. Data visualization software, Customer Relationship Management (CRM) systems, and Supply Chain Management software are important tools in the business context but do not directly serve the function of a DBMS in handling database information.

Explanation

A Database Management System (DBMS) plays a crucial role in business intelligence by providing the necessary infrastructure to store, manage, and access data effectively for making strategic business decisions. Data visualization software, Customer Relationship Management (CRM) systems, and Supply Chain Management software are important tools in the business context but do not directly serve the function of a DBMS in handling database information.

2. What is a view in a database?

View : Allows you to see the contents of a database file, make changes, and query it to find information.

Schema: Represents the structure that defines the objects in a database system.

Collection: A group of related data or objects that are stored together.

Table: Stores a set of related data in the form of rows and columns.

Index: Optimizes the performance of queries by minimizing the number of data comparisons.

A view in a database allows users to interact with the data in a structured way without directly accessing the underlying tables. It serves as a virtual table representing the results of a SQL query, which can include data from one or more tables.

Explanation

A view in a database allows users to interact with the data in a structured way without directly accessing the underlying tables. It serves as a virtual table representing the results of a SQL query, which can include data from one or more tables.

3. What tool helps you quickly define formats of reports and what information you want to see in a report?

Data dictionary

Database schema

Report generator : Helps you quickly define formats of reports and what information you want to see in a report.

Query language

A report generator specifically focuses on defining report formats and information, while other options may be related to database structure or querying data.

Explanation

A report generator specifically focuses on defining report formats and information, while other options may be related to database structure or querying data.

4. Primary key: field (or group of fields) that uniquely describes each record.

Index: A data structure used to quickly locate and access the data in a database.

QBE tool : Helps you graphically design the answer to a question.

SQL: A language used to manage and manipulate relational databases.

Normalization: A process of organizing data in a database.

The primary key uniquely identifies each record in a database table, while the QBE tool helps in designing queries graphically. SQL is a language used to interact with databases, normalization is about structuring data efficiently, and indexes improve database querying performance.

Explanation

The primary key uniquely identifies each record in a database table, while the QBE tool helps in designing queries graphically. SQL is a language used to interact with databases, normalization is about structuring data efficiently, and indexes improve database querying performance.

5. What is a foreign key?

API key used for authentication purposes.

Encryption key used for securing data.

SQL: Standardized fourth-generation query language found in most DBMSs

Database index used for sorting data.

A foreign key in a relational database is a key used to link two tables together. It is a field in one table that uniquely identifies a row of another table.

Explanation

A foreign key in a relational database is a key used to link two tables together. It is a field in one table that uniquely identifies a row of another table.