![Page 1: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/1.jpg)
Chapter 1:Chapter 1:The Database Environment and The Database Environment and Development ProcessDevelopment Process
Essentials of Database Management
Jeffrey A. Hoffer, Heikki Topi, V. Ramesh
Copyright © 2014 Pearson Education, Inc. 1
![Page 2: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/2.jpg)
2
Basic DB Terms
Data: Meaningful facts, text, graphics, images, sound, video segments A collection of individual responses from a marketing
research
Information: Data processed to be useful in decision making Pattern of geographical buying habit based on analysis of a
marketing research
Metadata: Data that describes data
![Page 3: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/3.jpg)
3
Data in Context
Large volume of facts, difficult to interpret / make decisions
![Page 4: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/4.jpg)
4
Information
Useful for decision making / interpretation
![Page 5: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/5.jpg)
5
Metadata
Descriptions of the properties or characteristics of the data, including data types, field sizes, allowable values, and documentation (Data Dictionary)
![Page 6: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/6.jpg)
6
Universal Database Systems
DBMSDBMS Databasecontainingcentralized
shared data
Application#1
Application#2
Application#3
![Page 7: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/7.jpg)
7
Database Systems
Collection of electronic data Central repository of shared data Stored in a standardized, convenient form. Requires a Database Management System (DBMS)
![Page 8: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/8.jpg)
8
Type of DB Models
File processing system (traditional) Hierarchical Network Relational Object-relational
![Page 9: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/9.jpg)
9
Relational Database
A relational database is a collection of tables that are related to one another based on a common field.
A common field is called a primary key(s). unique identifier in data model
When the primary key of one table is represented in a second table to form a relationship, it is called a foreign key.
![Page 10: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/10.jpg)
10
Relational Database
A schematic diagram of a relational database (a) and a sample part of a relational database showing different tables (b)
![Page 11: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/11.jpg)
11
Relating Tables Using a Common Field
The primary key in the Employer table (EmployerID) is the common field that relates this table to the Position table.
PositionID is the primary key in the Position table. The EmployerID field is a foreign key in this table.
Primary keys can only have one occurrence in a table. Foreign keys may have multiple occurrences.
![Page 12: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/12.jpg)
12
Relational Database
Advantages Easier database design, implementation,
management, and use Ad hoc query capability with SQL Powerful database management system
![Page 13: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/13.jpg)
13
DATABASE MODEL PRODUCT VENDOR HARDWAREHierarchical Focus Information Builders International Mainframe/PC
IMS IBM MainframeRamis Online Software International Mainframe
Network ADABAS Software AG of North America MainframeImage Hewlett-Packard Mainframe
Relational Access Microsoft PCDB2 IBM MainframedBASE V Borland International PCEDA/SQL Information Builders International PCFoxPro Microsoft PCIngres Ask Group PCNOMAD Must Software International Mainframe/PCOracle Oracle Mainframe/PCParadox Borland International PCRbase Microrim PCSQL/DS IBM MainframeSQL Server Microsoft PCSybase Sybase PC
Object-Relational ObjectStore Object Design PCUniversalServer
Informix PC
Illustra Informix PC
![Page 14: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/14.jpg)
14
Database Applications
Personal Database – standalone desktop database
Workgroup Database – local area network (<25 users)
Department Database – local area network (25-100 users)
Enterprise Database – wide-area network (hundreds or thousands of users)
![Page 15: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/15.jpg)
15
Data Warehouse
Collection of historic… NOT current data…
![Page 16: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/16.jpg)
16
Data Mining
• Help to find hidden patterns and relationships in large databases to predict future behavior
– “If a house is purchased, then new refrigerator will be purchased within two weeks 65% of the time.”
![Page 17: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/17.jpg)
17
Components of the DB Environment
![Page 18: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/18.jpg)
18
Components of the DB Environment
CASE Tools – computer-aided software engineering Repository (data dictionary) – centralized storehouse of metadata Database Management System (DBMS) – software for managing the
database Database – storage of the data Application Programs – software using the data User Interface – text and graphical displays to users Database Administrators (DBA) – 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 19: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/19.jpg)
19
Database Development Process
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose – preliminary understanding
Deliverable –request for project
- Is the project worth looking at ?- Is the DB system worth building?
![Page 20: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/20.jpg)
20
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose – state business situation and possible solutionDeliverable –decomposed requirements
Database Development Process
• What do users need and want from the new system?• What the new system must do
![Page 21: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/21.jpg)
21
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose –thorough analysis
Deliverable – conceptual data model
Database Development Process
conceptual data model- next slide
- example model from the web page
![Page 22: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/22.jpg)
22
Conceptual Data Model
![Page 23: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/23.jpg)
23
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose –information requirements structure
Deliverable – logical database design
Database Development Process
1. Hierarchical DB
2. Network DB
3. Relational DB
4. Object Oriented
![Page 24: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/24.jpg)
24
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose –develop technology specsDeliverable – program/data structures, DB technology purchases…
Database Development Process
• Define physical organization of data
![Page 25: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/25.jpg)
25
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose – testing, training, debugging, installation, documentingDeliverable – operational programs, documentation, training materials
Database Development Process
![Page 26: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/26.jpg)
26
Feasibility Study of Project
Requirement Analysis
Conceptual Design
Physical Design
Implementation
Maintenance
Logical Design
Purpose –monitor, repair, enhanceDeliverable – periodic audits
Database Development Process
![Page 27: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/27.jpg)
27
DB Development Schedule
Gantt Chart shows time estimates of tasks
![Page 28: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/28.jpg)
28
PERT Chart shows dependencies between tasks
DB Development Schedule …
![Page 29: Chapter 1: The Database Environment and Development Process Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014](https://reader033.vdocuments.us/reader033/viewer/2022061614/56649d6e5503460f94a5017c/html5/thumbnails/29.jpg)
29
Incremental Commitment in DB Development
Project is reviewed at the end of each development phase Re-justify the process under the light of new requirements
and available resources Renew commitment of stakeholders Continue / Revise Scope / Cancel