chapter 1 © 2013 pearson education, inc. publishing as prentice hall chapter 1: the database...
DESCRIPTION
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Components of the Database Environment CASE Tools – computer-aided software engineering Repository – centralized storehouse of metadata Database Management System (DBMS) – software for managing the database Database – storehouse of the data Application Programs – software using the data User Interface – text and graphical displays to users Data/Database Administrators – personnel responsible for maintaining the database System Developers – personnel responsible for designing databases and software End Users – people who use the applications and databasesTRANSCRIPT
![Page 1: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/1.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Chapter 1:The Database Environment and Development Process
(Contd..)
Modern Database Management11th Edition
Jeffrey A. Hoffer, V. Ramesh, Heikki Topi
![Page 2: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/2.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Elements of the Database Approach
Data models Graphical system capturing nature and relationship of data Enterprise Data Model–high-level entities and relationships for the
organization Project Data Model–more detailed view, matching data structure in
database or data warehouse Entities
Noun form describing a person, place, object, event, or concept Composed of attributes
Relationships Between entities Usually one-to-many (1:M) or many-to-many (M:N)
Relational Databases Database technology involving tables (relations) representing entities
and primary/foreign keys representing relationships
![Page 3: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/3.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Components of the Database Environment
CASE Tools–computer-aided software engineering Repository–centralized storehouse of metadata Database Management System (DBMS) –software for
managing the database Database–storehouse of the data Application Programs–software using the data User Interface–text and graphical displays to users Data/Database Administrators–personnel responsible for
maintaining the database System Developers–personnel responsible for designing
databases and software End Users–people who use the applications and databases
![Page 4: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/4.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Figure 1-5 Components of the Database Environment
![Page 5: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/5.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Enterprise Data Model
First step in the database development process Specifies scope and general content Overall picture of organizational data at high level of
abstraction Entity-relationship diagram Descriptions of entity types Relationships between entities Business rules
![Page 6: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/6.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
FIGURE 1-6 Example business function-to-data entity matrix
6Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 7: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/7.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Segment of an enterprise data model
Segment of a project-level data model
Figure 1-3 Comparison of enterprise and project level data models
7Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 8: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/8.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
One customer may place many orders, but each order is placed by a single customer
One-to-many relationship
8Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 9: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/9.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
One order has many order lines; each order line is associated with a single order
One-to-many relationship
9Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 10: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/10.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
One product can be in many order lines, each order line refers to a single product
One-to-many relationship
10Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 11: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/11.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Therefore, one order involves many products and one product is involved in many orders
Many-to-many relationship
11Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 12: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/12.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall 12Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 13: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/13.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Two Approaches to Database and IS Development
SDLC System Development Life Cycle Detailed, well-planned development process Time-consuming, but comprehensive Long development cycle
Prototyping Rapid application development (RAD) Cursory attempt at conceptual data modeling Define database during development of initial prototype Repeat implementation and maintenance activities with
new prototype versions
![Page 14: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/14.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
![Page 15: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/15.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
Planning Purpose–preliminary understandingDeliverable–request for study
Database activity– enterprise modeling and early conceptual data modeling
![Page 16: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/16.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
Analysis
Purpose–thorough requirements analysis and structuring
Deliverable–functional system specifications
Database activity–thorough and integrated conceptual data modeling
![Page 17: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/17.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical DesignLogical Design
Purpose–information requirements elicitation and structure
Deliverable–detailed design specifications
Database activity– logical database design (transactions, forms, displays, views, data
integrity and security)
![Page 18: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/18.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
Physical Design
Purpose–develop technology and organizational specifications
Deliverable–program/data structures, technology purchases, organization redesigns
Database activity– physical database design (define database to DBMS, physical data organization, database processing programs)
![Page 19: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/19.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
Implementation
Purpose–programming, testing, training, installation, documenting
Deliverable–operational programs, documentation, training materials
Database activity– database implementation, including coded programs, documentation, installation and conversion
![Page 20: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/20.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Systems Development Life Cycle(see also Figure 1-7) (cont.)
Planning
Analysis
Physical Design
Implementation
Maintenance
Logical Design
Maintenance
Purpose–monitor, repair, enhance
Deliverable–periodic audits
Database activity– database maintenance,
performance analysis and tuning, error
corrections
![Page 21: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/21.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Prototyping Database Methodology(Figure 1-8)
21Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 22: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/22.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Prototyping Database Methodology
(Figure 1-8) (cont.)
22Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 23: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/23.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Prototyping Database Methodology
(Figure 1-8) (cont.)
23Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 24: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/24.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Prototyping Database Methodology
(Figure 1-8) (cont.)
![Page 25: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/25.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Prototyping Database Methodology
(Figure 1-8) (cont.)
25Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 26: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/26.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Evolution of Database Systems
Driven by four main objectives: Need for program-data independence
reduced maintenance Desire to manage more complex data types
and structures Ease of data access for less technical
personnel Need for more powerful decision support
platforms
![Page 27: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/27.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Figure 1-10a Evolution of database technologies
![Page 28: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/28.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
The Range of Database Applications
Personal databases Two-tier and N-tier Client/Server databases Enterprise applications
Enterprise resource planning (ERP) systems Data warehousing implementations
![Page 29: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/29.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Figure 1-11 Two-tier database with localarea network
29Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 30: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/30.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Figure 1-12 Three-tiered client/server database architecture
30Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 31: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/31.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Enterprise Database Applications
Enterprise Resource Planning (ERP) Integrate all enterprise functions
(manufacturing, finance, sales, marketing, inventory, accounting, human resources)
Data Warehouse Integrated decision support system derived
from various operational databases
![Page 32: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/32.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
FIGURE 1-13 ComputerSystem for Pine ValleyFurniture Company
32Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall
![Page 33: Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall Chapter 1: The Database Environment…](https://reader035.vdocuments.us/reader035/viewer/2022081512/5a4d1c127f8b9ab0599f76fa/html5/thumbnails/33.jpg)
Chapter 1 © 2013 Pearson Education, Inc. Publishing as Prentice Hall 33