Computer scienceFundamentalsSQL and DatabasesDB TheoryRelational DB theory

Normalization

2NF

Report a typo

The relation in 1NF is given: tasks(id_emp, age_emp, id_task). id_emp – employee id, id_task – task id, age_emp – employee age.

id_emp , id_task – composite primary key

What this relationship will look like in 2NF?

Select one option from the list

the relation in 2NF already

tasks(id_task, age) and employee(id_emp, age)

tasks(id_emp, id_task) and employee(id_emp, age)

tasks(id_task) and employee(id_emp, age)

___

Create a free account to access the full topic