Recent questions tagged er-diagram

1 1 vote
1 1 answer
701
701 views
 Can someone help me out in giving example for each, For Example 1:N Both Mandatory : Person->No of Classes Attended, This can be (PersonName,ClassName) but how is the nu...
2 2 votes
3 3 answers
1.1k
1.1k views
6 6 votes
5 5 answers
1.7k
1.7k views
Entity Relationship model shows theStatic viewFunctional viewDynamic viewAll of the above 
1 1 vote
1 1 answer
749
749 views
Every weak entity has to be related to a strong entity through a strong relationship is this statement correct?'
4 4 votes
2 2 answers
1.2k
1.2k views
Considered the following E-R Diagram.Total Numbers of RDBMS Table for above Diagram Possible.A) 4B) 5C) 6D) 7  
0 0 votes
1 1 answer
680
680 views
 In (https://gateoverflow.in/219555/number-of-tables) number of tables to be made was 4, merging E1 and E2 in one table, one for R3, and for E3 and one for E4. Now based ...
34 34 votes
4 4 answers
17.7k
17.7k views
In the context of owner and weak entity sets in the $\text{ER}$ (Entity-Relationship) data model, which one of the following statements is TRUE?The weak entity set MUST h...
22 22 votes
5 answers 5 answers
12.7k
12.7k views
Let $\mathrm{S}$ be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one...
4 4 votes
0 0 answers
890
890 views
Can someone please provide me with the correct explanation for this question
1 1 vote
1 1 answer
1.1k
1.1k views
Find minimum number of tables needed to represent following ER diagram?This question would have been relatively simple as we would implicitly convert the ERD to 3NF (aske...
1 1 vote
2 answers 2 answers
1.1k
1.1k views
Consider the below instance of relation : Employee: Emp_ratingEmp_nameEmp_mailEmp_sal1.Surabhism301@[email protected]@dy60000 The maxi...
1 1 vote
3 3 answers
753
753 views
Given the basic $\text{E R}$ diagram and relational model, which of the the following is incorrect?An attribute of an entity can have more than one valueAn attribute of a...
0 0 votes
1 1 answer
495
495 views
0 0 votes
1 1 answer
893
893 views
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
1 1 vote
3 3 answers
2.6k
2.6k views
An ER diagram is having two strong entities E1 and E2. The relationship between the entities ‘R’ is having partial participation from E1 side and total participation from...
5 5 votes
1 1 answer
1.6k
1.6k views
Consider the following ER diagram :“borrower” mapping cardinality is many-to-many. While converting the ER diagram into a relational DBMS model, the relationship set “bor...