Question 1

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

The answer of What types of relationships are possible in...

Question 2

A small publishing house that you work for would like to develop a database that keeps track of the contracts that authors and publishers sign before starting a book. What fields do you anticipate needing for this database? Identify at least seven fields. Which of these fields might be in use in other databases within the firm?

Accepted Answer

The answer of A small publishing house that you work...

Question 3

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

The answer of List and describe three main capabilities or...

Question 4

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

The answer of What makes data mining an important business...

Question 5

Identify and describe the three basic operations used to extract useful sets of data from a relational database?

Accepted Answer

The answer of Identify and describe the three basic operations...

Question 6

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

The answer of What are the differences between data mining...

Question 7

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

The answer of Describe the ways in which database technologies...

Question 8

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

Accepted Answer

The answer of The small publishing company you work for...

Question 9

List at least two ways that a business's data can become redundant or inconsistent.

Accepted Answer

The answer of List at least two ways that a...

Question 10

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

The answer of Explain what big data refers to. What...

Quiz 6: Foundations of Business Intelligence: Databases and Information Management