#self doubt
[closed]

in Databases closed by
119 views
1 vote
1 vote
closed as a duplicate of: Ace Test Series: DBMS - Normalization

in Databases closed by
119 views

4 Comments

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
1
nice effort Dharmendra Lodhi your reply is valuable for me.

thanks
0
0
what is answer
0
0
3 nf
0
0

Related questions