Approaches to Database Design
- Normalization
- Starts with the assumption that all data is initially stored in a large non - normalized table.
- This table is then decomposed using a set of normalization rules to create a set of tables in the Third Normal Form.
- Semantic Data Modeling
- The database designer uses his/her knowledge about the business structure create a set of relational tables.