Question

When a 1:M relationship exists between two tables, the ‘1’ side of the relationship is the table where the common field is ________

Select one:

a.

the same data type as the ‘M’ side field

b.

the primary key

c.

unique within the table

d.

all of these

e.

none of these

Answer 1

Answer :

d. all of these

The answer follows all three options mentioned above i.e

a. the same data type as the 'M' side field

b. the primary key

c. unique within the table

As we can see that a primiary key is always unique in the table so a primary key with one to many relationship can be unique and can be easily used to map data from other table and in other table it can be used as foreign key and as the key that will refer to another table so that key should also be present in both table so the same data type as the 'M' side field is also required for a key to map data from one table to another table.