what is relationship in computer?what are its advantages
Answers
Answer:
A relationship, in the context of databases, is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationships allow relational databases to split and store data in different tables, while linking disparate data items.
A relationship is an important component of a relational database.
1) It establishes a connection between a pair of tables that are logically related to each other.
2) It helps to further refine table structures and minimize redundant data.
3) It is the mechanism that enables you to draw data from multiple tables simultaneously.
Explanation:
Answer:
A relationship, in the context of databases, is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationships allow relational databases to split and store data in different tables, while linking disparate data items.
Benefits:
It establishes a connection between a pair of tables that are logically related to each other. ...
It helps to further refine table structures and minimize redundant data. ...
It is the mechanism that enables you to draw data from multiple tables simultaneously.