14th Edition by Jeffrey A. Hoffer
Complete Chapter Solutions Manual
are included (Ch 1 to 13)
** Immediate Download
** Swift Response
** All Chapters included
** Database Files included
,Table of Contents are given below
1.The Database Environment and Development Process
2.Modeling Data in the Organization
3.The Enhanced E-R Model
4.Logical Database Design and the Relational Model
5.Introduction to SQL
6.Advanced SQL
7.Databases in Applications
8.Physical Database Design and Database Infrastructure
9.Big Data Technologies
10.Modern Data Platforms: Integration, Warehousing and Virtualization
11.Analytics: From Data to Insights
12.Data and Database Administration with Focus on Data Quality
13.Object-Oriented Data Modeling
, Chapter 1 1
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 discuss 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
analytical approaches and highlights the way new, analytics-focused technologies are
transforming data management.
, 2 Modern Database Management, Fourteenth Edition
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-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 followed by a new section on the interconnection
between artificial intelligence and data and database management.
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
nonrelational 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.