Database Design
Database Structure Generation
- CASE tools are frequently capable of generating SQL code for the database directly from a CASE-based database schema.
- This code can be exported to the DBMS for compilation.
- Even a small database model can require 50 pages or more of SQL data definition language code to create the tables, indexes, keys, fields, and triggers.
- Clearly, a CASE tool’s ability to automatically generate syntactically correct code is an enormous productivity advantage.
- Furthermore, it almost always proves easier to modify the database schema and re-generate the code, than to maintain the code directly.