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

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 scheme of drilling fluid. A research study identifies the following factors which impact drilling
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 capture stage? What are the alternate approaches to handling such missing 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 destination. This booking reference also states the number of air miles eligible, which can also be
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 how they convert the diagram into relations. How do they impose integrity constraints? What was the
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 3NF relations.
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 price of at least $500.P&E 5-67Display the product line ID and the average standard price for all
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 (everything except the last three characters) is called material type. For each material type, list the
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 teach ISM 3113? when working with NoSQL databases?
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 systems analyst or database administrator for this.
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 price.
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 Web form in HTML that takes students’ names, email addresses, and contact numbers as input. The
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.
Visit an online retailer such as Amazon or eBay and explain the system’s design using the MVC paradigm.
What is the advantage of optimistic concurrency control compared with pessimistic concurrency control?
Investigate the computing architecture of your university. Trace the history of computing at your university and determine what path the university followed to get to its present configurations. Some universities started early with mainframe environments; others started when PCs became available.
On a smaller scale than in Field Exercise 7-25, investigate the computing architecture of a department within your university. Try to find out how well the current system is meeting the department’s information-processing needs.Exercise 7-25Investigate the computing architecture of your
Visit the PHP website (php.net) and investigate how a failure to sanitize database inputs can leave a database exposed to online attack.
Outline the steps you would take to conduct a risk assessment for your place of employment with regard to attaching a database to your public site. If possible, help with the actual implementation of the risk assessment.
Determine what you would have to do to use Python or JSP on a public Web site owned either by you or by the organization for which you work.
Make an appointment to interview your school, college, or university database administrator. Find out the most common forms attacks perpetuated internally and outside the organization. Compare these threats against the British Computer Society’s list of top 10 database attacks at its Web site
According to your own personal interests, use one of the common combinations PHP/Python and MySQL or JSP and Oracle to attach a database to your personal Web site. Test it locally and then move it to your public site.
Write an SQL query that lists the vendor ID, vendor name, material ID, material name, and supply unit prices for all those materials that are provided by more than one vendor.
Conduct a Web search on security issues relating to poorly designed SQL. Identify the most common ones and suggest what measures can be taken to address them.
Compare two versions of SQL to which you have access, such as Microsoft Access and Oracle. Identify at least five similarities and three dissimilarities in the SQL code from these two SQL systems. Do the dissimilarities cause results to differ?
Write and execute queries for the various reports and displays you identified as being required by the various stakeholders. Make sure you use both subqueries and joins. Your instructor may specify for which reports or displays you should write queries, how many queries you are to write, and their
Create your proof of concept using your technological recommendations (or using the environment that your instructor asks you to use).
Create a testing strategy (including user acceptance testing) for your proof of concept. Which stakeholders should you involve in the phase? Who do you think should sign off on the testing phase before you move to full-fledged deployment?
Create a deployment/rollout strategy for your system within FAME. Ensure that your deployment strategy includes a plan for training, conversion/loading of existing data into the new system, and postimplementation support.
List four reasons why an instance of a relational schema should be created with sample data.
Briefly outline the seven steps of transforming an EER diagram into the associated relations.
What is a schema? Discuss two common methods of expressing a schema.
List the three components of a relational data model.
Discuss why the E-R model is a popular modeling tool.
What differentiates data lakes from traditional data warehouses?
For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-to many or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.a. STUDENT and COURSE (students register
Talk with a database administrator or designer from the organization. What type of metadata does this organization maintain about its databases? Why did the organization choose to keep track of these and not other metadata? What tools are used to maintain these metadata?
You are the manager of a department in a small logistics company. The current database system being used is hi rarchical, and you have been tasked to formulate a team that can create a plan to develop a more efficient database system that is consistent with modern database theory. Devise a plan
Determine the company’s use of intranet, extranet, or other Web-enabled business processes. For each type of process, determine its purpose and the database management system that is being used in conjunction with the networks. Ask what the company’s plans are for the next year with regard to
Consider a major database in this organization, such as one supporting customer interactions accounting, or manufacturing. What is the architecture for this database? Is the organization using some form of client/server architecture? Interview information systems managers in this organization to
In the section “Disadvantages of File Processing Systems,” the statement is made that the disadvantages of file processing systems can also be limitations of databases, depending on how an organization manages its databases. First, why do organizations create multiple databases, not just one
What problems may be encountered when developing new programs without designing a database management system?
Contrast transactional and analytical data management approaches.
Think of an organizational database in which some of the fields in the CUSTOMER table must have the following data types. Explain they mean and they are used.a. Customer ID (auto-numeric field)b. Customer Name (text field)c. Fee Paid (logical field)d. Pay Date (date field)
Consider a book rental system in a comic store. When a customer borrows or returns a comic book, the shopkeeper needs to note down the transaction or update the corresponding record on the transaction book.a. Draw an enterprise data model for this book rental system.b. Identify the type of

Showing 900 - 1000 of 1037

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

Step by Step Answers