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 10th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions
Describe the characteristics of a surrogate key as used in a data warehouse or data mart.
What is a helper table, and why is it often used to help organize derived data?
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?
List four objectives of derived data.
Briefly describe three types of operations that can easily be performed with OLAP tools.
List two claimed benefits of independent data marts.
List five claimed limitations of independent data marts.
List four characteristics of a data warehouse.
List the three types of metadata that appear in a three-layer data warehouse architecture and briefly describe the purpose of each.
Briefly describe the major components of a data warehouse architecture.
List the five major trends that necessitate data warehousing in many organizations today.
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
Define each of the following terms:a. data warehouseb. data martc. reconciled datad. derived datae. online analytical processingf. data mining g. star schema h. snowflake schema i. grain j. conformed dimension
Who is responsible for the quality of data in the data marts, and to whom are requests for changes made?
What drill-down and other data analysis techniques are available?
What reports and predefined queries are available to view the data?
How are the data in the enterprise data warehouse derived from operational data?What rules are used in this derivation?
How are the data in the data mart derived from the enterprise data warehouse data? What rules are used in the derivation?
What dimensions and facts are included in the data mart? What is the grain of the fact table?
What subjects are described in the data mart? (Typical subjects are customers, patients, students, products, courses, and so on.)
what is accounting
Using the MVCH database you created earlier, identify one or two queries and return the data as an XML stream.
Using the MVCH database you created earlier, identify one or two tables and provide the data as XML files.
Web-enable the MVCH database you developed earlier and develop one or more functionalities such as the following:• Online patient registration (e.g., for ambulatory surgery, for Dr. Z’s MS Center, etc.)• Online volunteer application• Login for employees or physicians with a user name and
Assume that Dr. Z’s MS management system uses the same RDBMS that you used for your MVCH database but is currently located on a different database server.a. How could you establish a link to that database?b. What would you need to do to place the database on the same server as the MVCH database
Assume that the MVCH hospital database you developed in SQL Server (or another DBMS designated by your instructor) will be made available to several desktop client applications at the hospital.a. What client and connectivity components are needed in order for the applications to access the
Use the MVCH files you have prototyped to complete this exercise.a. Provide the PATIENT data as an XML file.b. Use XQuery to provide a query related to the PATIENT table.c. Generate a report and, using the XML capabilities in Microsoft Access (e.g., ReportML and an XSLT file), transform the report
The MVCH planning committee is considering several business functions to be accessed via the Web: (1) submitting insurance claims online, (2) providing clinical information to patients online, (3) implementing supply chain management online, (4) providing medical records to other facilities, and
Outline some of the benefits of using thin clients in a hospital setting such as MVCH. Which thin client devices would be most beneficial? Would thin client hardware make it easier to comply with the privacy and security requirements of HIPAA? Why or why not? Would you recommend that MVCH pursue a
Using the information developed in the first two case exercises, do you think MVCH has arrived at the right decision?Defend your answer. Indicate what additional information you would like to have to help you with your analysis.
An alternative approach that has been suggested is to look for a single integrated solution. The study team is examining the Global Care Solutions Hospital 2000 system, a fully integrated hospital information system (HIS). What advantages do you see in adopting a fully integrated health
Outline the advantages and risks/disadvantages of moving toward an integrated Web-based environment based on a three-tier architecture. What do you think would be the most significant challenges with this integration approach?Which specific technologies would you recommend for implementing this
Should MVCH treat the potential implementation of Webbased solutions and Web services as a technology issue or a strategy issue? Please explain.
The health-care industry has not embraced Web services as quickly as other industries for integrating diverse systems.Why do you think that’s the case? What would be critical success factors for making Web services solutions a success at MVCH and other health-care organizations?
Discuss the extent and nature of security and privacy issues that the planning committee should consider when evaluating any decisions to provide more information that is critical to patients over the Web. Why would systems integration be important in terms of addressing HIPAA’s privacy and
Can you think of any other approaches to integration(besides the Web-based approach) that the study team has not considered? If so, what are some alternatives to address the issues at hand?
Do you think that MVCH IT staff under Mr. Heller should and could undertake the project of moving MVCH toward an integrated environment? Should MVCH outsource such a project? Why or why not?
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 Question 1, 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.
Discuss how Web services can be used to effectively integrate business applications and data. Search the Web for resources on current Web services that employ XML, SOAP, UDDI, and WSDL. Find at least three and discuss how each is used, including examples from industry.
Using your schema from Question 8, write an XSLT program to display the tutor information in the form of an HTML table.
Using your schema from Question 8, write an FLWOR XQuery expression that lists only the tutors’ names and lists them alphabetically by last name.
Construct a simple XML schema that describes a tutor.Include the tutor’s last name, first name, phone, e-mail address, and certification date as child elements of the TUTOR element.
Rewrite the example show 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.
Historically, what types of applications have moved quickly to client/server database systems? What types have moved more slowly, and why? What do you think will happen in the future to the ratio of client/server database systems versus mainframe database systems?
Explain the difference between a static Web site and a dynamic one. What are the characteristics of a dynamic Web site that enable it to better support the development of e-business?
You have been asked to prepare a report that evaluates possible client/server solutions to handle a new customer application system for all branch offices. What business characteristics would you evaluate? What technology characteristics would you evaluate? Why?
Discuss UDDI. Compare and contrast it with the white, yellow, and green pages of the telephone book. (If your telephone book does not have green pages, you will need to research this feature found in some telephone books.)
What is XSLT, and how does it differ from XML? What role does it play in the creation of a Web application?
Explain why using XML Schema is a step forward from using document type declarations (DTDs).
What components must a PHP program that enables a dynamic Web site contain?
What are the four common approaches to storing XML data?
Research the Web for information on trends in migrating from mainframe systems to client/server architecture.What percentage of U.S. companies have migrated?Highlight success stories that you encounter, as well as difficulties. A good Web site to start with is www.cs.wisc.edu/arch/www.
If you were charged with developing a client/server application, how would you ensure success?
What are the six common steps needed to access databases from a typical program?
What database APIs are commonly used to access databases from various programming languages?
Describe the common components needed to create a Webbased application.
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. XHTML; 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. Java Database Connectivity (JDBC)h. XML Schema i. Web services j. XSLT k. SOAP
Identify opportunities for using triggers in your database and create at least one DDL trigger. For example, the claims manager at the hospital may need to know that a patient’s health insurance has been updated.
Write and execute the queries for the five reports you identified in Chapter 5.
Review the exercises below and select several to attempt. You will probably need to add to your prototype and populate your tables with sample data in order to test your queries:a. For a given physician, which treatments has that physician performed on each patient referred by that physician to the
Using the small sample database you created for Dr. Z in Case Exercise 1 in Chapter 6, write queries that illustrate the more complex queries covered in this chapter:a. Select information from two or more tables (e.g., all the details of all the visits of a patient, etc.).b. Use subquery syntax
HIPAA’s privacy and security rules mandate audit controls“that record and examine activity in information systems that contain or use electronic protected health information”[§164.312(b)]. How can DDL triggers be used in support of this mandate?
Does your SQL-based DBMS support dynamic SQL, functions, triggers, stored procedures, and UDTs?
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.)
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 customer 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 33 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.
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.
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 any
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 of
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.
Showing 1900 - 2000
of 3225
First
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Last
Step by Step Answers
Get 50% OFF
Claim Now
