Question

(a) Identify where the partial dependency exists.
b) Convert the table into 2NF.
Teacher ID Teacher Subject Teacher Age
111 c++ 40
112 OOP 43
111 Database 40
123 java 42
123 computer networks 42

Answer 1

Explanation:

b) Convert the table into 2NF.

Teacher ID Teacher Subject Teacher Age

111 c++ 40

112 OOP 43

111 Database 40

123 java 42

123 computer networks 42

mark as brainlist