In Traditional Keyword search system over relational data bases, a keyword query is submitted by the user to the system and the relevant results are retrieved, where the user has restricted knowledge about the data. While issuing queries the user often feels “Left in the dark” and for finding the information the user has to use try-and see approach. Here we guild the information based on the user needs for constructing a keyword query that provides easy access to data from the database. Low ranking quality is often observed even though easy access to data is provided by the keyword queries on databases. For such hard queries, the user may advise to the user alternative queries. We propose a novel framework to predict hard query using algorithms and ranking methods and provide relevant results according to the user needs with high accuracy.