Database Management 10

Question 1

is any attribute whose value determines other values within a row. If you have three different transitive dependencies, you will have three different determinants. As with the conversion to 2NF, it is important that the determinant remain in the original table to serve as a foreign key.

Answer 1

determinant

Question 2

If the determinant of a functional dependence is not the primary key but is a part of another candidate key, then it is not a nonprime attribute and does not signal the presence of a transitive dependency.

Answer 2

info …

Question 3

is an attribute that cannot be further subdivided.

Answer 3

atomic attribute

Question 4

is a term that describes a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.

Answer 4

Business intelligence (BI)1

Question 5

is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Answer 5

Master data management (MDM)

Question 6

are quantifiable numeric or scale-based measurements that assess the company’s effectiveness or success in reaching its strategic and operational goals.

Answer 6

Key performance indicators (KPIs)

Question 7

is abstracting data to provide information in a visual format that enhances the user’s ability to effectively comprehend the meaning of the data.

Answer 7

Data visualization

Question 8

provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data. Supports : Multidimensional data schema support within the RDBMS, data access language and query performance optimized for multidimensional data, support for very large databases (VLDBs).

Answer 8

Relational online analytical processing (ROLAP)