# relational model

158 views

minimum no. of tables required....!!!

How to do such question where aggregation generalization or specialization is involved

according to me it should be 5
normally we require 3 tables for IS-A relationship

if covering constraint is there (if both Engineer and Manager  collectively represent whole employees ) then only 2 tables are sufficient. which are one for engineer and another for manager  and same logic apply further

It's M:N relation so that ...we have maintain one separate column for RELATION TABLE and 1 TABLE FOR ENTITY E1 and 1 TABLE FOR E2

## Related questions

1
270 views
What should be correct option for 1. and why...?