Database design involves creating a relational database definition from the Entity Relationship Diagram (ERD). The ERD is the conceptual data model. The database design team usually involves the following members:
The involvement in the database design can vary greatly for each audience. For example, one primary goal of the design team is to create an application with which the team can perform unit testing. The design team, at least initially, needs only a database design that can be generated and installed. The design team is less concerned with fine-tuning the database or with optimizing performance.
After completing unit testing and perhaps other areas of testing, the design team then needs to fine tune the database and optimize its performance. This is often when a database specialist assists the design team. The database specialist looks in detail at the logical and physical definitions for the database.
Since different audiences have different roles concerning database design, the audiences tend to use different tools in the Design Toolset.
|
Copyright © 2013 CA.
All rights reserved.
|
|