Wednesday, April 25, 2012

It is all in the family !!

In a family a parent makes changes. Those changes impact children. For e.g. A father earns. The money gives a good life to many of his children.
In the field of IT it is called as one to many relationship. One change is made. Many impact is achieved. Someone may say why father. Why not mother? Not so fast. Give me time to type.
What I am saying here is only one to many relationship. I have not taken up the topic of entities. And their relationship.
Yes, both are important. One to many is important. So is entity relationship. Only when you know both these can you call yourself a professional IT man.
I advise you to spend considerable time and using good imagination design database. Comments are welcome.

5 comments:

Kirtivasan said...

A table has rows. So the height of interpretation is one to many and one to one. The relationship between tables.
So one to one and one to many is a superior method. Superior to (I am taking the risk of saying) even entity relationship.

Kirtivasan said...

The discussion may take one to a still more higher IQ discussion of whether data is important or process is important.
An amicable solution is time is important.

Kirtivasan said...

One may argue that there may be two fathers. One who was responsible for your birth and other for taking care.
Yes, it is one to many for the child then.

Kirtivasan said...

Everyone has ego. They think they are unique. They say my name is such and such, my address is such and such etc.
This factor is used in creating an entity.

Kirtivasan said...

The above is South Indian Society's Tea and Entity Relationship technique. SISTER technique. Ha !! Ha !! Ha !!