Questions from Database Management


Q: Fitchwood management would like to use the data mart for drill-

Fitchwood management would like to use the data mart for drill-down online reporting. For example, a sales manager might want to view a report of total sales for an agent by month and then drill down...

See Answer

Q: Suggest some visualization options that Fitchwood managers might want to use to

Suggest some visualization options that Fitchwood managers might want to use to support their decision making.

See Answer

Q: Do you see any opportunities for data mining using the Fitchwood data

Do you see any opportunities for data mining using the Fitchwood data mart? Research data mining tools and recommend one or two for use with the data mart.

See Answer

Q: Text mining is an increasingly important subcategory of data mining. Can

Text mining is an increasingly important subcategory of data mining. Can you identify potential uses of text mining in the context of an insurance company?

See Answer

Q: Fitchwood is a relatively small company (annual premium revenues less than

Fitchwood is a relatively small company (annual premium revenues less than $1 billion per year) that insures slightly more than 500,000 automobiles and about 200,000 homes. For what types of purposes...

See Answer

Q: Read an SAS white paper (www.sas.com/

Read an SAS white paper (www.sas.com/resources/whitepaper/wp_56343.pdf) on the use of telematics in car insurance. If Fitchwood started to use one of these technologies, what consequences would it hav...

See Answer

Q: You are now ready to create to a proof of concept system

You are now ready to create to a proof of concept system for FAME. Provide a document that provides your recommendation on the set of technologies (DBMS, programming language, Web server [if appropria...

See Answer

Q: Any successful data governance program needs to address the people (“who

Any successful data governance program needs to address the people (“who”), process (“how”), and technology (“what”) aspects. Based on your reading this chapter, provide some examples for each of thes...

See Answer

Q: Examine the set of activities in Table 12-2 and categorize

Examine the set of activities in Table 12-2 and categorize them as belonging to one of the following categories: people (“who”), process (“how&aci...

See Answer

Q: The Pine Valley databases for this textbook (one small version illustrated

The Pine Valley databases for this textbook (one small version illustrated in queries throughout the text and a larger version) are available to your instructor to download from the text’s Web site. Y...

See Answer