MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -A table relationship works by matching data in key fields-often a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table.

Detailed explanation-2: -Database relationships are associations between tables that are created using join statements to retrieve data.

Detailed explanation-3: -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.

Detailed explanation-4: -There are five types of relations in the databases: one-to-one, one-to-many, many-to-one, many-to-many, and self-referencing relationships.