bottom up approach generating schema file