New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Modern Database Management 13th Global Edition Jeff Hoffer, Ramesh Venkataraman, Heikki Topi - Solutions
. 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.
. Explain why an index is useful only if there is sufficient variety in the values of an attribute.
. 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.
. 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.
. Explain the reasons why some experts are against the practice of denormalization.
. Why would a database administrator create multiple tablespaces? What is its architecture?
. Explain why it makes sense to first go through the normalization process and then denormalize.
. Explain why normalized relations may not comprise an efficient physical implementation structure.
. Describe three ways to handle missing field values.
. What is a partition view in Oracle? What are its limitations?
. Why must access frequencies be more precisely defined?
. What is the role of a DBA? List various regulations and standards for physical database design and their functions.
. Identify some limitations of normalized data as outlined in the text.
. What is a translation or code table? When it should be implemented, and what are its advantages?
. What decisions have to be made to develop a field specification?
. What are the key decisions in physical database design?
. What are the major inputs into physical database design?
. Contrast the following terms:a. horizontal partitioning; vertical partitioningb. repository; data dictionaryc. physical file; tablespaced. before image; after imagee. normalization; denormalizationf. range control; null control g. transaction log; database change log h. secondary key; primary key
. Match the following terms to the appropriate definitions:extent hashing algorithm rollback index checkpoint facility physical record pointer data type physical file database recoverya. a detailed coding scheme for representing organizational datab. a data structure used to determine in a file the
. Define each of the following terms:a. file organizationb. heap file organizationc. sequential file organizationd. indexed file organizatione. hashed file organizationf. denormalization g. composite key h. secondary key i. data type j. data dictionary k. transaction log l. encryption
. 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.
. 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 your proof of concept using your technological recommendations (or using the environment that your instructor asks you to use).
. Provide a document that provides your recommendation on the set of technologies (DBMS, programming language, Web server [if appropriate]) that you believe are best suited for FAME. Ensure that this document has some information on the options you considered and provides a solid justification for
. Revisit your deliverable for question 1-52, Chapter 1, and reread the case descriptions in Chapters 1 through 3 with an eye toward identifying the functionality you want to provide to the various stakeholders. Document the subset of functionality (with your instructor’s guidance if
. 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.
. 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.
. Visit the PHP website (php.net) and investigate how a failure to sanitize database inputs can leave a database exposed to online attack.
. 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.
. 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
b. Identify the various security considerations that are relevant to each environment.
. Examine the two applications shown in Figures 7-5a and
. List and discuss five areas where threats to data security may occur.
. 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?
. What is the difference between shared locks and exclusive locks?
. What is the advantage of optimistic concurrency control compared with pessimistic concurrency control?
. Visit an online retailer such as Amazon or eBay and explain the system’s design using the MVC paradigm.
. 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.
. Rewrite the example shown in Figures 7-10 through 7-14 using Java.
. Rewrite the example shown in Figure 7-6 using Python or PHP.
. Discuss some of the languages that are associated with Internet application development. Classify these languages according to the functionality they provide for each application. It is not necessary that you use the same classification scheme used in the chapter.7-14. Search the Internet for
. 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.
. 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?
. 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
. What are the typical components in a Python program that enables a dynamic Web site contain?
. 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 six common steps needed to access databases from a typical program?
. What is database-oriented middleware? What does it consist of?
. Describe the advantages and disadvantages of three-tier architectures.
. Contrast the following terms:a. two-tier architecture; three-tier architectureb. fat client; thin clientc. optimistic concurrency control; pessimistic concurrency controld. deadlock prevention; deadlock resolutione. shared lock; exclusive lockf. two-phase locking protocol; versioning
. List several major advantages of the client/server architecture compared with other computing approaches.
. Match each of the following terms with the most appropriate definition:client/server system application program interface(API)a. a client that is responsible for processing, including application logic and presentation logicb. a PC configured for handling the presentation layer and some business
. Define each of the following terms:a. application partitioningb. application program interface (API)c. client/server systemd. middlewaree. three-tier architecturef. locking g. versioning h. deadlock
. Create a strategy for reviewing your database implementation with the appropriate stakeholders. Which stakeholders should you meet with? What information would you bring to this meeting? Who do you think should sign off on your database implementation before you move to the next phase of the
. Identify opportunities for using triggers in your database and write the appropriate DDL queries for them.
. Write and execute queries for the various reports and displays you identified as being required by the various stakeholders in 5-98 in Chapter 5. 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
. 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?
. 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.
. For each product, display in ascending order, by product ID, the product ID and description, along with the customer ID and name for the customer who has bought the most of that product; also show the total quantity ordered by that customer (who has bought the most of that product).Use a
. The head of marketing is interested in some opportunities for cross-selling of products. She thinks that the way to identify cross-selling opportunities is to know for each product how many other products are sold to the same customer on the same order (e.g., a product that is bought by a
. Display employee information for all the employees in each state who were hired before the most recently hired person in that state.
. Display in product ID order the product ID and total amount ordered of that product by the customer who has bought the most of that product; use a derived table in a FROM clause to answer this query.
. Write an SQL query to list the salesperson who has sold the most computer desks.
. Write an SQL query to list the order number, product ID, and ordered quantity for all ordered products for which the ordered quantity is greater than the average ordered quantity for that product.
. List the IDs and names of those sales territories that have at least 50 percent more customers as the average number of customers per territory.
. List the IDs and names of all products that cost less than the average product price in their product line.
. Review the first query in the “Correlated Subqueries” section.Can you identify a special set of standard prices for which this query will not yield the desired result? How might you rewrite the query to handle this situation?
. 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.
. Display the customer names of all customers who have ordered (on the same or different orders) both products with IDs 3 and 4.
. Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.
. Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.
. Rewrite your answer to Problem and Exercise 6-71 for each customer, not just customer 16.
. Display the name of customer 16 and the names of all the customers that are in the same zip code as customer 16.(Be sure this query will work for any customer.)
. Display the EmployeeID and EmployeeName for those employees who do not possess the skill Router. Display the results in order by EmployeeName. Show how you constructed this query using a Venn or other type of diagram.
. Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once.
. Write an SQL query to produce a list of all the products(i.e., product description) and the number of times each product has been ordered. Show how you constructed this query using a Venn or other type of diagram.
. Display the names of the states in which customers reside but for which there is no salesperson residing in that state.There are several ways to write this query. Try to write it without any WHERE clause. Write this query two ways, using the set command UNION, INTERSECT, or MINUS and not using
. Display the order IDs for customers who have not made any payment, yet, on that order. Use the set command UNION, INTERSECT, or MINUS in your query.
. The production manager at PVFC is concerned about support for purchased parts in products owned by customers.A simple analysis he wants done is to determine for each customer how many vendors are in the same state as that customer. Develop a list of all the PVFC customers by name with the number
. Write a query to list the number of products produced in each work center (label as TotalProducts). If a work center does not produce any products, display the result with a total of 0.
. Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each finish by each salesperson.
. List, in alphabetical order, the names of all employees(managers) who are now managing people with skill ID BS12; list each manager’s name only once, even if that manager manages several people with this skill.
. Modify Problem and Exercise 6-60 so that the list includes the number of products each customer bought in each product line in March 2018.
. Modify Problem and Exercise 6-59 so that you include the number of products in product line Basic that the customer ordered in March 2018.
. Write an SQL query to list each customer who bought at least one product that belongs to product line Basic in March 2018. List each customer only once.
. Write an SQL query to list each customer who has bought computer desks and the number of units sold to each customer.Show how you constructed this query using a Venn or other type of diagram.
. For every order that has been received, display the order ID, the total dollar amount owed on that order (you’ll have to calculate this total from attributes in one or more tables; label this result TotalDue), and the amount received in payments on that order (assume that there is only one
. Calculate the total raw material cost (label TotCost) for each product compared to its standard product price.Display product ID, product description, standard price, and the total cost in the result.
. 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.
Showing 1100 - 1200
of 3225
First
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Last
Step by Step Answers
Get 50% OFF
Claim Now
