Database Systems: Concepts, Design and Applications

8.4. Automated Design Tools

Whether the target database is RDBMS or object-oriented RDBMS, the overall database design activity has to undergo a systematic process called design methodology predominantly spanning conceptual design, logical design and physical design stages, as discussed above. During the early days of its introduction the database design was carried out manually by the experienced and knowledgeable database designers.

8.4.1. Limitations of Manual Database Design

• Difficulty in dealing with the increased number of alternative design to model the same information for rapidly evolving applications and more complex data in terms of relationship and constraints.

• Making the task of managing manual designs almost impossible for ever ...