Database Reference
In-Depth Information
6. Analyzing the Current Database
To see what is in front of one's nose needs a constant struggle.
—G
EORGE
O
RWELL
I
N
F
RONT OF
Y
OUR
N
OSE
Topics Covered in This Chapter
Getting to Know the Current Database
To determine where you should go, you must first understand
where you are.
This maxim defines the entire philosophy behind this phase of the database design process.
Youmustdevotesometimetogainingaclearunderstandingofyourorganization'sdatabase
so that you can
• Determine whether the database supports the organization's
current
information re-
quirements
• Uncover existing structural deficiencies
• Determine how the database needs to evolve so that it will support the organiza-
tion's
future
information requirements
You can use the existing database as a resource for developing a new database. However,
you must carefully judge which aspects of the current database remain useful and which as-