Magento Question:

In EAV database model, data are stored in different smaller tables rather than storing in a single table. Example: Product name is stored in catalog_product_entity_varchar table. Product id is stored in catalog_product_entity_int table. Product price is stored in catalog_product_entity_decimal table. Magento Use EAV database model for easy upgrade and development as this model gives more flexibility to play with data and attributes.