Recent questions tagged er-diagram

E1 and E2 are strong entities with 1:m relationship via R.we take 1 separate table for each strong entity = so 2 tablesBut if there is 1 : n relationship, then we take 1 ...

How to solve this question ?

Kindly Explain.

what will be the key for total participation 1:1 combining tables??? plz give the Candidate keys and foreign keys seperately??Also what if in 1:1 relation total participa...

Please suggest some pdf or study material to study ER To relational tables type question?

Answer given is 4 tables: (Employee), (Monitors), (Project, Sponsors) and (Department). Is this answer right?

What is structural constraint of relationship type and give some examples of it....or any link...???

How can trainer id be p.key of Parts??

Consider the following ER diagram:The minimum number of tables needed to represent ER-diagram are _____ .

Consider the following Entity-Relationship $(E-R)$ diagram and three possible relationship sets I, II and III) for this $E-R$ diagram:$$\text{I}: \quad \begin{array}{|c|c...

Consider the following entity relation diagramIf A has 50 entities,B has 20 entities and C has 200 entities. what is the maximum number of triples of entities that could ...

After mapping an ER diagram relationship to Relational model using the set of rules for 1:n,m:n etc,will the achieved tables will always be in BCNF ?

IF A RELATION HAS ______________ CARDINALITY, THEN NO MINIMIZATION CAN TAKE PLACE.a) 1:nb)m:mc)n:1d) none

An entity instance is a single occurrence of an ______.Entity typeRelationship typeEntity and relationship typeNone of these

In generalisation, the differences between members of an entity isMaximizedMinimizedBoth (A) & (B)None of these