smsmsmsmks
contestada

Which statement describes junction tables?

a. They create a many-to-many relationship, and they link two tables.
b. They create a one-to-one relationship, and they create orphaned data.
c. They link two tables, and they must exclude all nonkey fields.
d. They contain primary key fields of both tables, and they create a one-to-one relationship.

Respuesta :

Martebi

The statement that describes junction tables is options:

c. They link two tables, and they must exclude all non key fields.

d. They contain primary key fields of both tables, and they create a one-to-one relationship.

What does a database junction table do?

The primary key columns of the two tables you want to relate are contained in a junction table. Then you establish a connection between the junction table's matching columns and each of those tables' primary key columns. The title author table in the pubs database is a junction table.

Note that when there is something that could be replicated over numerous entires, such a date or a time, the junction table should be utilized to get your data to the lowest degree of normalization possible.

Learn more about tables from

https://brainly.com/question/12151322
#SPJ1

Otras preguntas