How to normalize into 3rd normal form. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

How to normalize into 3rd normal form.

worker​(id,name,sallary) department (id, name) task(duration,id,name) many to many relation between worker​ and task many to many relation between worker and department

24th Jan 2017, 6:27 AM
Waqar
Waqar - avatar
1 Answer
+ 2
Define two new additional tables: worker_task(id_worker,id_task) worker_department(id_worker,id_department)
27th Jan 2017, 9:06 PM
Marcel Toeltl
Marcel Toeltl - avatar