The Gateway to Computer Science Excellence
0 votes
128 views

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

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

in Databases by Boss (10.6k points) | 128 views

3 Answers

0 votes
according to me it should be 5
by Active (1.8k 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
by Veteran (64.8k 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

by Active (1.8k points)
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
50,645 questions
56,562 answers
195,730 comments
101,646 users