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
computer sciences
databases
Modern Database Management 12th edition Jeff Hoffer, Ramesh Venkataraman, Heikki Topi - Solutions
What are the four common approaches to storing XML data?
What is XSLT, and how does it differ from XML? What role does it play in the creation of a Web application?
Why is HTML5 beneficial for developing mobile applications?
You have been asked to prepare a report that evaluates possible client/server solutions to handle a new customer application system for all branch offices. What business characteristics would you evaluate? What technology characteristics would you evaluate? Why?
Explain the difference between a static Web site and a dynamic one. What are the characteristics of a dynamic Web site that enable it to better support the development of e-business?
Historically, what types of applications have moved quickly to client/server database systems? What types have moved more slowly, and why? What do you think will happen in the future to the ratio of client/ server database systems versus mainframe database systems?
Match each of the following terms with the most appropriate definition:
Discuss some of the languages that are associated with Internet application development. Classify these languages according to the functionality they provide for each application. It is not necessary that you use the same classification scheme used in the chapter.
Rewrite the example shown in Figure 8-5 using VB.NET.
Rewrite the example shown in Figure 8-4 using Java.
Consider the example code shown in Figure 8-10. Assume that instead of accessing data from a local server, you are going to access data from a cloud provider that offers the appropriate application server (i.e., JSP) and database technologies. What changes, if any, do you have to make to the
Construct a simple XML schema that describes a tutor. Include the tutor's last name, first name, phone, e-mail address, and certification date as child elements of the TUTOR element.
Using your schema from Problem and Exercise 8-27 write an XSLT program to display the tutor information in the form of an HTML table.Exercise 8-27Construct a simple XML schema that describes a tutor. Include the tutor's last name, first name, phone, e-mail address, and certification date as child
List several major advantages of the client/server architecture compared with other computing approaches.
Locate three sites on the Web that have interactive database systems attached to them. Evaluate the functionality of each site and discuss how its interactive database system is likely to affect that functionality. If you're not sure where to start, try www.amazon.com.
Contrast the following terms:a. Two-tier architecture; three-tier architectureb. Fat client; thin clientc. ODBQJDBCd. SOAP; XSLTe. SQL; XQueryf. Web services; SOA
Describe the advantages and disadvantages of two-tier architectures.
Describe the advantages and disadvantages of three-tier architectures.
Describe the common components needed to create a Web-based application.
What are the six common steps needed to access databases from a typical program?
Define each of the following terms:a. Data warehouseb. Data martc. Reconciled datad. Derived datae. Enterprise data warehousef. Real-time data warehouseg. Star schemah. Snowflake schemai. Grainj. Conformed dimension
List the ten essential rules for dimensional modeling.
List four objectives of derived data.
Is a star schema a relational data model? Why or why not?
Explain how the volatility of a data warehouse is different from the volatility of a database for an operational information system.
Explain the pros and cons of logical data marts.
What is a helper table, and why is it often used to help organize derived data?
Describe the characteristics of a surrogate key as used in a data warehouse or data mart.
Why is time almost always a dimension in a data warehouse or data mart?
What is the purpose of conformed dimensions for different star schemas within the same data warehousing environment?
In what ways are dimension tables often not normalized?
Match the following terms and definitions: a. Lost previous data content b. Detailed historical data c. Data not altered or deleted d. Data warehouse of limited scope e. Dimension and fact tables f. Level of detail in a fact table g. Data filled from a warehouse h. structure that results from
What is a hierarchy as it relates to a dimension table?
What is the meaning of the phrase "slowly changing dimension"?
Explain the most common approach used to handle slowly changing dimensions.
Describe the current key trends in data warehousing.
The following table shows some simple student data as of the date 06/20/2015:The following transactions occur on 06/21/2015:• 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
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:CourseSection……………………..Attributes: CourselD, SectionNumber, CourseName, Units, RoomID, and RoomCapacity. During a
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 4-30) is not in third normal form. Using these principles, convert the star schema to a snowflake schema. What impact (if
Contrast the following terms:a. Transient data; periodic datab. Data warehouse; data mart; operational data storec. Reconciled data; derived datad. Fact table; dimension tablee. Star schema; snowflake schemaf. Independent data mart; dependent data mart; logical data martg. Status versus event data
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 PohcyPremium,
Simplified Automobile Insurance Company would like to add a Claims dimension to its star schema (see Problem and Exercise 9-30). Attributes of Claim are ClaimID, ClaimDescription, and ClaimType. Attributes of the fact table are now PolicyPremium, Deductible, and MonthlyClaimTotal.a. Extend the star
Millennium College (see Problem and Exercise 9-28) 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 9-28 to
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
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
Visit www.kimballgroup.comand 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.
Visit www.teradatauniversitynetwork.comand download the dimensional modeling tool located under the downloadable software section. Use this tool to draw your answers to Problems and Exercises 9-28, 9-30, 9-31, and 9-34. Write a report that comments on the usefulness of this modeling tool. What
Pine Valley Furniture wants you to help design a data mart for analysis of sales. The subjects of the f data mart are as follows: Salesperson……………………..Attributes: Salespersons, Years with PVFC, SalespersonName, and
Create a star schema for this case study. How did you handle the time dimension?Fitchwood Insurance Company, which is primarily involved in the sale of annuity products, would like to design a data mart for its sales and marketing organization. Presently, the OLTP system is a legacy system residing
List the five major trends that necessitate data warehousing in many organizations today.
Agents change territories over time. If necessary, redesign your answer to Problem and Exercise 9-39 to handle this changing dimensional data.Fitchwood Insurance Company, which is primarily involved in the sale of annuity products, would like to design a data mart for its sales and marketing
Customers may have relationships with one another (e.g., spouses, parents and children). Redesign your answer to Problem and Exercise 9-40 to accommodate these relationships.Fitchwood Insurance Company, which is primarily involved in the sale of annuity products, would like to design a data mart
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?
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
The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business intelligence tools generate SQL to retrieve the data they need to produce the reports and charts and to run the models users
Take the query you scrapped from Problem and Exercise 9-45 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 result.
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 based
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 percent of the rows into the sample.
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
Briefly describe the major components of a data warehouse architecture.
List the three types of metadata that appear in a three-layer data warehouse architecture and briefly describe the purpose of each.
List four characteristics of a data warehouse.
List five claimed limitations of independent data marts.
List two claimed benefits of independent data marts.
Define each of the following terms: a. Static extract b. Incremental extract c. Chief data officer d. Master data management e. Refresh mode
Describe the key steps to improve data quality in an organization.
What is data profiling, and what role does it play in a data quality program?
How can data capture processes be improved to improve data quality?
Why is master data management important in an organization?
Describe the three major approaches to master data management.
What distinguishes master data management from other forms of data integration?
List six typical characteristics of reconciled data.
List and briefly describe five steps in the data reconciliation process.
Match the following terms and definitions: Data transformation a. converts data formats Data scrubbing b. correct errors in source data Selection c. partitioning of data based on predefined criteria Data steward d. oversees data quality for a particular data subject Changed data
List five errors and inconsistencies that are commonly found in operational data.
Explain how the phrase "extract-transform-load" relates to the data reconciliation process.
List common tasks performed during data cleansing.
Describe some field-level and record-level data trans-formations that often occur during the ETL process for loading a data warehouse.
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-21? How often should the extraction process be performed? Should it be a static extract or an
What types of data pollution/cleansing problems might occur with the Fitchwood OLTP system data?
What types of data transformations might be needed in order to build the Fitchwood data mart?
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
Any successful data governance program needs to address the people ("who"), ("how"), and technology ("what") aspects. Based on your reading of Chapter 10, provide some examples for each of these categories.
Contrast the following terms: a. Static extract; incremental extract b. Data scrubbing; data transformation c. Consolidation; federation d. ETL; master data management
Examine the set of activities in Table 10-2 and categorize them as belonging to one of the following categories: people ("who"), process ("how"), and technology ("what").
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. Your instructor can make those databases available to you. Alternatively, these and other databases
On page 424, we identified four dimensions along which poor data might impact a business. For a company of your choice, for example, a hospital, identify one or more scenarios that could serve as a good example for each type of impact.
What are the key components of a data governance program? How does data stewardship relate to data governance?
What are four reasons why data quality is important to an organization?
Explain the effect of the Sarbanes-Oxley Act on the need for organizations to improve data quality.
Define the eight characteristics of quality data.
Explain four reasons why the quality of data is poor in many organizations.
Define each of the following terms:a. Hadoopb. MapReducec. HDFSd. NoSQLe. Pigf. Data miningg. Online analytical processingh. Business intelligence
JSON is widely used in the context of NoSQL databases. What is its primary role?
Why is massively parallel processing very important in the context of big data?
Explain the core principle of the MapReduce algorithm.
Explain the progression from decision support systems to analytics through business intelligence.
Describe the differences between descriptive, predictive, and prescriptive analytics.
Match the following terms to the appropriate definitions: _______ Hive a. knowledge discovery using a variety of statistical and computational techniques _______ Text mining b. analytics that suggests mechanisms for achieving desired outcomes _______ Data lake c. tool that provides an SQL-like
Discuss the impact that the emergence of Internet of Things will have on the need for advanced big data and analytics technologies.
Showing 1900 - 2000
of 3228
First
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Last
Step by Step Answers
Get 50% OFF
Claim Now
.png)
![import java.sql.*; public class TestJDBC { public static void main(String[] args) { try { Driverd = (Driver)Class.forNam](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/images/question_images/1552/4/7/9/9215c88f6b1b04461552479920334.jpg)
.png)
.png)
