Modern Database Management 12th Global Edition Topi Hoffer, Venkataraman - Solutions

Discover comprehensive resources for "Modern Database Management 12th Global Edition" by Topi Hoffer and Venkataraman. Access our online answers key and solutions manual to enhance your understanding of database management concepts. Our solutions PDF provides step-by-step answers and solved problems for each chapter, ensuring you grasp every detail. Explore our test bank and instructor manual for additional questions and answers, perfect for exam preparation. Download the textbook and chapter solutions for free and enjoy a seamless learning experience. Elevate your skills with our expertly crafted content, available for free download.

Interview a systems analyst in a local company who uses object-oriented programming and systems development tools. Ask to see any analysis and design diagrams the analyst has drawn of the database and applications.Compare these diagrams to the ones in this chapter.What differences do you see? What
Ask a database administrator or database or systems analyst in a local company to show you an EER (or E-R)diagram for one of the organization’s primary databases.Translate this diagram into a class diagram.
Visit two local small businesses, one in the service sector and one in manufacturing. Interview employees from these organizations to obtain examples of both superclass/subclass relationships and operational business rules (such as “A customer can return merchandise only if the customer has a
Interview a friend or family member to elicit common examples of superclass/subclass relationships. You will have to explain the meaning of this term and provide a common example, such as PROPERTY: RESIDENTIAL, COMMERCIAL; or BONDS: CORPORATE, MUNICIPAL.Use the information your interviewee provides
In the Pine Valley Furniture class diagram, is there a need to add any derived associations or derived relationships?If so, please redraw the diagram to represent this.
Pine Valley Furniture Company has implemented electronic payment methods for some customers. These customers will no longer require an invoice. The sendInvoice and receivePayment methods will still be used for those customers who always pay by cash or check.However, a new method is needed to
Assume that at Pine Valley Furniture Company, each product (described by product number, description, and cost) is composed of at least three components(described by component number, description, and unit of measure), and components are used to make one or many products. In addition, assume that
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):A facilities management unit on a corporate campus is responsible for a number of tasks associated with the maintenance of the physical facilities of the
In Chapter 9, we presented a case study for the Fitchwood Insurance Agency. As you may recall, we developed the E-R diagram shown in Figure 14-25 for this agency.Convert this E-R diagram into a class diagram. State any assumptions that you make.
Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation:Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that
Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation:Emerging Electric wishes to create a database with the following classes and attributes:Customer with attributes customerID, name, address(street, city, state, zipCode),
An organization has been entrusted with developing a registration and title system that maintains information about all vehicles registered in a particular state. For each vehicle that is registered with the office, the system has to store the name, address, and telephone number of the owner; the
Refer to the class diagram for hospital relationships(Figure 14-9b). Add notation to express the following business rule: A resident patient can be assigned a bed only if that patient has been assigned a physician who will assume responsibility for the patient’s care.
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:CHECKING acctNo, dateOpened, balance, serviceCharge SAVINGS acctNo, dateOpened, Balance, interestRate LOAN acctNo, dateOpened, Balance, interestRate, payment Assume that each bank
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):SeeALeopard (SAL) is a company that organizes tours in the Kruger National Park in South Africa. These tours last several hours and sometimes an entire
Draw a class diagram to model the following situation(state any assumptions you believe you have to make in order to develop a complete diagram, and add any attributes that you believe are necessary to provide the specified service):A landscaping company offers snow removal services in a region
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):A consulting firm is organized as a partnership with five different types of employees: senior partners, junior partners, senior associates, associates, and
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):A nonprofit organization depends on a number of different types of persons for its successful operation.The organization is interested in the following
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):A library has a large number of items that customers can borrow. In addition to books, the collection includes audio products (audio CDs, books on CD, and
Imagine two different types of airline frequent flyer programs: one that awards points based on flown miles and gives free trips based on accumulated mileage according to a predefined awards schedule (e.g., domestic roundtrip in economy requires 25,000 miles, a roundtrip between North America and
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):A company bottles and distributes bottled water to both private consumers and organizations. The firm wants to develop an application to support the delivery
Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram):Stillwater Antiques buys and sells one-of-a-kind antiques of all kinds (e.g., furniture, jewelry, china, and clothing). Each item is uniquely identified by an
Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, but if a student’s assigned adviser is not available, the student may register with
Refer to Figure 4-36 (originally presented in the context of Problem and Exercise 4-48), which uses an E-R diagram to describe the essential business constructs of a middlesized software vendor.a. Present the same situation with a class diagram.b. Based on what you have learned about class diagrams
A student, whose attributes include studentName, address, phone, and age, may engage in multiple campus-based activities. The university keeps track of the number of years a given student has participated in a specific activity and, at the end of each academic year, mails an activity report to the
Draw a class diagram for some organization that you are familiar with—Boy Scouts/Girl Scouts, a sports team, and so on. In your diagram, indicate names for at least four association roles.
The class diagram shown in Figure 14-24 is an example of _________. Is the relationship between faculty and their department represented properly in this diagram?Why or why not?
The class diagram shown in Figure 14-23 is an example of _________.
In the class diagram shown in Figure 14-22, checkFee and monthlyFee are examples of _________ attributes.What type of an operation is calcFee?
In the class diagram shown in Figure 14-21, what do we call/availBalance? What do we call/purchases? Why are these used in this diagram?
When would a unary relationship need to be represented as an association class?
In the diagram shown in Figure 14-20, what do we call the Assignment class?
Why does the UML provide the user with several different types of diagrams?
Given the class diagram shown in Figure 14-19, can we have an instance of Vehicle? Why or why not?
What makes the object-oriented modeling approach a powerful tool for developing complex systems?
Give an example of aggregation. Your example should include at least one aggregate object and three component objects. Specify the multiplicities at each end of all of the aggregation relationships.
Using (and, if necessary, extending) the diagram from your solution to Review Question 14-12, give an example of polymorphism.
If the diagram you developed for Review Question 14-12 does not contain an abstract class, extend the diagram by adding an abstract class that contains at least one abstract operation. Also, indicate which features of a class other classes inherit.
Give an example of generalization. Your example should include at least one superclass and three subclasses and a minimum of one attribute and one operation for each of the classes. Indicate the discriminator and specify the semantic constraints among the subclasses. What is the purpose of the
Add operations to some of the classes you identified in Review Question 14-8.
Add role names to the association relationships you identified in Review Question 14-8.
Explain the difference between the name of the association relationship and the role names linked to an association.
Using a class diagram, give an example for each of the following types of relationships: unary, binary, and ternary.Specify the multiplicities for all the relationships.
State the conditions under which a designer should model an association relationship as an association class. In what way is the expressive power of an association class stronger than that of an ordinary association relationship?
In many cases, a model drawn using a UML class diagram expresses exactly the same characteristics of the real-world situation as an EER model would. Even if this is the case, using the UML could potentially provide significant benefits in the broader system development context. Why and under which
Compare the object-oriented model with the EER model.
State the activities involved in each of the following phases of the object-oriented development life cycle:object-oriented analysis, object-oriented design, and object-oriented implementation.
Contrast the following terms:a. class; objectb. attribute; operationc. state; behaviord. operation; methode. query operation; update operationf. abstract class; concrete class g. class diagram; object diagram h. association; aggregation i. generalization; aggregation j. aggregation; composition k.
Define each of the following terms:a. classb. statec. behaviord. encapsulatione. operationf. method g. constructor operation h. query operation i. update operation j. abstract class k. concrete class l. abstract operation m. multiplicity n. class-scope attribute o. association class p. polymorphism
Specify different types of business rules in a class diagram.
Recognize when to use generalization, aggregation, and composition relationships.
Provide a snapshot of the detailed state of a system at a point in time, using a UML object diagram.
Model a real-world domain by using a Unified Modeling Language (UML) class diagram.
Compare the object-oriented model with the E-R and EER models.
State the advantages of object-oriented modeling vis-à-vis structured approaches.
Describe the activities in the different phases of the object-oriented development life cycle.
Visit an organization that uses a large-scale enterprise system (such as an ERP, SCM, or CRM) from multiple locations. Find out what type of a database distribution approach the organization has chosen to adopt.
Visit an organization that has installed a client/server database environment. Explore the following questions:a. What distributed database features do the client/server DBMSs in use offer?b. Is the organization attempting to achieve the same benefits from a client/server environment as are
Investigate the database product offerings from popular DBMS vendors such as IBM, Oracle, Microsoft, etc.Identify the key distributed database features that each product provides.
Visit an organization that has installed a distributed database management system. Explore the following questions:a. Does the organization have a truly distributed database?If so, how are the data distributed: via replication, horizontal partitioning, or vertical partitioning?b. What commercial
Assume that an organization operates using a model in which most of its employees are either telecommuting from home or working from client sites all the time. What type of impact would this model operation have on the selection of your data distribution strategies?
How would your database distribution strategy planning process change if you could assume that you have unlimited, error-free bandwidth between all the locations from which the data have to be accessed?
Assume that PVFC has expanded its operations significantly and added sales offices in both Stuttgart, Germany, and Moscow, Russia. Each of these sales offices has about 10 staff members, and their primary role is to manage the collaboration between PVFC and its regional distributors in their
Management has decided to add an additional warehouse for customers west of the Mississippi. Items that are not custom built are shipped from this warehouse.Custom-built and specialty items are shipped from the manufacturing facility. What additional tables and changes in distribution strategy, if
Certain items are available to only international customers and customers on the East Coast. How would this change your distribution strategy?
Assuming that management decides on a distributed database, what data distribution strategy would you recommend?
Management would like to consider utilizing one centralized database at the manufacturing facility that can be accessed via a wide area network from the remote order processing center. Discuss the advantages and disadvantages of this.
Pine Valley Furniture has opened up another office for receiving and processing orders. This office will deal exclusively with customers west of the Mississippi River.The order processing center located at the manufacturing plant will process orders for customers west of the Mississippi River as
Research the Web for relevant articles on Web services and how they may impact distributed databases. Report on your findings.
How would your overall distribution strategy differ if this were an OLTP system instead of a data mart?
How would your strategy change for Problem and Exercise 13-36 if management did not want agents to have a copy of any data but their own? Explain how you would accomplish this.
The sales and marketing organization would like to enable agents to access the data mart in order to produce commission reports and to follow up on clients. Assuming that there are 30 different offices, what strategy would you recommend for distributing the data mart? What if there were 150 of them?
Explain how you would accomplish weekly updates of the data mart if a distributed database were justified.
Assuming that a distributed database is justified, what would you recommend for a data distribution strategy?Justify your decision.
Assume that the data mart needs to be accessed by Fitchwood’s main office as well as its service center in Florida. Keeping in mind that data are updated weekly, would you recommend a distributed database, a centralized database, or set of decentralized databases? State any assumptions.
Consider the following normalized relations for a database in a large retail store chain:STORE (StoreID, Region, ManagerID, SquareFeet)EMPLOYEE (EmployeeID, WhereWork, EmployeeName, EmployeeAddress)DEPARTMENT (DepartmentID, ManagerID, SalesGoal)SCHEDULE (DepartmentID, EmployeeID, Date)Assume that a
Consider the SUPPLIER, PART, and SHIPMENT relations and distributed database mentioned in the section on query optimization in this chapter.a. Write a global SQL query (submitted in Columbus) to display the PartNumber and Color for every part that is not supplied by a supplier in Chicago.b. Design
Do any of the six query-processing strategies in Table 13-2 utilize a semijoin? If so, explain how a semijoin is used. If not, explain how you might use a semijoin to create an efficient query-processing strategy or why the use of a semijoin will not work in this situation.
Explain the major factors at work in creating the drastically different results for the six query-processing strategies outlined in Table 13-2.
Speculate on why you think a truly heterogeneous distributed database environment is difficult to achieve. What specific difficulties exist in this environment?
Consider the four parts databases in Figure 13-9.a. Write an SQL statement that will increase the Balance in PartNumber 98765 in Tulsa Parts by 20 percent and another SQL statement that will decrease the Balance in PartNumber 12345 in New York Parts by 20 percent.b. Indicate whether the statement
Consider the Standard Price List in Figure 13-9.a. Write an SQL statement that will increase the UnitPrice of PartNumber 98756 by 10 percent.b. Indicate whether the statement you wrote in part a is acceptable under each of the following:• Remote unit of work• Distributed unit of work•
Name the type of transparency (location, replication, failure, concurrency) that is indicated by each statement.a. End users in New York and Tulsa are updating the Engineering Parts database in San Mateo at the same time. Neither user is aware that the other is accessing the data, and the system
Briefly explain the conditions that suggest the use of a semijoin will result in faster distributed query processing
Briefly describe the three steps in distributed query processing.
Briefly describe three improvements to the two-phase commit protocol.
Briefly explain in what way two-phase commit can still fail to create a completely consistent distributed database.
Briefly explain the effect of replication transparency on an author of an ad hoc database query.
Briefly explain the effect of location transparency on an author of an ad hoc database query.
Briefly describe six unique functions performed by a distributed database management system.
Briefly describe five factors that influence the selection of a distributed database design strategy.
Explain the advantages and disadvantages of vertical partitioning for distributed databases.
Explain the advantages and disadvantages of horizontal partitioning for distributed databases.
Briefly describe five factors that influence whether data replication is a viable distributed database design strategy for an application.
Explain under what circumstances a near-real-time replication approach would be best.
Explain under what circumstances a snapshot replication approach would be best.
Briefly describe two disadvantages to the data replication form of distributed databases.
Briefly describe five advantages to the data replication form of distributed databases.
Briefly describe four costs and disadvantages of distributed databases.
Briefly describe five advantages for distributed databases compared with centralized databases.

Showing 1 - 100 of 3225

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last

Modern Database Management 12th Global Edition Topi Hoffer, Venkataraman - Solutions

Step by Step Answers