A method and device for database design and creation is disclosed. The method includes determining ranks for each of a plurality of variables in each of a plurality of databases based on at least one attribute associated with each of the plurality of variables. The method further includes arranging each of the plurality of variables in a sequence with respect to an associated database from the plurality of databases. The method includes computing a correlation coefficient between the plurality of variables across the plurality of databases based on the sequence of arrangement. The method further includes determining based on the correlation coefficient, whether a relationship exists between one or more of the plurality of variables across the plurality of databases. The method includes creating a database using the plurality of databases based on the relationship, when the relationship exists between the one or more of the plurality of variables.