Questions and Answers of Modern Database Management 13th Edition

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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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.
Explain the reasons why Data Warehousing 2.0 is necessary.
Drilling often accounts for one-third to two-thirds of the total cost in the search for fluid. Advances in drilling technology can reduce these costs substantially. The key point is redesigning the
List the functions performed by a Data Warehouse Administrator and explain how they differ from the typical data administrator and database administrator.
Which three techniques form the building blocks of any data integration approach?
Use the Internet to search for examples of each type of horizontal partitioning provided by Oracle. Explain your answer.
Identify possible opportunities for denormalizing these relations as part of the physical design of the database. Which ones would you be most likely to implement
When students fill out forms for admission to various courses or to write their exams, they leave many missing values. This may lead to issues while compiling data. Can this be handled at the data
Explain how data integration is not the only data consolidation technique across an enterprise.
Describe the differences between the IaaS, PaaS, and SaaS models of cloud-based database management solutions.
Explain the role of encryption in data security.
What are the key areas of IT that are examined during a Sarbanes-Oxley audit?
Explain the components of a repository system architecture List and explain the functions supported by a repository engine.
Contrast the uses of a data dictionary and a repository in data and database management.
What are the different elements of a query that can be processed in parallel?
Explain how query writers can improve query processing performance through knowledge of query optimizers.
What role can a query optimizer play in the selection of an optimal set of indexes?
Database servers frequently use one of the many parallel processing architectures. Discuss which elements of a query can be processed in parallel.
State 10 rules of thumb for choosing indexes
How is storage space in a database divided logically by the DBMS? What is the role of a DBA in managing it?
What is the purpose of the EXPLAIN or EXPLAIN PLAN command?
Compare the features of the four families of file organization.
Which index is most suitable for decision support and transaction processing applications that involve online querying? Explain your answer.
Explain data replication, forms of partitioning, and their areas of application.
Why would a database administrator create multiple tablespaces? What is its architecture?
Which employees were hired during 2005?
How many tutors have an Active status in the database?
What is the purpose of the EXPLAIN or EXPLAIN PLAN command?
Analyze the database to determine whether or not it is fully normalized.
Table 4-8 shows extracts from a customer’s flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer id, their flight origin, and final
Obtain an EER diagram from a database administrator or system designer. Based on what you have learned in this book, convert this into a relational schema in 3NF. Now interview the administrator on
Look for a receipt from a supermarket or other retail store you have purchased from. Based on the receipt, draw an EER diagram of the data in this form or report. Transform the diagram into a set of
Does it make sense for FAME to use enterprise keys? If so, create the appropriate enterprise keys and revise the relational schema accordingly.
Modify query in P&E 5-67 by considering only those products the standard price of which is greater than $200. Include in the answer set only those product lines that have an average standard
For each order, display the order ID, the number of separate products included in the order, and the total number of product units (for all products) ordered.
Assume that for those materials the ID of which starts with a numeric character, the last three letters of the ID represent a wood type. Further, assume that the numeric part of Material ID
Measured by average standard price, what is the least expensive product finish?
What is a partition view in Oracle? What are its limitations?
What is the role of a DBA? List various regulations and standards for physical database design and their functions.
What is a translation or code table? When it should be implemented, and what are its advantages?
Why must access frequencies be more precisely defined?
What are the key new features of SQL introduced in SQL:2016?
What are the potential security implications of using embedded or dynamic SQL?
When should we use joining and sub-query techniques?
Why is it not possible to update a base table via update commands against a view?
What can Persistent Stored Modules be used for?
Explain three procedures to enforce data integrity.
Provide three reasons for embedding SQL in a 3GL.
Discuss the new commands that have been incorporated into SQL2007 and SQL2016, and identify the commands they have replaced in previous versions of SQL.
Research a NoSQL database such as Mondo DB or Firebase. Why is it important to consider a metadata-based schema Write an SQL query to answer the following question:Which instructors are qualified to
Write a SQL query to identify all students who have been matched in 2018 with a tutor whose status is Temp Stop.
For each student group, list the number of tutors who have been matched with that group.
List the total number of lessons taught in 2018 by tutors in each of the three Status categories (Active, Temp Stop, and Dropped).
Write an SQL query that will find any customers who have not placed orders.
Write an SQL query to list all product line names and, for each product line, the number of products and the average product price. Make sure to include all product lines separately.
Modify P&E 6-46 to include only those product lines the average price of which is higher than $200.
Search the Internet for some examples of dynamic Web sites other than e-commerce sites. What are the possible limitations of a dynamic Web site compared to a static Web site?
Identify some interactive applications around you that require access to a database to fetch content or information. Look for the middleware used in these applications. You may need to interview a
What is the difference between shared locks and exclusive locks?
Conduct some research to find out how a Java-based application can be connected to a database. Provide some brief code snippets and annotate the code.
How does versioning work in a current database environment? What advantages does versioning offer?
Write an SQL query to display the order number, customer number, order date, and items ordered for some particular customer.
Write an SQL query to display the total number of employees working at each work center (include ID and location for each work center).
Write an SQL query that lists for each vendor (including vendor ID and vendor name) those materials that the vendor supplies where the supply unit prices is at least four times the material standard
What is database-oriented middleware? What does it consist of?
What are the advantages of PHP? Discuss the drawbacks of PHP and JSP. What is the role of MVC in overcoming these drawbacks?
What are the typical components in a Python program that enables a dynamic Web site contain?
Suppose your university is offering some courses in business analytics: a six-month certificate course, a two-year regular program, and a three-year part-time program. You are required to design a
Rewrite the example shown in Figure 7-6 using Python or PHP.Figure 7-6
Select a suitable programming language and outline how a transaction rollback can be coded. Annotate your code to provide clear instructions of what is happening.

Showing 100 - 200 of 269