A system and method for generating a schema for a database is provided. The schema is based, at least in part, upon three main tables: object types, objects, and, associations. Through these three base tables, the system facilitates rapid prototyping of schema associated with database(s). The schema is extensible since associations between objects, objects and object types are not hard-coded and can be dynamically updated by modifying the appropriate entry(ies) in one or more of these three base tables. Thus, through these three tables, an extensible, flexible framework for generating and/or dynamically modifying the schema is provided.The system includes an input component that receives information associated with a requested database prototype. The system further includes a schema generation component that generates a schema based, at least in part, upon the information received by the input component.