Figuring Out Functional Dependencies in Relations

A succinct definition of a functional dependency, such as X->Y, is that whenever X assumes a certain value (say x), and for that value of X (x), Y assumes a certain value y, then in every subsequent retrievals of X, whenever X assumes the value x, Y should assume the value y. Thats it! Functional dependency is no more than that. It is a very simple mathematical idea. It is the job of the subsequent normal forms to reduce the dependency of non-key attributes on non-key attributes.

Read more

Living in a Timeless Universe

Consider how time may have been invented. I am not referring from any theory of time book or the like. I am just stretching my thought process about must have happened. I am just going to scribble that down. And I am sure that you will begin to agree with me to a large extent, even if you don’t consider my account as an absolutely accurate history of time.

Read more