100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Test Bank for Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISBN-10: 0134877004, ISBN-13: 9780134877006. All 14 Chapters Updated A+ £11.98   Add to cart

Exam (elaborations)

Test Bank for Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISBN-10: 0134877004, ISBN-13: 9780134877006. All 14 Chapters Updated A+

 7 views  0 purchase
  • Module
  • Institution
  • Book

Test Bank for Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISBN-10: 0134877004, ISBN-13: 9780134877006. All 14 Chapters Updated A+ TABLE OF CONTE NTS I. The Context of Database Management 1. The Database Environment and Development Process II. Database An...

[Show more]

Preview 4 out of 213  pages

  • November 6, 2023
  • 213
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
avatar-seller
Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh




Test Bank for Modern Database Management, 13th
Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki
Topi, ISBN-10: 0134877004, ISBN-13:
9780134877006. All 14 Chapters




Test Bank Page 1

, Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh


Chapter 1 the Database Environment and
Development Process


Chapter Overview

The purpose of this chapter is to introduce students to the world of data management as a whole, and
specifically to the database approach to information systems development, the important concepts and
principles of the database approach, and the database development process within the broader context of
information systems development. This is an important chapter because it conveys a sense of the central
importance of databases and data management in today’s information systems environment and in all
modern enterprises. The idea of an organizational database is intuitively appealing to most students.
However, many students will have little or no background or experience with the technical
implementation of databases. Others will have had some experience with database management systems
intended for personal or workgroup use (such as Microsoft Access). Consequently, they will have a
limited perspective concerning an organizational approach to databases.


In this chapter, we introduce the basic concepts and definitions of databases and data management,
starting with an organizing framework that is new to this chapter. We contrast data with information, and
introduce the notion of metadata and its importance. We also contrast the database approach with older
file processing systems, and introduce the Pine Valley Furniture Company case to illustrate these
concepts. We describe the range of database applications, from databases with a personal or workgroup
scope to enterprise databases, and identify key decisions that must be made for each type of database. We
describe both the potential benefits and typical costs of using the database approach. We also trace the
historical evolution of database systems, in order to provide a context for understanding the database
approach for data storage and retrieval. The chapter outlines the differences between transactional and
informational approaches and highlights the way new, analytics-focused technologies are transforming
data management.


The chapter also presents an expanded description of the systems development life cycle (including an
introduction to rapid application development methods of prototyping and agile software development)
and the role of database development within it. The chapter provides an updated description of the well-


Test Bank Page 2

, Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh

known three-schema architecture and uses it to summarize the various deliverables of database
development. It concludes with an example of database development situated in the context the Pine
Valley Furniture Company case.



Chapter Objectives

Specific student learning objectives are included at the beginning of each chapter. From an instructor’s
point of view, the objectives of this chapter are to:


1. Create a sense of excitement concerning the data and database management field and the
types of job opportunities that are available.
2. Acquaint students with the broad spectrum of database applications and how
organizations are using database applications for competitive advantage.
3. Introduce the data management framework that organizes the book and the conceptual
space of data management, highlighting how relational technologies and non-relational
technologies can be seen as part of the same space.
4. Introduce the key terms and definitions that describe the database environment.
5. Describe data models and how they are used to capture the nature and relationships
among data.
6. Describe the major components of the database environment and how these components
interact with each other.
7. Provide a review of systems development methodologies, particularly the systems
development life cycle, prototyping, and agile software development; build an
understanding of how database development is aligned with these methodologies.
8. Develop an understanding of the different roles within in a database development team.
9. Make students aware of the three-schema architecture and its benefits for database development
and design.
10. Introduce the Pine Valley Furniture Company case, which is used throughout the text to
illustrate important concepts.
11. Introduce the Mountain View Community Hospital case, which is included at the end of
each chapter as a source for student projects.


Test Bank Page 3

, Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh




Key Terms

Agile software development Database Metadata
Conceptual schema Database application Physical schema
Constraint Database management system (D B Project
MS)
Data Enterprise data modeling Prototyping
Data independence Enterprise resource planning (E RP) Relational database

Data model Entity Repository
Data modeling and design tools Information Systems development life cycle (S
DLC)
Data warehouse Logical schema User view




Classroom Ideas
1. Start with a discussion of how students interact with systems built on databases on a daily
basis (credit card transactions, shopping cards, telephone calls, cell phone contact lists,
downloadable music, etc.). If you teach in a classroom with computers, ask students to
find examples of Web sites that appear to be accessing databases.
2. Contrast the terms ―data‖ and ―information.‖ Using Figure 1-1 as a starting point, have
the students provide some good examples of data and information from their own
experiences. This may well lead to some differences of opinion, and the conclusion that
one person’s data may be another person’s information.
3. Introduce the concept of metadata using Table 1-1. Ask the students to suggest other
metadata that might be appropriate for this example.
4. Discuss file processing systems and their limitations, using Figure 1-2 and Table 1-2.
Emphasize that many of these systems are still in use today.
5. Introduce data models using Figure 1-3. Discuss the differences between an enterprise
data model and a project data model, using Figures 1-3 (a) and (b).
6. Discuss each of the advantages of the database approach (Table 1-3). Stress that these
advantages can only be achieved through strong organizational planning and

Test Bank Page 4

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller ASolution. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £11.98. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

85443 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£11.98
  • (0)
  Add to cart