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.