DATABASE DEVELOPMENT LIFE CYCLE - Database Design and Development: An Essential Guide for IT Professionals - page 131

CONCEPTUAL SCHEMA INTERNAL or PHYSICAL

SCHEMA

PolicyHolderName
Address
Phone

POLICYHOLDER

AgentID
AgentName
AgentAddress
AgentPhone

AGENT

POLICY

PolicyNo
PolicyPeriod
PolicyStatus
DeductibleAmount
PolicyTerms
PremiumAdjustment
ClaimNo
AccidentDate
AccidentDesc
DamageDesc
DamageAmount
SettlementAmount

CLAIM

DATA FILES/
BLOCKS/ RECORDS
INDEX
FILES

STORAGE
ALLOCATIONS

DBMS/OPERATING SYSTEM/
STORAGE MEDIA

Figure 4-15 Auto insurance database: internal schema.

PLANNING

IMPLEMENTATION & DEPLOYMENT

Install DBMS

FEASIBILITY
STUDY

Transform Conceptual to Physical

REQUIREMENTS
DEFINITION

Build DD

Populate Database

DESIGN

Develop Application Programs

Train Users

Figure 4-16 Implementation and deployment phase.

phases, we will just highlight the major activities. This will prepare you to appreci-
ate the flow of the phases from requirements to design and then to implementation
and deployment.

Conceptual to Internal Schema

Implementation of a database takes place at the physical level. When you imple-
ment a database, you are preparing for its usage at the level of physical storage
and hardware. As you know, the internal schema represents the database at this
level. Implementation of a database is, in effect, establishing the physical files in