ANKIT GUPTA a écrit :
Hi,
because of the size limit , i am resending the my previous mail but this time in place of attaching the image i am providing a URL
URL for image: http://dl.dropbox.com/u/1008346/mock_schema.jpg
PFA with this mail as marc Suggested that we should discuss the design with the help of an example, so i have made a mock schema with three tables artist,song and sings.details u can see in the diagram with this mail.
i know The Design which i have developed till now is just the beginning draft , lot of discussion and thought has to be put to finalize the design with functionality.
Hi Ankit,
I had a look at your image. I'm not sure what you mean by "select the relations arrows which we need for the query". I think that in a query builder, the user should be able to specify what he needs just in terms of tables and columns, and the product should build the correct joins.