- Consider The Following Relation A Show If The Given Relation Emp Proj Satisfies 2nf B Decompose It Into Relations In 1 (20.07 KiB) Viewed 31 times
Consider the following relation. a) Show if the given relation EMP_PROJ satisfies 2NF? b) Decompose it into relations in
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Consider the following relation. a) Show if the given relation EMP_PROJ satisfies 2NF? b) Decompose it into relations in
Consider the following relation. a) Show if the given relation EMP_PROJ satisfies 2NF? b) Decompose it into relations in 2NF? c) Identify the primary and the foreign keys in your resulting relations? EMP PROJ Sen. Phumber Hours Ename Pname Plocation FD1 FD2 FD3