0 votes 0 votes Gaurangi Katiyar asked Nov 21, 2018 reshown Nov 29, 2018 by Gaurangi Katiyar Gaurangi Katiyar 344 views answer comment Share Follow See 1 comment See all 1 1 comment reply Rishav Kumar Singh commented Nov 30, 2018 reply Follow Share (1). For Realation to be in 1 NF every attributes must be atomic(no multivalued or composite attributes are allowed ) So, Relations will be Employee(Eid, Ename, Age) , Project(Pid, Pname) , Other_Employee(Eid , Email) , Other_Project(Pid , did). 4 tables required for 1 NF. (2). if a relation has two attributes then it is surely in BCNF. we can see all relations have two attributes except Employee. It may or may not be splitted into one more table.It depends on Functional dependency. 4 NF is Not in GATE Syllabus. 1 votes 1 votes Please log in or register to add a comment.