Questions from Database Management


Q: Assume that the following data regarding Students need to be stored—

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 da...

See Answer

Q: Figure 10-14 describes a simple Hadoop architecture. If a

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 wha...

See Answer

Q: Review Figure 10-15 and answer the following questions based on

Review Figure 10-15 and answer the following questions based on it. a. What has happened between Input and Input’? b. Assume that the values associated with each of the keys (k1, k2,...

See Answer

Q: For each situation presented below, illustrate a document as depicted in

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 hyp...

See Answer

Q: Write two HIVE queries, the first to create a PRODUCT table

Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name, Seller, Price; the second to load data into the table from file ProductInfo.csv. Make all necessary assumptions.

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. Revisit your deliverable for question 1-52, Chapter 1, and reread the case descriptions in Chapters 1 through 3 with an eye toward id...

See Answer

Q: Use the Internet to browse the features and offerings of Big Data

Use the Internet to browse the features and offerings of Big Data platforms such as HAVEn and Aster. Prepare a report of your findings.

See Answer

Q: Consider the customer table created in Figure 10-24 and populated

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 averag...

See Answer

Q: For each scenario listed below, identify the following: the type

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 po...

See Answer

Q: Review the white paper that has been used as a source for

Review the white paper that has been used as a source for Figure 10-33. Which of the following tasks is the responsibility of data platform, integrated data warehouse, and integrated discovery platfor...

See Answer