Design Database Structures

Description
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 activities
  • 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
  • DScripts to generate database elements.
  • Stored procedures and/or functions scripts