1 votes 1 votes closed as a duplicate of: Ace Test Series: DBMS - Normalization Databases databases + – Shubham Aggarwal asked Sep 8, 2018 • closed Sep 8, 2018 by Shaik Masthan Shubham Aggarwal 256 views comment Share Follow See all 4 Comments See all 4 4 Comments reply Dharmendra Lodhi commented Sep 8, 2018 reply Follow Share empid speciality managerid 1 a m1 1 b m2 1 c m4 2 a m1 3 a m3 above data satisfy all conditions by (ii) Each manager has only one speciality i.e. managerid -> speciality (iv) employee has only manager for each speciality empid,speciality --> managerid So Primary key will be = (empid,speciality) managerid -> speciality // 3NF empid,speciality --> managerid // 3NF so relation schema may be in 3NF please correct me if mistakes. 1 votes 1 votes Shubham Aggarwal commented Sep 8, 2018 reply Follow Share nice effort Dharmendra Lodhi your reply is valuable for me. thanks 0 votes 0 votes Dharmendra Lodhi commented Sep 8, 2018 reply Follow Share what is answer 0 votes 0 votes Shubham Aggarwal commented Sep 8, 2018 reply Follow Share 3 nf 0 votes 0 votes Please log in or register to add a comment.