Computer scienceFundamentalsSQL and DatabasesDB TheoryRelational DB theory

Normalization

3NF

Report a typo

The relation in 1NF is given: tasks(id_emp, age_emp, id_task, id_dep, phone_dep). id_emp – employee id, id_task – task id, age_emp – employee age, id_dep – department id, phone_dep – department phone. id_emp , id_task – composite primary key

What this relationship will look like in 3NF?

Select one option from the list

tasks(id_emp, id_task) and employee(id_emp, age, id_dep) and department(id_dep, phone_dep)

tasks(id_emp, id_task) and employee(id_emp, age) and department(id_dep, phone_dep)

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

tasks(id_emp, id_task, age) and employee(id_emp, id_dep) and department(id_dep, phone_dep)

___

Create a free account to access the full topic