Which of the following is not a type of relationship that can be applied in Access database A. One to One B. One to Many C. Many to Many D. All of above can be applied

One to One
One to Many
Many to Many
All of above can be applied

The correct answer is C. Many to Many.

A one-to-one relationship is a relationship between two tables where each row in the first table can only be related to one row in the second table, and vice versa. A one-to-many relationship is a relationship between two tables where each row in the first table can be related to multiple rows in the second table, but each row in the second table can only be related to one row in the first table. A many-to-many relationship is a relationship between two tables where each row in the first table can be related to multiple rows in the second table, and each row in the second table can be related to multiple rows in the first table.

In Access, a one-to-one relationship can be created by creating a primary key in each table and then creating a foreign key in the second table that references the primary key of the first table. A one-to-many relationship can be created by creating a primary key in the first table and then creating a foreign key in the second table that references the primary key of the first table. A many-to-many relationship can be created by creating a junction table that contains a primary key that is made up of the primary keys of the two tables that are being related.

In the question, option C is the only option that is not a type of relationship that can be applied in Access database. This is because a many-to-many relationship cannot be created directly in Access. Instead, a junction table must be created to represent the relationship between the two tables.