Question 1

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

Accepted Answer

The answer of When you design the new contracts database...

Question 2

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

The answer of List at least three conditions that contribute...

Question 3

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 4

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

Accepted Answer

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

Question 5

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 6

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 7

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

Accepted Answer

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

Question 8

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 9

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Accepted Answer

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

Question 10

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

Accepted Answer

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

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