Hi, everyone,

Please I have this technical data base question/puzzle that I am yet to answer satisfactorily. "What is/are the essence of having relationship between table s in a database design?" Could someone out there give is contribution. Thanks.

Their is a relationship btw sth and other e.g you and your parents, student and teacher etc. The relationship btw a table and other is to cos of database normalization(To remove repeating keys, they can be many children from a parent., many students in a class as their are different classes in a school)

aminoritse:

Hi, everyone,

Please I have this technical data base question/puzzle that I am yet to answer satisfactorily. "What is/are the essence of having relationship between table s in a database design?" Could someone out there give is contribution. Thanks.

Simple. To maintain Data integrity.

Azum: A beginner doesn't know about data integrity. I know you know cos your are an oracle consultant

paule:

Azum: A beginner doesn't know about data integrity. I know you know cos your are an oracle consultant

@Paule,
Data integrity to a beginner is simple ensuring that data in the tables which ever table they are resident appear the same across board. This is saying that employee name in table 'A' is the same as employee name when referenced in table 'X'. And in ensuring data integrity you eliminate redundant/duplicate data. And one basic way to do this is to introduce relationships between tables.

I truly appreciate @Paule and azum for your response and very helpful answers. Thanks.