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

Looking for comprehensive guidance and solutions for "Modern Database Management 10th Edition" by Heikki Topi, Jeffrey A Hoffer, and Ramesh Venkataraman? Discover a wealth of resources including an online answers key, detailed solutions manual, and chapter solutions in PDF format. Our collection of solved problems and step-by-step answers provides an invaluable resource for students and instructors alike. Access the instructor manual, test bank, and textbook solutions to enhance your learning experience. Enjoy the convenience of free download options for seamless study and exploration of questions and answers in this essential guide.

Draw an E-R diagram for the following situation: ShinyShoesForAll(SSFA) is a small shoe repair shop located in a suburban town in the Boston area. SSFA repairs shoes, bags, wallets, luggage, and other similar items.Its customers are individuals and small businesses. The store wants to track the
Consider the two E-R diagrams in Figure 2-25, which represent a database of community service agencies and volunteers in two different cities (A and B). For each of the following three questions, place a check mark under City A, City B, or Can’t Tell for the choice that is the best answer.City A
Draw an ER diagram reflecting the needs of an instructor to monitor their class performance, and include entities such as class performance, grades, and attendance. This ER model will be used by the instructor to build a database for their course in the future.
There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-22 described by that point.
Answer the following questions concerning Figure 2-22:a. Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on it be different in other organizations?b. Why is Includes a one-to-many relationship, and why might this ever be different in some other
For each of the descriptions below, perform the following tasks:i. Identify the degree and cardinalities of each relationship.ii. Express the relationships in each description graphically with an E-R diagram.a. A book is identified by its ISBN number, and it has a title, a price, and a date of
A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets(mobile phones) that they are using. The E-R diagram in Figure 2-24 illustrates the key entities of interest to the operator and the relationships between them.Based on the figure, answer
Why is time stamping considered an important part of the data modeling process?
Explain any two characteristics of a good business rule.
For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship.Based on your description for this example, do you think it is always clear simply from an E-R diagram what the business rule is that
Why is data modeling considered more important than process modeling?
What are the special guidelines for naming relationships?
State a rule that says when to extract an attribute from one entity type and place it in a linked entity type.
Discuss why the E-R model is a popular modeling tool.
Provide examples (other than those described in this chapter) of multiple relationships, and explain why these examples best represent this type of relationship. Discuss the role of identifiers in modeling this relationship.
Give an example (other than those described in this chapter)for each of the following, and justify your answer:a. derived attributeb. multivalued attributec. atomic attributed. composite attributee. composite identifier attributef. optional attribute
State the guidelines for naming entity types. Discuss why organizations customize a purchased data model.
The chapter makes a distinction between a required attribute and an optional attribute. Illustrate a required attribute with a relevant example.
When should an attribute be linked to an entity via a relationship?
Discuss the main guidelines for defining relationships.
What is the need for time stamping in modeling timedependent data?
State the differences between a term and a fact.
State six general guidelines for naming data objects in a data model.
What are the characteristics of good business rules?
Give four reasons why a business rules approach is advocated as a new paradigm for specifying information systems requirements.
Give four reasons why many system designers believe that data modeling is important and arguably the most important part of the systems development process.
Contrast the following terms:a. stored attribute; derived attributeb. minimum cardinality; maximum cardinalityc. entity type; relationship typed. strong entity type; weak entity typee. degree; cardinalityf. required attribute; optional attribute g. composite attribute; multivalued attribute h.
Match the following terms and definitions.composite attribute associative entity unary relationship weak entity attribute entity relationship type cardinality constraint degree Review Questions Key Termsa. uniquely identifies entity instancesb. relates instances of a single entity typec. specifies
Define each of the following terms:a. entity typeb. entity-relationship modelc. entity instanced. attributee. relationship typef. strong entity type g. multivalued attribute h. associative entity i. cardinality constraint j. weak entity k. binary relationship l. derived attribute m. business rule
Create an enterprise data model that captures the data needs of FAME. Use a notation similar to the one shown in Figure 1-4.
Create a memo describing your initial analysis of the situation at FAME as it relates to the design of the database application. Write this as though you are writing a memo to Martin Forondo. Ensure that your memo addresses the following points:a. Your approach to addressing the problem at
You may want to keep a personal journal of ideas and observations about database management while you are studying this book. Use this journal to record comments you hear, summaries of news stories or professional articles you read, original ideas or hypotheses you create, uniform resource locators
Interview one person from a key business function, such as finance, human resources, or marketing. Concentrate your questions on the following items: How does he or she retrieve data needed to make business decisions?From what kind of system (personal database, enterprise system, or data warehouse)
Interview a systems analyst or database analyst and ask questions about how that organization uses data modeling and design tools in the systems development process.Concentrate your questions on how data modeling and design tools are used to support data modeling and database design and how the
Interview a systems analyst or database analyst and ask questions about the typical composition of an information systems development team. Specifically, what role does a database analyst play in project teams? Is a database analyst used throughout the systems development process, or is the
Interview systems and database analysts at this organization.Ask them to describe their systems development process. Which does it resemble more: the systems development life cycle or prototyping? Do they use methodologies similar to both? When do they use their different methodologies? Explore the
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
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
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?
Investigate whether the organization follows more of a traditional file processing approach or the database approach to organizing data. How many different databases does the organization have? Try to draw a figure, similar to Figure 1-2, to depict some or all of the files and databases in this
In this chapter, we described four important data models and their properties: enterprise, conceptual, logical, and physical. In the following table, summarize the important properties of these data models by entering a Y (for yes) or an N (for no) in each cell of the table.Table for Problem and
Consider Figure 1-15.a. What is the purpose of introducing an attribute called Product ID to the Product table? What is its data type?b. If the company wants to keep track of the total outstanding balances of customers, an attribute called “Customer Balances” should be introduced to which table?
Consider the SQL query in Figure 1-20.a. How is Sales to Date calculated?b. How would the query have to change if Helen Jarvis wanted to see the results for all of the product lines, not just the Home Office product line?c. The part of the query starting with WHERE (the so called WHERE clause) has
Answer the following questions concerning Figures 1-18 and 1-19:a. What will be the field size for the ProductLineName field in the Product table? Why?b. In Figure 1-19, how is the ProductID field in the Product table specified to be required? Why is it a required attribute?c. In Figure 1-19,
Consider the project data model shown in Figure 1-16.a. Create a textual description of the diagrammatic representation shown in the figure. Ensure that the description captures the rules/constraints conveyed by the model.b. In arriving at the requirements document, what aspect of the diagram did
Consider Figure 1-15. Explain the meaning of the line that connects CUSTOMER to ORDER and the line that connects ORDER to INVOICE. What does this say about how Pine Valley Furniture Company does business with its customers?
Consider the SQL example in Figure 1-19.a. What is the name of the table that is referred to when the SELECT statement is executed?b. How many tables are accessed when the FROM statement is executed?c. How many conditions are evaluated and met in order to display the details shown in Figure 1-20?
Prototyping is an iterative process of system development in which requirements are converted into a working system that is continually revised by analysts and users.What are the circumstances under which prototyping should be used?
What is the purpose of designing an enterprise data model? How is it different from the design of a particular database?
There are various development approaches in organizations, and the traditional ones have now been complemented by the more innovative system development methods. Much has been said about the prototyping methodology and its radical features in the development cycle. Critically review the prototyping
Consider Figure 1-15. While designing the attributes for the Customer table, is it necessary to designate an attribute, such as Customer ID, as a key field? Can we use an ordinary attribute, such as Customer Name, to determine the existence of a customer record? Why?
Consider the following statement and translate it into SQL:Show me the “First Name,” “Last Name,” and “Company Name” fields from the “Contacts” table where the “City”field contains “Kansas City” and the “First Name” field starts with “R.”
List three additional entities that might appear in an enterprise data model for Pine Valley Furniture Company(Figure 1-3a).
Review the example in Figure 1-2 and 1-4 regarding the differences between the file-based approach and the current database approach. Explain how these differences would impact the relationships between the different entities in the database.
Consider Figure 1-12, which depicts a hypothetical multi-tiered database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise because of this duplication? Does this duplication violate the principles of the database approach
Figure 1-22 shows an enterprise data model for a music store.a. What is the relationship between Album and Store(one-to-one, many-to-many, or one-to-many)?b. What is the relationship between Artist and Album?c. Do you think there should be a relationship between Artist and Store? Describe at least
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
Think of an organizational database in which some of the fields in the CUSTOMER table must have the following data types. Explain what they mean and how 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 the data needs of a small accounting department at a tax services firm. What would some of the data entities be in this setting? List and explain their relevance. Develop a project data model for this firm applying the database design concepts you have learned in the chapter. Explain how
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
Table 1-1 shows example metadata for a set of data items.Identify three other columns for these data (i.e., three other metadata characteristics for the listed attributes) and complete the entries of the table in Table 1-1 for these three additional columns.
You are the manager of a department in a small logistics company. The current database system being used is hierarchical, 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
For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-tomany 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
Explain some of the advantages of large databases that organizations can benefit from considering how the amount of data processed and stored in databases will increase in the future.
Why might Pine Valley Furniture Company need a data warehouse?
Revisit the section titled “Developing a Database Application for Pine Valley Furniture Company.” What phase(s)of the database development process (Figure 1-9) do the activities that Chris performs in the following subsections correspond to:a. Project planningb. Analyzing database
In the three-schema architecture:a. The view of a manager or other type of user is called the schema.b. The view of the data architect or data administrator is called the schema.c. The view of the database administrator is called the schema.
Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.
Explain why certain business environments favor specific database development methodologies. Highlight the pros and cons of each methodology and the differences in the approaches to database development. Do those differences have any impact on the design process?
How does the use of an agile methodology affect decisions regarding data management?
In which of the five phases of the SDLC do database development activities occur?
Name the five phases of the traditional systems development life cycle and explain the purpose and deliverables of each phase.
What differentiates data lakes from traditional data warehouses?
Specify the difference between database solutions supporting enterprise databases and departmental multitiered databases.
A relationship is established between any pair of entities in an enterprise data model. Explain why a relationship is necessary.
Based on Figure 1-5, what are the four perspectives from which you will explore transactional systems in this book?What are the main competencies associated with each of these perspectives?
Figure 1-5 specifies categories for Operational and Informational data management systems. Describe the main difference between these two categories.
A database is referred to as “an organized collection of logically related data.” What does “related data” mean?Why must data be related?
List five costs or risks associated with the database approach.
List 10 potential benefits of the database approach over conventional file systems.
Consider Figure 1-5. What are the two common methods by which users interact with data in a database? Which one is more convenient to users if they do not have an understanding of query language? Why?
Using a table, differentiate between how data is represented in a file processing environment and how it is represented in a relational database.
List the nine major components in a database system environment.
What are the key differences between data warehousing and big data approaches to analytical data management?
Contrast transactional and analytical data management approaches.
What problems may be encountered when developing new programs without designing a database management system?
Contrast the following terms:a. data dependence; data independenceb. structured data; unstructured datac. metadata; datad. repository; databasee. entity; enterprise data modelf. data warehouse; data lake g. personal databases; multi-tiered databases h. systems development life cycle; prototyping i.
Match the following terms and definitions:agile software development database application constraint repository metadata data warehousea. data placed in context or summarizedb. application program(s)c. iterative, focused on working software and customer collaborationd. a graphical model that shows
Define each of the following terms:a. datab. informationc. metadatad. enterprise resource planninge. data warehousef. constraint g. database h. entity i. database management system j. data lake k. systems development life cycle l. prototyping m. enterprise data model n. conceptual data model o.
what is accounting
Interview database administrators in a few organizations and discuss why the use or don’t use object-oriented database management systems. Document the current status and future plans of the organizations.
Review Microsoft’s plans for the future of LINQ. Compare LINQ with JPA and its implementations. What are the factors a decision maker should take into account when choosing between the two?
In this chapter, we discussed three different implementations of the Java Persistence API (JPA) standard. Using resources on the Web, evaluate the current competitive situation between these three. Are there any others that are emerging as potential additional competitors?
Interview database administrators in a few organizations and discuss the mechanisms they have chosen to use for linking object-oriented applications to relational databases. Document the current status and future plans of the organizations.
Find the names and e-mail addresses of the students who took at least one IS course in 2009–2010 or 2010–2011, including in the answer information regarding the number of times the students took a specific course.
Find the names and office locations of those faculty members who taught more than one course in Spring 2010.
Find the names and office locations of those faculty members who taught IS 350 in Spring 2010.
Find the total number of credit hours (together with basic student information) for each of those students who first matriculated in 2008.
Find the average grade earned in IS 460 by students who matriculated in 2008, regardless of when they took the course.
Find the names and matriculation years for those students who are enrolled in IS 440 in Spring 2010.

Showing 1500 - 1600 of 3225

First
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Last

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

Step by Step Answers