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 12th Global Edition Topi Hoffer, Venkataraman - Solutions
An investment in drilling often occupies one-third to twothird of the total cost while exploring for fluid. Advances in drilling technology can reduce these costs substantially. They key point is redesigning the scheme of drilling fluid. A research study identifies the following factors which
The following table shows some simple album and price data as of the date 07/18/2015:Key Album Price(in dollars)K1 Superhits 5 K2 1990s 4 K3 Beatles 10 K4 Classics 8 K5 AllTime 6 The following transactions occur on 07/19/2015:• Album K3 price discounted to $7.• Album K5 is deleted from the
Examine the three tables with student data shown in Figure 9-1.Design a single-table format that will hold all of the data (nonredundantly) that are contained in these three tables. Choose column names that you believe are most appropriate for these data.
Describe the current key trends in data warehousing.
Why should changes be made to the data warehouse design? What are the changes that need to be accommodated?
In relation to star schema fact tables, what is meant by grain, size, multiple and factless fact tables?
Explain the most common approach used to handle slowly changing dimensions.
Discuss the benefits of real-time data warehousing.
What is a hierarchy as it relates to a dimension table?
In what ways are dimension tables often not normalized?
What is the purpose of conformed dimensions for different star schemas within the same data warehousing environment?
Discuss the role of enterprise data model and metadata in architecture of a data warehouse.
Describe the characteristics of a surrogate key as used in a data warehouse or data mart.
How does dependent data marts address the limitations of independent data marts?
Explain the pros and cons of logical data marts.
Explain how the volatility of a data warehouse is different from the volatility of a database for an operational information system.
Is a star schema a relational data model? Why or why not?
What is meant by a corporate information factory?
List the ten essential rules for dimensional modeling.
Why is it important to consolidate a Web-based customer interaction in a data warehouse?
List five claimed limitations of independent data marts.
List four characteristics of a data warehouse.
List the issues that one encounters while achieving a single corporate view of data in a firm.
Briefly describe the factors which have lead to the evolution of a data warehouse.
Despite the surge in data in most firms, why does the information gap still exist?
Contrast the following terms:a. transient data; periodic datab. data warehouse; data mart; operational data storec. reconciled data; derived datad. fact table; dimension tablee. star schema; snowflake schemaf. independent data mart; dependent data mart; logical data mart g. status versus event data
Define each of the following terms:a. data warehouseb. data martc. reconciled datad. derived datae. enterprise data warehousef. real-time data warehouse g. star schema h. snowflake schema i. grain j. conformed dimension
Understand the trends that are likely to affect the future of data warehousing in organizations.
Develop the requirements for a data mart from questions supporting decision making.
Design a data mart using various schemes to normalize and denormalize dimensions and to account for fact history, hierarchical relationships between dimensions, and changing dimension attribute values.
Estimate the number of rows and total size, in bytes, of a fact table, given reasonable assumptions concerning the database dimensions.
Describe the two major components of a star schema.
Name and briefly describe the three levels in a data warehouse architecture.
List two major reasons most organizations today need data warehousing.
Give two important reasons why an “information gap” often exists between an information manager’s need and the information generally available.
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 post-implementation 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 towards identifying the functionality you want to provide to the various stakeholders. Document the subset of functionality (with your instructor’s guidance, if appropriate)
Identify a Web site that extensively describes XML technologies. What other XML technologies besides the ones described in this chapter do you see being discussed?What purpose do they serve? If you’re not sure where to start, try www.xml.com or www.w3.org
According to your own personal interests, use one of the common combinations PHP and MySQL, JSP and Oracle, or ASP.NET and Microsoft Access 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 PHP, JSP, or ASP.NET on a public Web site owned either by you or by the organization for which you work.
Locate three sites on the Web that have interactive database systems attached to them. Evaluate the functionality of each site and discuss how its interactive database system is likely to affect that functionality. If you’re not sure where to start, try www.amazon.com.
On a smaller scale than in Field Exercise 8-31 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 available.
Use the Internet to research on how UDDI can be used by firms for web services. What is the role of WSDL when used with UDDI? Search for at least one example from industry where UDDI and WSDL are used.
Using your schema from Problem and Exercise 8-27 to write an XSLT program to display the student information in the form of an HTML table.
Using your schema from Problem and Exercise 8-27 to write an FLWOR XQuery expression that lists only the students’names as well as lists them alphabetically by last name.
Construct a simple XML schema that describes a student.Include the StudentID (only 4 digits), date of birth, name, telephone (12 digits with the pattern XXXX-XXX-XXX) as child elements of the STUDENT element.
Identify at least 3 examples from the Internet, each from a different industry, where firms have utilized cloud services. How did they benefit from its usage compared to what they were using it for earlier? Which type of cloud services discussed in this chapter are they using?
Consider the example code shown in Figure 8-10.What changes would you need to make to ensure that the application works on mobile phone browsers?
Consider the example code shown in Figure 8-10.Assume that instead of accessing data from a local server, you are going to access data from a cloud provider that offers the appropriate application server (i.e., JSP) and database technologies. What changes, if any, do you have to make to the example
Rewrite the example shown in Figure 8-4 using Java.
Rewrite the example shown in Figure 8-5 using VB.NET.
Find some dynamic Web site code such as that included in Figures 8-10, 8-11, and 8-12.Annotate the code, as is done in these figures, to explain each section, especially the elements that involve interaction with the database. (Hint: Google “JSP,” “ASP.NET,” or “PHP MySQL Examples” to
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.
Identify some interactive applications around you, such as at your university, which requires access to database for fetching content or information. Look for the middleware used in these applications. You may need to interview system analyst or database administrator for this.
Search the Internet for some examples of dynamic websites other than e-commerce sites. What can be the limitations of a dynamic website when compared to a static website?
Suppose your university is offering a few courses in Business Analytics: a six months certificate course, a twoyear regular program, and a three-year part-time program.You are required to design a Web form in HTML which takes the students’ names, email addresses, and contact numbers as input. The
What is the need for Web services? Which XML-based protocols aid in transformation and communication of data into and out of application programming and database?
How can cloud computing affect you as a database application developer? What are its characteristics?
Which techniques are used to validate whether a XML document is structured correctly.
What components must a PHP program that enables a dynamic Web site contain?
Which points should application developers keep in mind in order to create a stable high-performance three-tier applications with the database components?
What are the three common types of cloud computing services?
What are the advantages of PHP? Discuss the drawbacks of PHP and JSP. What is the role of MVC to overcome these drawbacks?
What are the six common steps needed to access databases from a typical program?
To manage different information flows in a web based application (three-tier architecture), discuss the involvement of its different components.
What is database-oriented middleware? What does it consist of.
Describe the advantages and disadvantages of three-tier architectures.
Describe the advantages and disadvantages of two-tier architectures.
Contrast the following terms:a. two-tier architecture; three-tier architectureb. fat client; thin clientc. ODBC; JDBCd. SOAP; XSLTe. SQL; XQueryf. Web services; SOA
List several major advantages of the client/server architecture compared with other computing approaches.
Define each of the following terms:a. application partitioningb. application program interface (API)c. client/server systemd. middlewaree. stored proceduref. three-tier architecture g. Open Database Connectivity (ODBC)h. XML Schema i. Web services j. XSLT k. SOAP
Explain how XML has led to the spread of Web services and the emergence of service-oriented architectures.
Understand how XQuery can be used to query XML documents.
Explain the purpose of XML and its uses in standardizing data exchange across the Internet.
Describe how to connect to databases in a three-tier Web application using Java Server Pages (JSP), PHP, and ASP.NET.
Describe the key components of a Web application and the information flow between the various components.
Describe how to connect to databases in a two-tier application in VB.NET and Java.
Distinguish between two-tier and three-tier architectures.
Explain the three components of client/server systems: data presentation services, processing services, and storage services.
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 6-90 in Chapter 6. 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
Compare two versions of SQL to which you have access, such as Microsoft Access and Oracle SQL*Plus. 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 search of the Web to locate as many links as possible that discuss SQL standards.
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 customer
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 and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product. (Hint: This involves using a correlated subquery.)
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?
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.
Showing 300 - 400
of 3225
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last
Step by Step Answers
Get 50% OFF
Claim Now
