enable flat database in Magento

Magento uses the EAV database structure for storing the Products and Categories. Magento is extremely flexible because of the EAV database structure. To know more about the EAV database structure