Question

How many types of relationships can be created in base? Explain each of the them. ​

Answer 1

Answer:

there are three types of relationship in the database you'll likely to encounter in the stage in the design.

1.one-to-one

2.one-to-many

3.many-to-many

...........

Answer 2

There are three types of relationships that can be created in base are as follows:

1) One-to-one: One-to-one is achieved by establishing a relationship between similar types of columns in a table utilizing a single table.

2) One-to-many: Using two tables with main and foreign key associations, one-to-many is implemented.

3) Many-to-many: A junction table is used to implement this method.

• The junction table's composite primary key is made up of the keys from both tables.