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

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