Database Design 2nd Edition pp69

3NF
Student_id	Major	Advisor
111			Physics	Smith
111			Music	Chan
320			Math	Dobbs
671			Physics	White
803			Physics	Smith

BCNF:
St_Adv:
Student_id	Advisor
111 		Smith
111 		Chan
320 		Dobbs
671 		White
803 		Smith

Adv_Maj:
Advisor	Major
Smith 	Physics
Chan 	Music
Dobbs 	Math
White 	Physics