Effective of real estate offices database structure analysis

Kirkuk is considered one the most important cites in Iraq for its many natural resources, multi ethnicities, groups and nationalities. Accommodation and choosing the perfect location for investment is a very important things. The scholar intends to create huge and optimize database by using MySQL language that includes urban planning foundation and geographical distribution regarding patterns of land uses. Currently, Iraq is still using old traditional system in searching the best real estate which requires a lot of effort and time to meet the needs. Kirkuk's applying this system encourages the scholar to build electronic real estate system. In order to facilitate the task in a short time by creating such a mobile application. This system has been created via Php language to design the website. The website admin inputs data regarding the required the real estate and then put them on a map (based on Google map) as well as authorizing the agent ( broker ) to do the same tasks done by the admin. The results will be displayed on (Android Application) which has been created via java Android language. In this way, citizens of Kirkuk will easily find their prospective real estate (Residence, Land, Apartment, Shops, Pharmacy, Firm, Factory, Agricultural land) for either purchasing or rent purpose in any time or place. Least but not last the user can communicate with the broker in case he/she likes the e. advert by calling, sms or sending a message on email address or any social media posts ( Facebook, Twitter ). Finally all these steps will be activated after the user's registration. Keywords: Kirkuk, R.E, Php, MySQL, Java Android, K.E.R.E, Mobile App