Modern Database Management 13th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions

Contact the DBA of an organization you are familiar with. Interview them to understand how they collect, manage, and utilize metadata. Do they store it using a data repository? If they do use a data repository, do they allow users to create their own passive DD?
Visit the database designer or administrator of an organization that conducts e-business. Ask them if they have ever experienced database downtime. If yes, what were the consequences? Did they suffer a loss of revenue? How did they manage it? Find out how they ensure that database downtime is
The text lists a number of cloud service providers that offer traditional data management services like MS SQL database, Amazon RDS, and cloud services for information systems such as analytics and DM warehouse services. Choose any two cloud service providers that offer traditional
Why does an information gap still exist despite the surge in data in most firms?
List the issues that one encounters while achieving a single corporate view of data in a firm.
Explain the need to separate operational and information systems.
Why is it important to consolidate a Web-based customer interaction in a data warehouse?
List the 10 essential rules for dimensional modeling.
What is meant by a corporate information factory?
List the different roles played by data marts and data warehouses in a data warehouse environment.
Explain the components of a star schema with figures and suitable examples. RELATION 1 (PRIMARY KEY, ATTRIBUTES...) RELATION 2 (PRIMARY KEY, FOREIGN KEY, ATTRIBUTES...) Relational database model Dimension 1 Dimension 2 Dimension 3 Fact Table Dimensions Facts Dimension 4 Dimension 5 Dimension
Explain how the characteristics of data for data warehousing is different from the characteristics of data for operational databases.
Why is real-time data warehousing called active data warehousing?
Discuss the role of an enterprise data model and metadata in the architecture of a data warehouse.
List and describe the various situations in which it becomes essential to further normalize dimension tables.
A table Student stores the values StudentID, name, date of result, and total marks obtained. A student’s information is: StudentID: S876, Name: Sabcd, Date of result: 22/12/14, and Total marks obtained: 650. An update transaction has changed the date and total marks obtained to 15/05/15 and 589,
Define each of the following terms:a. Hadoopb. MapReducec. HDFSd. NoSQLe. Pig
Contrast the following terms:a. Data lake; data warehouseb. Pig; Hivec. Volume; velocityd. NoSQL; SQL
What are the two challenges faced in visualizing big data?
What is the format that can be used to describe database schema besides JSON?
Compare the JSON and XML representations of a record in Figure 10-1. What is the primary difference between these? Can you identify any advantages of one compared to the other? Figure 10-1 JSON Example {"products":[ {"number": 1, "name": "Zoom X", "Price": 10.00}, {"number": 2, "name": "Wheel
What is the trade-off one needs to consider while using a NoSQL database management system?
Discuss the features of NoSQL DBMS that ensure high availability but do not guarantee consistency.
How does HDFS aid in coping with hardware failure?
HDase and Cassandra share a common purpose. What is it? What is their relationship to HDFS and Google BigTable?
Use the Internet to browse the features and offerings of Big Data platforms such as haven and Aster. Prepare a report of your findings.
Define each of the following terms:a. Data miningb. Online analytical processingc. Business intelligenced. Predictive analyticse. Apache Spark
Contrast the following terms:a. Data mining; text miningb. ROLAP; MOLAPc. R; Python
Discuss the different types of dashboards and their role in business performance management.
Illustrate the goals of data mining and how they answer fundamental business questions
Discuss why data mining applications are growing rapidly in business.
How is KNIME used as a predictive analytics tool?
How is data quality and management vital in realizing the full potential of big data and analytics?
For each scenario listed below, identify the following: the type of business analytics, the era of BI&A, the goal of data mining (if applicable), and whether and how big data and analytics have the potential to bring about change in the listed scenario.a. A firm experiencing low sales in a
How does Apache Spark differ from Hadoop?
Compare and contrast R and Python as computational environments for analytics.
Briefly describe three types of operations that can easily be performed with OLAP tools.
Using a drawing tool such as Microsoft PowerPoint, design a simple prototype of a top-management dashboard for Fitchwood Insurance Company.
Teradata University Network (TUN) offers access to a tool called SAS Visual Analytics (VA). Use TUN to access SAS VA and complete some of the exercises associated with the tool to become familiar with it. What are your impressions regarding the usefulness of this type of analytical tool?
Another tool featured on TUN is called Tableau. Tableau offers a student version of its product for free (www.tableausoftware.com/academic/students), and TUN offers several assignments and exercises with which you can explore its features. Compare the capabilities of Tableau with those of SAS
Contrast the following terms:a. Chief data officer; DBAb. Data administration; database administrationc. Open source DBMS; commercial DBMSd. ETL; MDM
Why are data administrators required to maintain an information repository?
What functions require the input and involvement of both the data administrator and the database administrator?
How can the data capture process be improved?
What functions require the input and involvement of both the data administrator and the database administrator?
Explain how an organization’s business rules can be checked as part of a data audit.
How can fuzzy logic, pattern matching, and expert systems be used to improve data quality?
Visit some Web sites for open source databases, such as www.postgresql.org and www.mysql.com. What do you see as major differences in administration between open source databases, such as MySQL, and commercial database products, such as Oracle? How might these differences come into play when
The European Union has recently applied the General Protection of Data Regulation, which governs the way firms doing business in the European Union have to treat and handle the public’s data. Similar legislation is under consideration in countries such as Malaysia, Singapore, and Australia.
Visit libereurope.eu/webinars/and write a report on the key current issues effecting data management.
Following on from Question 12-42, visit the European Union’s General Data Protection Regulation Web site and discuss how the new regulation will affect data stewards and an organization’s data governance committee within academic institutions such as universities. Question 12-42The
Visit an organization that uses an open-source DBMS. Why did the organization choose open-source software? Does it have other open-source software besides a DBMS? Has it purchased any fee-based components or services? Does it have a data administrator or DBA staff, and, if so, how do these people
Explain how TQM techniques can help in improving data quality.
In light of increasing legislation dictating how an organization is to store data, what would be your requirements for the role of chief data officer?
You have been asked to write a brief report on how TQM can be adopted by your organization to improve data quality. Produce a list of reasons why TQM should and should not be adopted, and recommend, with an explanation, an alternative approach to data quality management.
The mail order firm described in Problem and Exercise 12-33 has about 1 million customers. The firm is planning a mass mailing of its spring sales catalog to all of its customers. The unit cost of the mailing (postage and catalog) is $6.00. The error rate in the database (duplicate records,
The average annual revenue per customer for the mail order firm described in Problems and Exercises 12-33 and 12-35 is $100. The organization is planning a data quality improvement program that it hopes will increase the average revenue per customer by 5 percent per year. If this estimate proves
For each situation presented below, illustrate a document as depicted in Figures 10-4 and 10-5 and specify whether it contains an array, an embedded subdocument, relationships, or collections. Use hypothetical data and make necessary assumptions.a. A document containing Books details: Title,
Write two HIVE queries, the first to create a PRODUCT table with fields Prod ID, Name, Seller, Price; the second to load data into the table from file ProductInfo.csv. Make all necessary assumptions.
Figure 10-14 describes a simple Hadoop architecture. If a real-world system is implemented using this approach, it will suffer from a specific weakness. Identify what this weakness is and find out what the latest versions of Hadoop have done to address it.Figure 10-14
Assume that the following data regarding Students need to be stored—Name: First Name and Last Name, Roll Number, and Mobile Number Illustrate with figures how it would be stored in different NoSQL database models
Review Figure 10-5 (a). Write a MongoDB query to display all products with review ratings greater than 3 stars and suppress the fields “height” and “width” in the output using the subset of fields text boxes. { "_id": "1", "name": "OLED TV", "desc": "75in TV", "width":60, "height":
Research some tools that perform data scrubbing. What tool would you recommend for the Fitch wood Insurance Company?
Create a star schema for this case study. How did you handle the time dimension?
A pharmaceutical retail store manages its current sales, procurement, and materials availability at the store through Excel sheets. Owing to the increase in the number of branches in the city, the store manager is now finding this process of data maintenance tedious. She is now banking on the
A firm wants to reduce fluid drilling costs substantially by increasing drilling fluid efficiency. Research finds that both fluid drilling speed and cost are significantly influenced by Time, Geography, Drilling fluid type, Formation, and Well type. Geography refers to Country, Oil field, Block,
Explain through common examples why determining grain is critical.
Visit an organization that has implemented a database management system and interview concerned individuals about the standards and regulations used by the organization for financial reporting and ensuring the security of the IT Infrastructure. How does that organization’s database play a role in
Assume that a bank operates multi-nationally and has millions of financial records of customers in its database. The bank also offers e-banking services to its clients. Based on what you have learned from the book, suggest how they can take regular backups without experiencing downtime, with
Discuss the potential advantages, technical challenges, and disadvantages of using cloud-based database provisioning.
In a normalized database, all customer information is stored in a Customer table, invoices are stored in an Invoice table, and related account manager information in an Employee table. Suppose a customer changes their address and then demands old invoices with manager information. Will
A number of situations have been listed below. For each one, identify the need, if any, to create an index. Justify your answer. If there is indeed a need, suggest a way for the index to be created.a. Banking applications that involve frequent retrieval of the “Account Balance” of customer
Describe and explain the two main components of MapReduce.
What is the role of YARN in the management of highly distributed systems?
Visit www.teradatauniversitynetwork.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
Many organizations are now offering cloud-based data warehousing services such as IBM’s dashDB, Amazon’s Redshift, and Microsoft Azure. Pick any three such firms and, using the Internet, compare them based on the factors listed. Prepare a report based on your findings:• Features• Pricing
Visit an organization that has implemented information systems on a data warehouse, and interview managers to discuss following issues:a. Does increased data collection lead to any information gaps for managers?b. Do they receive information from diverse sources, and how do they increase the
A university gathers student admission data from three different sources: through forms filled manually at university desks, by registering at the university Web site, or by registering on the department’s Web site. All three sources have disparate form structures. Two databases are maintained:
Employees working in IT organizations are assigned different projects for a specific duration, such as a few months or years. The duration is specified by the project start date and end date in the database. The project location is different for each project, so employee location changes with
Discuss the trade-off between improved performance for retrieval through use of indexes and degraded performance due to updates of indexed records in a file.
Consider the customer table created in Figure 10-24 and populated with data as shown in Figure 10-27. Write the Hive script that will display the age-groups that exist in the data set and their average incomes.Figure 10-24Figure 10-27 CREATE TABLE customer (userid INT, gender STRING, salary INT,
Explain the different tools for querying and analyzing data in traditional data warehouses and marts that enable various forms of descriptive analytics.
Explain the three different generations of business intelligence and analytics
For employees who live in TN or FL, list the age at which they were hired.
Locate three database administrator vacancies advertised online and assess the requirements for the position. What is the key knowledge and skill employers require of a database administrator? If you were interested in a career in administration, how would you go about acquiring this essential
Based on your findings, populate the tables in your database with sample data that can potentially allow you to test/demonstrate that your database can generate these reports.
Create an index on the CustomerID column of the Customer_T and Order_T table in Figure 4-4.Figure 4-4 A CustomerID 4 A + + G + + 14 + f Record: H E 16:0 A OrderID # 3 Record: 14 Customer_T CustomerName 1 Contemporary Casuals 2 Value Furniture 3 Home Furnishings 4 Eastern Furniture 5 Impressions 6
Examine the three tables with student data shown in Figure 9-1. Design a single-table format that will hold all of the data (non redundantly) that are contained in these three tables. Choose column names that you believe are most appropriate for these data. Figure 9-1 STUDENT
Why should changes be made to the data warehouse design? What are the changes that need to be accommodated?
What are the two situations in which fact less fact tables may apply?
Consider the following assumptions:• A music company offers three types of music genres: Jazz, Hip-hop, and Metal (subtypes of the Genre supertype). An “Artist” instances “Records” of these Genres.• There are total of 8,000 songs in company’s database, which can be categorized per the
Briefly explain how the dimensions and facts required for a data mart are driven by the context for decision making.
For each of the situations described, decide which technique for data field design listed below would be most\ appropriate and how it could be applied.• Code lookup table• Default value• Range control• Referential integrity• Handling missing dataa. The clients of an investment firm can
A company offering music services provides a search feature to its users and allows them to mix music (a key feature for disc jockeys), which is supported through parallel processing. All music information is stored in a database management system.a. Which file organization would best support
Suggest an application for each type of file organization. Explain your answer.
Specify the format for the Oracle date data type. How does it account for change in century? What is the purpose of ‘TIMESTAMP WITH LOCAL TIMEZONE’? Suppose the system time zone in database in City A = –9:00 and City B = –4:00. A client in City B inserts TIMESTAMP “2004-6-14 7:00:00
Explain why it is essential to scrub data before transformation and how they blend together.
Search the Internet for at least three examples where parallel processing is applied. How was the underlying database prepared for this? What were the advantages of this implementation?
Assume that the table BOOKS in a database with the primary key on Book ID has more than 25,000 records. A query is frequently executed in which the Publisher of the book appears in the WHERE clause. The Publisher field has more than 100 different values, and length of this field is quite long.
Explain the reasons why Data Warehousing 2.0 is necessary.

Showing 800 - 900 of 1037

Modern Database Management 13th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions

Step by Step Answers