First page Back Continue Last page Graphics
Schema Modification
Traditional database design process:
- study the requirements (“description”)
- design an entity-relationship model
- determine the constraints (like 1..n relationships); note that some constraints cannot be expressed in E-R
- translate to a relational schema; normally in BCNF; further decomposition into 4NF may be needed;
Schema modification deals with translating changes to the requirements into changes of the database scheme.
Notes: