Recent questions tagged er-diagram

IN THESE QUESTION WHAT I DID IN 2) there is Multi valued atrribute so we will create one table for it with ab as key NAMED it AS(BETA) table and 3) is same where b1 is pa...

How many number of tables are required to convert the ER diagram into relational model?it is 3 or 4 or 2 or 1?

How to solve these type of questions https://gateoverflow.in/201404/er-diagramCopying the image for quick reference:Minimum no of tables.My approach was:First allocate al...

How to do these type of questions?Given correct answer is 4 . i’m getting answer as 6. Pls explain.

Consider the following ER-diagram for simple database for the National Hockey League given below:The minimum number of table required for database to be in 2NF is _______...

In case of 1:1 relationships, when can we have a minimum of 1 table?when both the entities have total participationwhen atleast one entity have total participation

Notice that we can always map 1:1 or l:N relationships in a manner similarM:N to relationships by using the cross-reference (relationship relation) approach, as wediscuss...

Tables needed for ER diagram

satisfy 4 NF?18 Let $E_{1}$ and $E_{2}$ be two in an $E / R$ diagram with simple single-valued attributes $R_{1}$ and $R_{2}$ are two relationship between $E_{1}$ and $E_...

Consider the following ER diagram,the minimum number of tables needed to represent ER-diagram are-:I think the answer should be $4$.I knw that it is laready posted hereht...