Questions and Answers of Modern Database Management 13th Edition

Q:

Does normalization place any constraint on the storage of data in physical form or on its processing performance?Explain.

Q:

What do you understand by domain constraint?

Q:

Outline a shortcut to describe relations in 3NF.

Q:

Discuss how transitive dependencies in a relation can be removed when it leads to anomalies.

Q:

List the three steps to remove transitive dependencies.

Q:

What is an enterprise key, and why is it important?

Q:

Why is the natural key preserved whenever a surrogate key is created?

Q:

What are the benefits of the use of an enterprise key?

Q:

Contrast the following terms:a. Scalar aggregate; vector aggregateb. DDL; DMLc. Catalog; schema

Q:

What are the primary data integrity constraints in SQL?

Q:

How do you determine the order in which the rows in a response to an SQL query appear? What options do you have when specifying this order?

Q:

How is the HAVING clause different from the WHERE clause?

Q:

State four rules for choosing indexes for a relational database.

Q:

How can an SQL command be structured to allow parallel execution?

Q:

Use SQL to define the following view:

Q:

Write SQL queries to answer the following questions:a. For each course included in the QUALIFIED table, list Course ID and the number of faculty

Q:

What are the Tutor IDs for tutors who have not yet tutored anyone?

Q:

How many students were matched with someone in the first five months of the year?

Q:

List the number of customers living at each state that is included in the Customer_T table.

Q:

For each payment made on or after March 10, 2018, list PaymentID, OrderID, PaymentAmount, and the first 10characters of Payment Comment.

Q:

What type of an impact has the significant decrease in the cost of storage space had on data warehouse and data mart design?

Q:

Describe the mechanism through which prescriptive analytics is dependent on descriptive and predictive analytics.

Q:

Research available data quality software. Describe in detail at least one technique employed by one of these tools (e.g., an expert system).

Q:

Contrast the following terms:a. Two-tier architecture; three-tier architectureb. Fat client; thin clientc. Optimistic concurrency control;

Q:

List the average number of customers per state (including only the states that are included in the Customer_T table).A query can be used as a table

Q:

Contrast the following terms:a. Horizontal partitioning; vertical partitioningb. Repository; data dictionaryc. Physical file; tablespaced. Before

Q:

Using the Web and Internet resources, search for the application areas of parallel processing. Which DBMS in the market supports this feature?

Q:

Denormalization can be a controversial topic among database designers. Some believe that any database should be fully normalized (even using all the

Q:

Visit the database designer or administrator of an organization that has heavy transaction-oriented applications and requires frequent updates to

Q:

Visit an organization that has implemented a database approach. Evaluate each of the following:a. The organizational placement of data

Q:

Visit an organization that has implemented a database approach and interview an MIS department employee who has been involved in disaster recovery

Q:

Visit an organization that has implemented a database approach and interview individuals there about the security measures they take routinely.

Q:

Contact the DBA of an organization you are familiar with. Interview them to understand how they collect, manage, and utilize metadata. Do they store

Q:

Visit the database designer or administrator of an organization that conducts e-business. Ask them if they have ever experienced database downtime.

Q:

The text lists a number of cloud service providers that offer traditional data management services like MS SQL database, Amazon RDS, and cloud

Q:

Why does an information gap still exist despite the surge in data in most firms?

Q:

List the issues that one encounters while achieving a single corporate view of data in a firm.

Q:

Explain the need to separate operational and information systems.

Q:

Why is it important to consolidate a Web-based customer interaction in a data warehouse?

Q:

List the 10 essential rules for dimensional modeling.

Q:

What is meant by a corporate information factory?

Q:

List the different roles played by data marts and data warehouses in a data warehouse environment.

Q:

Explain the components of a star schema with figures and suitable examples.

Q:

Explain how the characteristics of data for data warehousing is different from the characteristics of data for operational databases.

Q:

Why is real-time data warehousing called active data warehousing?

Q:

Discuss the role of an enterprise data model and metadata in the architecture of a data warehouse.

Q:

List and describe the various situations in which it becomes essential to further normalize dimension tables.

Q:

A table Student stores the values StudentID, name, date of result, and total marks obtained. A student’s information is: StudentID: S876, Name:

Q:

Define each of the following terms:a. Hadoopb. MapReducec. HDFSd. NoSQLe. Pig

Q:

Contrast the following terms:a. Data lake; data warehouseb. Pig; Hivec. Volume; velocityd. NoSQL; SQL

Q:

What are the two challenges faced in visualizing big data?

Q:

What is the format that can be used to describe database schema besides JSON?

Q:

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

Q:

What is the trade-off one needs to consider while using a NoSQL database management system?

Q:

Discuss the features of NoSQL DBMS that ensure high availability but do not guarantee consistency.

Q:

How does HDFS aid in coping with hardware failure?

Q:

HDase and Cassandra share a common purpose. What is it? What is their relationship to HDFS and Google BigTable?

Q:

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

Q:

Define each of the following terms:a. Data miningb. Online analytical processingc. Business intelligenced. Predictive analyticse. Apache Spark

Q:

Contrast the following terms:a. Data mining; text miningb. ROLAP; MOLAPc. R; Python

Q:

Discuss the different types of dashboards and their role in business performance management.

Q:

Illustrate the goals of data mining and how they answer fundamental business questions

Q:

Discuss why data mining applications are growing rapidly in business.

Q:

How is KNIME used as a predictive analytics tool?

Q:

How is data quality and management vital in realizing the full potential of big data and analytics?

Q:

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),

