a schema modeler for generating an efficient database schema . provides intelligent choices for schema structure , generates efficient schemas while minimizing the amount of experience required by a database designer . architectural elements of a schema design are proposed based on field inputs such as field type or relationship . schema information is manually entered or imported . configured for structural compatibility and semantic compatibility checking on fields and relationships for data integrity due to nested structure denormalization , inspection of lookup tables that can hold an unlimited number of records , inspection of taxonomy defined on a non - main table , and inspection of the schema for the existence of a main table . provide suggested field types or schema structures that allow for a more efficient schema to be generated . field types may include qualifier , multi - lingual , calculation and may include family or attribute table suggestions as well . generation of validations and data profiling ensure efficient results .