New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Modern Database Management 10th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions
What are the key areas of IT that are examined during a Sarbanes-Oxley audit?
What is the difference between an authentication scheme and an authorization scheme?
List and briefly explain how integrity controls can be used for database security.
Explain how creating a view may increase data security.Also explain why one should not rely completely on using views to enforce data security.
List and discuss five areas where threats to data security may occur.
What changes can be made in data administration at each stage of the traditional database development life cycle to deliver high-quality, robust systems more quickly?
Briefly describe four new specialized DBA roles that are emerging today.
List four job skills necessary for data administrators. List four job skills necessary for database administrators.
List four common problems of ineffective data administration.
Describe the changing roles of a data administrator and database administrator in the current business environment.
Indicate whether data administration or database administration is typically responsible for each of the following functions:a. Managing the data repositoryb. Installing and upgrading the DBMSc. Conceptual data modelingd. Managing data security and privacye. Database planningf. Tuning database
What is an open source DBMS?
Compare and contrast the following terms:a. data administration; database administrationb. repository; data dictionaryc. deadlock prevention; deadlock resolutiond. backward recovery; forward recoverye. active data dictionary; passive data dictionaryf. optimistic concurrency control; pessimistic
Define each of the following terms:a. data administrationb. database administrationc. two-phase locking protocold. information repositorye. lockingf. versioning g. deadlock h. transaction i. encryption j. data availability k. data archiving l. heartbeat query
Assume that the result of an analysis to your answer to Case Question 5 is to develop an EMR system via data integration in-house. What approach to data integration would you recommend: consolidation, federation, propagation, or master data management? Justify your answer.
Investigate data quality management in greater detail and outline a data quality strategy that would address the issues raised in the case description. What should be the first step? What would be considered high-quality data at MVCH? How could data quality be built into the process?Who should be
Commercial off-the-shelf (COTS) packages for EMR could replace all of the data systems that would have to be integrated to form an EMR system in-house at MVCH. (You might want to research a few as background to this question.) Develop a list of pros and cons for purchasing a COTS EMR system versus
Refer to the MVCH case in Chapter 9 and your answers to case questions and exercises there. What data quality challenges may arise if MVCH develops a data warehouse and/or data mart(s)? Do you think that there is a need for data scrubbing? If so, is it necessary to scrub all tables or just some?
Refer to the MVCH case in Chapter 9 and your answers to case questions and exercises there. How can a data warehouse help improve data quality at MVCH? Can it actually do so? Under what circumstance would a data warehouse improve data quality?
In light of HIPAA and other regulations, securing and protecting patient records is a primary requirement for MVCH. Examine the organization chart for MVCH in Chapter 1 (MVCH Figure 1-1). Who would be the best choice for a data steward for patient data? Please explain your answer. What
Do you think that data quality at MVCH is a strategic issue? Why or why not?
Interview a data administrator in an organization that has established a data governance committee and data stewards. Document the different roles provided by the data administrator(s), data stewards, and data governance committee members. What is the charter for the data governance committee? How
Interview data warehouse managers in an organization where you have contacts about their ETL processes. What lessons did you learn from your interviews about the design of sound ETL processes?
Access the resources at Teradata Student Network (www.teradatastudentnetwork.com) for a Webinar or Webcast(produced after 2007) on the topic of data integration or master data management that was. Prepare a summary of new ideas introduced in that Webcast that expand on the discussion from this
Master data management and the related specialty customer data integration are rapidly changing disciplines.Find a recent article or book on these topics (or some other specialty area for master data management, such as in health care, operations, or human resources) and prepare a summary of new
Perform a search of companies and products that are available to help with data reconciliation and integration.Document your results by filling in the table below. We have provided a sample example: Product Name Company Data Bridger Taurus Software Data Integration Steps Supported Extract,
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 book’s Web site. Your instructor can make those databases available to you.Alternatively, these and other databases
After some further analysis, you discover that the commission field in the Policies table is updated yearly to reflect changes in the annual commission paid to agents on existing policies. Would knowing this information change the way in which you extract and load data into the data mart from the
What types of data transformations might be needed in order to build the Fitchwood data mart?
Research some tools that perform data scrubbing. What tool would you recommend for the Fitchwood Insurance Company?
What types of data pollution/cleansing problems might occur with the Fitchwood OLTP system data?
The OLTP system data for the Fitchwood Insurance Company is in a series of flat files. What process do you envision would be needed in order to extract the data and create the ERD shown in Figure 9-26? How often should the extraction process be performed? Should it be a static extract or an
Describe some field-level and record-level data transformations that often occur during the ETL process for loading a data warehouse.
List common tasks performed during data cleansing.
Explain how the phrase “extract–transform– load” relates to the data reconciliation process.
List five errors and inconsistencies that are commonly found in operational data.
List and briefly describe five steps in the data reconciliation process.
List six typical characteristics of reconciled data.
What distinguishes master data management from other forms of data integration?
What are the major differences between the data federation and data propagation forms of data integration?
Describe the three major approaches to master data management.
Why is master data management important in an organization?
How can data capture processes be improved to improve data quality?
What is data profiling, and what role does it play in a data quality program?
Describe the key steps to improve data quality in an organization.
Explain four reasons why the quality of data is poor in many organizations.
Define the eight characteristics of quality data.
Explain the effect of the Sarbanes-Oxley Act on the need for organizations to improve data quality.
What are four reasons why data quality is important to an organization?
How does data stewardship relate to data governance?
What are the key components of a data governance program?
Contrast the following terms:a. static extract; incremental extractb. data scrubbing; data transformationc. consolidation; federationd. ETL; master data management
Define each of the following terms:a. static extractb. incremental extractc. data stewardd. master data managemente. refresh mode
Identify dimensions and facts for two other possible data marts at MVCH: an emergency room data mart and a data mart for Dr. Z’s MS Center. Use Microsoft Visio (or a similar tool) to draw the star schema.
After hearing about the data mart prototypes, Dr. Jefferson, chief of surgery, expresses an interest in a surgery data mart. Some of the reports he wishes to receive include the number of surgeries, by surgeon; the number of inpatient and outpatient surgeries per week and per month; the number of
MVCH Table 9-1 provides some details regarding the two data marts MVCH is considering.a. Design a star schema for each data mart.b. Calculate the expected number of rows in each fact table and its estimated size (bytes).c. For the detailed data mart, why is it necessary to assume that a given
The case segment mentions the Sarbanes-Oxley Act(described in Chapter 5). How can a data warehouse or data mart help Ms. Baker and Mr. Lopez respond to pressures from the board of directors for the following:a. Ensuring the accuracy of financial datab. Providing reports in a timely mannerc.
What types of data-mining operations could be used(e.g., predictive modeling, cluster analysis, etc.)? For what purposes?
If MVCH were to develop a data mart, do you think that OLAP tools should be used? If yes, which type (OLAP, ROLAP, or MOLAP)?
How would you address concerns about security and HIPAA’s privacy mandates that prohibit unauthorized use of patient-identifiable information?
Should MVCH consider developing data marts (such as those proposed) without an established data warehouse?What are the risks associated with that approach? Do you think that an organization can develop a prototype data mart to investigate “proof of concept” without an established data
How could a data mart be used to improve the quality of emergency room care?
What are some of the advantages that a hospital such as MVCH might realize from a data warehouse and/or data mart(s)? How can a data warehouse/ data mart help with improving the following?• Operational efficiency• Treatment efficiency• Clinical outcomes• Patient safety• Clinical research
Visit www.teradatastudentnetwork.com and use the various business intelligence software products available on this site. Compare the different products, based on the types of business intelligence problems for which they are most appropriate. Also, search the content of this Web site for articles,
Visit the following Web sites. Browse these sites for additional information on data warehouse topics, including case examples of warehouse implementations, descriptions of the latest warehouse-related products, and announcements of conferences and other events.a. The Data Warehousing Institute:
Visit an organization that has developed a data warehouse and interview the data administrator or other key participant. Discuss the following issues:a. How satisfied are users with the data warehouse?In what ways has it improved their decision making?b. Does the warehouse employ a three-tier
GROUP BY by itself creates subtotals by category, and the ROLLUP extension to GROUP BY creates even more categories for subtotals. Using all the orders, do a rollup to get total order amounts by product, sales region, and month and all combinations, including a grand total. Display the results
Because data warehouses and even data marts can become very large, it may be sufficient to work with a subset of data for some analyses. Create a sample of orders from 2004 using the SAMPLE SQL command (which is standard SQL);put a randomized allocation of 10% of the rows into the sample. Include
Using the MDIFF “ordered analytical function” in Teradata SQL (see the Functions and Operators manual), show the differences (label the difference CHANGE) in TOTAL(which you calculated in the previous Problem and Exercise)from quarter to quarter. Hint: You will likely create a derived table
Take the query you scrapped from Problem and Exercise 22 and modify it to show only the U.S. region grouped by each quarter, not just for 2005 but for all years available, in order by quarter. Label the total orders by quarter with the heading TOTAL and the region ID simply as ID in the
The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TSN.Most business intelligence tools generate SQL to retrieve the data they need to produce the reports and charts and to run the models users
Review the metadata file for the db_samwh database and the definitions of the database tables. (You can use SHOW TABLE commands to display the DDL for tables.) Are dimension table conformed in this data mart? Explain.
Review the metadata file for the db_samwh database and the definitions of the database tables. (You can use SHOW TABLE commands to display the DDL for tables.) Explain what dimension data, if any, are maintained to support slowly changing dimensions. If there are slowly changing dimension data, are
Review the metadata file for the db_samwh database and the definitions of the database tables. (You can use SHOW TABLE commands to display the DDL for tables.)Explain the methods used in this database for modeling hierarchies. Are hierarchies modeled as described in this chapter?
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.Problems and Exercises 19 through 26 deal with the Sales Analysis Module data mart available on Teradata Student Network
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 into the individual types of policies to see how sales are broken down by type of policy. What type of tool
Customers may have relationships with one another(e.g., spouses, parents and children). Redesign your answer to Problem and Exercise 15 to accommodate these relationships.
Agents change territories over time. If necessary, redesign your answer to Problem and Exercise 14 to handle this changing dimensional data.
Would you prefer to normalize (snowflake) the star schema of your answer to Problem and Exercise 13? If so, how and why? Redesign the star schema to accommodate your recommended changes.
Create a star schema for this case study. How did you handle the time dimension?
Visit www.teradatastudentnetwork.com and download the dimensional modeling tool located under the downloadable software section. (Your instructor will have to give you the current password to access this site.) Use this tool to draw your answers to Problems and Exercises 3, 5, 6, and 9.Write a
Visit www.ralphkimball.com and locate Kimball University Design Tip 37.Study this design tip and draw the dimensional model for the recommended design for a “pipeline”application for university admissions.
A food manufacturing company needs a data mart to summarize facts about orders to move goods. Some orders transfer goods internally, some are sales to customers, some are purchases from vendors, and some are returns of goods from customers. The company needs to treat customers, vendors, plants, and
As mentioned in the chapter, Kimball (1997), Inmon (1997, 2000), and Armstrong (2000) have debated the merits of independent and dependent data marts and normalized versus denormalized data marts. Obtain copies of these articles from your library or from online sources and summarize the arguments
Millennium College (see Problem and Exercise 3) now wants to include new data about course sections: the department offering the course, the academic unit to which the department reports, and the budget unit to which the department is assigned. Change your answer to Problem and Exercise 3 to
Simplified Automobile Insurance Company would like to add a Claims dimension to its star schema (see Problem and Exercise 5). Attributes of Claim are ClaimID, ClaimDescription, and ClaimType. Attributes of the fact table are now PolicyPremium, Deductible, and MonthlyClaimTotal.a. Extend the star
You are to construct a star schema for Simplified Automobile Insurance Company (see Kimball, 1996b, for a more realistic example). The relevant dimensions, dimension attributes, and dimension sizes are as follows:Facts to be recorded for each combination of these dimensions are PolicyPremium,
Having mastered the principles of normalization described in Chapter 4, you recognize immediately that the star schema you developed for Millennium College (Problem and Exercise 3)is not in third normal form. Using these principles, convert the star schema to a snowflake schema. What impact (if
Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows:The only fact that is to be recorded in the fact table is CourseGrade.a. Design a star schema for this problem. See Figure 9-10
The following table shows some simple student data as of the date 06/20/2010:The following transactions occur on 06/21/2010:• Student 004 changes major from Math to Business.• Student 005 is deleted from the file.• New student 006 is added to the file: Name is Jim, Major is Phys Ed.The
Examine the three tables with student data shown in Figure 9-1.Design a single-table format that will hold all of the data(nonredundantly) that are contained in these three tables.Choose column names that you believe are most appropriate for these data.
In what ways are a data staging area and an enterprise data warehouse different?
One of the claimed characteristics of a data warehouse is that it is nonupdateable. What does this mean?
Explain the most common approach used to handle slowly changing dimensions.
What is the meaning of the phrase “slowly changing dimension”?
What is a hierarchy as it relates to a dimension table?
In what ways are dimension tables often not normalized?
Can a fact table have no nonkey attributes? Why or why not?
What is the purpose of conformed dimensions for different star schemas within the same data warehousing environment?
Why is time almost always a dimension in a data warehouse or data mart?
Showing 1800 - 1900
of 3225
First
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Last
Step by Step Answers
Get 50% OFF
Claim Now
