The Database Environment and Development Process

1. Basic Concepts and Definitions
2. Traditional File Processing
3. Range of Database Applications
4. The Database Environment

1. IS-DBS 313
Prepared By:
Dr. Rosemarie S. Guirre

2. The Database Environment
and Development Process
IS-DBS 313-1
1. Basic Concepts and Definitions
2. Traditional File Processing
3. Range of Database
Applications
4. The Database Environment
TOPICS
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

3. The Database Environment
and Development Process
IS-DBS 313-1
Meaningful facts, text, graphics,
images, sound, video segments
DATA
A collection of individual
responses from a marketing
research
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

4. The Database Environment
and Development Process
IS-DBS 313-1
Data processed to be useful
in decision making
INFORMATION
Pattern of geographical
buying habit based on
analysis of a marketing
research
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

5. Data vs. Information
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

6. DB and DBMS
Collection of data that exist
over a long period of time
DATABASE
Software system that
manages databases
DBMS (Database Management System)
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

7. UNIVERSAL
DATABASE
SYSTEMS
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

8. Database Systems
Collection of electronic data
Central repository of shared
data
Storedinastandardized,
convenientform.
Requires a Database
Management System (DBMS)
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

9. WHY DBMS?
Security
Can handle many users with
good performance
Allows for concurrency while
keeping data consistent
Protects from disaster
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

10. The Database Environment
and Development Process
IS-DBS 313-1
Data that describes data
METADATA
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

11. INFORMATION
Useful for decision making /
interpretation
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

12. METADATA
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

13. DATA
DICTIONARY
Descriptions of the
properties or
characteristics of the data,
including data types, field
sizes, allowable values, and
documentation
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

14. Information and
Data Models
Information and Data Models
Conceptual/
abstract model
For designers and
operators
Concrete/detailed model for implementors
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

15. TYPES OF DB
MODELS
Fileprocessingsystem(traditional)
Hierarchical
Network
Relational
Object-
Relational
Entity-Relationship
ExtendedRelational
Semantic
Semi-structured
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

16. RELATIONAL
MODEL
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). A unique identifier in data model.
Whentheprimarykeyofonetableis
representedinasecondtabletoforma
relationship,itiscalledaforeignkey.
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

17. RELATIONAL DB
SCHEMATIC DIAGRAM
Schematic
Diagram of
RD
Sample part
of RD
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

18. pos_id pos_titleemp_id hrs_per_week
0001 InstructorMA0001 20
0002 InstructorMA0004 40
0003 InstructorMA0001 20
0004 InstructorMA0003 40
0005 InstructorMA0002 40
KEYS
emp_id emp_name emp_access phone_num
MA0001 Rose BSIS 999999
MA0002 Ize ACT 888888
MA0003 Minet BSOM 777777
MA0004 Lynzel BSAIS 555555
(PK)
PRIMARY
KEY(PK) and
FOREIGN KEY
are COMMON
ID
EMPLOYEE TABLE
POSITION TABLE
(FK)
(PK)
PK =1
occurrence
while FK may
have multiple
occurence

19. ENTITY-RELATIONSHIP
DIAGRAM
BUILDING BLOCKS
ATTRIBUTES
Object that has some
properties
Connected with a line
to exactly one entity
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

20. ENTITY-RELATIONSHIP
DIAGRAM
San
Miguel
San
Rafael
Obando Angat
Bocaue
San
Jose
Pandi
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

21. ENTITY-RELATIONSHIP
DIAGRAM
TECHVOC
SHS
DEGREE
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

22. ACTIVITY
You are given 5 minutes.
Open
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

23. DATA APPLICATIONS
Personal DB
standalone desktop
database
Wokgroup DB LAN (<25 users)
Department DB MAN (25-100 users
Enterprise DB WAN (<100 or 1000 users)
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

24. DATA MINING
IS-DBS 313-1
Help to find hidden patterns and
relationships in large databases
to predict future behavior.
sex
# of section
to open
ageClass size
Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1

25. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
COMPONENTS OF DB
ENVIRONMENT
UI App Prog
CASE tool
Repository
Database
DB Admin
System Dev

26. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-
Preliminary
understanding
Deliverable-
request for
project
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance

27. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-business
situation and
possible solution
Deliverable-
decomposed
requirements
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Feasibility Study
of Project
Maintenance

28. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-
thorough
analysis
Deliverable-
conceptual
data model
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance

29. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-
algorithm
structure
Deliverable-
db
architecture
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance

30. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance
Purpose-
information
requirement
structure
Deliverable-
logical db
design

31. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-testing,
training, debugging,
installation,
documentation
Deliverable-
operational
programs,
documentation,
training materials
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance

32. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
DB Development
Process
Purpose-
monitor, repair,
enhance
Deliverable-
periodic
audits
Feasibility Study
of Project
Requirement
Analysis
Conceptual
Design
Logical Design
Physical Design
Implementation
Maintenance

33. Prepared By: Dr. Rosemarie S. Guirre | IS-DBS 313-1
END OF MODULE 1