Standard Deliverables
How do you know if an application is ready to be migrated to a production environment? The
application development methodology must clearly define, both in format and in level of detail,
the required deliverables for each stage of the life cycle. These should include specifications for
each of the following items:
Entity relationship diagram
Physical database diagram
Space requirements
Tuning goals for queries and transaction processing
Security requirements
Data requirements
Query execution plans
Acceptance test procedures
In the following sections, you will see descriptions of each of these items.
?–
?–
?–
?–
?–
?–
?–
?–
134 Oracle Database 11g DBA Handbook
Entity Relationship Diagram
The entity relationship (E-R) diagram illustrates the relationships that have been identified among
the entities that make up the application. E-R diagrams are critical for providing an understanding
of the goals of the system. They also help to identify interface points with other applications and
to ensure consistency in definitions across the enterprise.
Physical Database Diagram
A physical database diagram shows the physical tables generated from the entities and the columns
generated from the defined attributes in the logical model; most, if not all, data modeling tools
support the automatic translation of a logical database diagram to the physical database design. A
physical database diagramming tool is usually capable of generating the DDL necessary to create
the application??™s objects.
Pages:
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247