Q:

How does Apache Spark differ from Hadoop?

Q:

Compare and contrast R and Python as computational environments for analytics.

Q:

Briefly describe three types of operations that can easily be performed with OLAP tools.

Q:

Using a drawing tool such as Microsoft PowerPoint, design a simple prototype of a top-management dashboard for Fitchwood Insurance Company.

Q:

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

Q:

Another tool featured on TUN is called Tableau. Tableau offers a student version of its product for free (www.tableausoftware.com/academic/students),

Q:

Contrast the following terms:a. Chief data officer; DBAb. Data administration; database administrationc. Open source DBMS; commercial DBMSd. ETL; MDM

Q:

Why are data administrators required to maintain an information repository?

Q:

What functions require the input and involvement of both the data administrator and the database administrator?

Q:

How can the data capture process be improved?

Q:

What functions require the input and involvement of both the data administrator and the database administrator?

Q:

Explain how an organization’s business rules can be checked as part of a data audit.

Q:

How can fuzzy logic, pattern matching, and expert systems be used to improve data quality?

Q:

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

Q:

The European Union has recently applied the General Protection of Data Regulation, which governs the way firms doing business in the European Union

Q:

Visit libereurope.eu/webinars/and write a report on the key current issues effecting data management.

Q:

Following on from Question 12-42, visit the European Union’s General Data Protection Regulation Web site and discuss how the new regulation will

Q:

Visit an organization that uses an open-source DBMS. Why did the organization choose open-source software? Does it have other open-source software

Q:

Explain how TQM techniques can help in improving data quality.

Q:

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?

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

Figure 10-14 describes a simple Hadoop architecture. If a real-world system is implemented using this approach, it will suffer from a specific

Q:

Assume that the following data regarding Students need to be stored—Name: First Name and Last Name, Roll Number, and Mobile Number Illustrate with

Q:

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”

Q:

Research some tools that perform data scrubbing. What tool would you recommend for the Fitch wood Insurance Company?

Q:

Create a star schema for this case study. How did you handle the time dimension?

Q:

A pharmaceutical retail store manages its current sales, procurement, and materials availability at the store through Excel sheets. Owing to the

Q:

A firm wants to reduce fluid drilling costs substantially by increasing drilling fluid efficiency. Research finds that both fluid drilling speed and

Q:

Explain through common examples why determining grain is critical.

Q:

Visit an organization that has implemented a database management system and interview concerned individuals about the standards and regulations used

Showing 1 - 100 of 269

1
2
3

Join SolutionInn Study Help for

2 Million+ Textbook Solutions

Learn the step-by-step answers to your textbook problems, just enter our Solution Library containing more than 2 Million+ textbooks solutions and help guides from over 1300 courses.

24/7 Online Tutors

Tune up your concepts by asking our tutors any time around the clock and get prompt responses.

Start Membership