The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 votes

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

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

asked in Databases by Loyal (6.4k points) | 98 views

3 Answers

0 votes
according to me it should be 5
answered by Active (1.9k points)
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
answered by Veteran (57.6k points)
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

answered by Active (1.9k points)

Related questions

0 votes
0 answers
asked Aug 30, 2018 in Databases by bts1jimin (245 points) | 111 views
0 votes
0 answers
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
48,564 questions
52,765 answers
68,245 users