This
task will
deliver all
the database
scripts needed
for creating
the database
structures.
Using these
scripts, tables,
views, indexes,
synonyms and
stored procedures
and functions
are created.
Steps
Design
logical
database
by using
ER model.
Design
physical
database.
Converts
the logical
model
to a detailed
database
design,
within
the overall
architectural
structures
defined
in the
technical
blueprint.
Create
physical
database.
Physically
creates
the database,
and partitions
the tablespaces
and disks
etc. Disk
striping
is performed
within
this activit
Design
and build
scripts
to generate
tables,
views,
indexes,
synonyms
and stored
procedures
and functions.
Estimating
The
effort required for the
database design activity
will vary according to
the number of entities
being included and the
complexity of the procedures
and functions. The following
table provides an estimate
for various activities
in this task.
Step
Complex
Medium
Simple
Design
and create logical
database
30
20
10
Design
and create physical
database
8
5
4
Design
scripts
20
15
5
Risks
Calculating
the size of a database
is involves lot of estimation
and approximation.
Prerequisites
Requirements
Analysis model
Deliverables
Logical database design,
ideally in a CASE
tool.
Physical database
design, ideally in
a CASE tool
A physical database
instance on the database
hardware
