490 views

3 Answers

0 votes
0 votes
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
0 votes
0 votes

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 votes
1 votes
2 answers
1
ajaysoni1924 asked May 22, 2018
710 views
What should be correct option for 1. and why...?
1 votes
1 votes
0 answers
2
bts1jimin asked Aug 30, 2018
1,275 views
0 votes
0 votes
2 answers
4
priyanshu710 asked Sep 15, 2021
749 views
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side?Can i have just a single table with a...