Map the following ER schema into a relational schema Specify

Map the following ER schema into a relational schema. Specify: (a) relation schemas, (b) primary keys, (c) foreign keys.

Answer:

(a) Relation Schema:

relation schema for ET1 is ET1 (A, B, C)

relation schema for ET2 is ET2 (D, E, F)

relation schema for ET3 is ET3 (H, K)

relation schema for T is T(G)

(b) Primary keys: A, B, D, K