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

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

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

asked in Databases by (155 points) | 93 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 (50.7k 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.7k points)

Related questions

0 votes
0 answers
2
asked Aug 30, 2018 in Databases by bts1jimin (199 points) | 100 views


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

47,080 questions
51,333 answers
177,706 comments
66,675 users