Dark Mode

Recent questions tagged er-diagram

1 vote

0 answers

91

MadeEasy Test Series: Databases - Er Diagram
Consider the following ER diagram The minimum no of foreign key required for RDBMS design of given ER model _______________

Gurdeep Saini asked in Databases Jan 3, 2019

by Gurdeep Saini

694 views

0 votes

1 answer

92

Zeal Test Series 2019: Databases - Er Diagram
Match the following: (a) Create (i) The E-R Model (b) Select (ii) Relationship Model (c) Rectangle (iii) DDL (d) Record (iv) DML in answer a is matched with dml but what i know ---select is for data retrival and insert update delete are for DML

Prince Sindhiya asked in Databases Jan 2, 2019

by Prince Sindhiya

583 views

1 vote

1 answer

93

MadeEasy Test Series 2019: Databases - Er Diagram
Consider the ER model minimum no of RDBMS table _____________ ?

Gurdeep Saini asked in Databases Jan 1, 2019

by Gurdeep Saini

607 views

0 votes

1 answer

94

Number of tables required
E and F are multivalued attributes. How many minimum tables which satisfy 1NF ? How many minimum tables which satisfy 2NF ? How many minimum tables which satisfy 3NF ? How many minimum tables which satisfy BCNF ?

Rishav Kumar Singh asked in Databases Jan 1, 2019

by Rishav Kumar Singh

1.4k views

1 vote

0 answers

95

No. Of tables
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at both sides, Total Participation at both sides and partial participation at one side).

Rishav Kumar Singh asked in Databases Jan 1, 2019

by Rishav Kumar Singh

424 views

0 votes

0 answers

96

GATE Overflow | Mock GATE | Test 1 | Question: 55
Which of the following is/are true regarding Weak Entity Sets? (P) An entity set that does not have a primary key is referred to as a weak entity set. (Q) The existence of a weak entity set depends on the existence of a identifying entity set. (R) ... . Only R, S and T are true All are true Only Q, R and S are true Only P, R and S are true

Ruturaj Mohanty asked in Databases Dec 27, 2018

by Ruturaj Mohanty

825 views

0 votes

0 answers

97

Raj Kumar 7 asked in Databases Dec 25, 2018

411 views

0 votes

0 answers

98

ER Diagram
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ? 1:1 with partial participation of both entities needs min no of tables = 2?

Shamim Ahmed asked in Databases Dec 18, 2018

by Shamim Ahmed

308 views

1 vote

0 answers

99

ME[Minimum number of Tables needed]

jatin khachane 1 asked in Databases Dec 18, 2018

by jatin khachane 1

757 views

0 votes

0 answers

100

Zeal Test Series 2019: Databases - 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 partial key and depending on first tables primary key so both are equivalent please tell me that i am right or not answer is C)

Prince Sindhiya asked in Databases Dec 16, 2018

by Prince Sindhiya

392 views

1 vote

2 answers

101

MadeEasy Workbook: Databases - Er Diagram
The minimum number of tables needed to represent M,N,P,R1,R2 is … The given ans is 2. I think the ans should be 3.

Harsh Kumar asked in Databases Dec 11, 2018

1.1k views

0 votes

0 answers

102

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

Satbir asked in Databases Dec 10, 2018

by Satbir

534 views

1 vote

0 answers

103

Self Doubt on ER diagram
How to solve these type of questions https://gateoverflow.in/201404/er-diagram Copying the image for quick reference: Minimum no of tables. My approach was: First allocate all the relationships to entities (i.e decide on relationships) So here R5 goes with E4 , R4 ... tables will be E1R1E2R2, E4R5, E3R4, R3. Correct me if I'm wrong. Let me know if there is a better process.

Hemanth_13 asked in Databases Dec 4, 2018

429 views

1 vote

0 answers

104

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

Ashwani Yadav asked in Databases Dec 3, 2018

by Ashwani Yadav

603 views

1 vote

2 answers

105

Testbook Test Series: Databases - Er Diagram

monty asked in Databases Nov 19, 2018

by monty

632 views

1 vote

0 answers

106

made easy test series
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 ________.

Ashwani Yadav asked in Databases Nov 18, 2018

by Ashwani Yadav

3.3k views

0 votes

0 answers

107

rajputved asked in Databases Nov 14, 2018

531 views

1 vote

0 answers

108

Na462 asked in Databases Nov 14, 2018

by Na462

700 views

0 votes

0 answers

109

er diagram to relational model conversion
In case of 1:1 relationships, when can we have a minimum of 1 table? when both the entities have total participation when atleast one entity have total participation

Syeda97 asked in Databases Nov 11, 2018

494 views

1 vote

1 answer

110

Ace Academy DBMS Volume 1 page numbber 20 question number 16
How are the minimum number of tables required two? Can anyone please explain me?

Syed Sauban asked in Databases Nov 4, 2018

573 views

0 votes

2 answers

111

ER Diagrams - Minimum Number of Tables required
How many minimum number of tables needed for this Quaternary Relationship?

Balaji Jegan asked in Databases Nov 4, 2018

by Balaji Jegan

2.3k views

0 votes

1 answer

112

MadeEasy Test Series: Databases - Er Diagram

dekabh asked in Databases Oct 28, 2018

by dekabh

675 views

0 votes

0 answers

113

Self doubt
Notice that we can always map 1:1 or l:N relationships in a manner similar M:N to relationships by using the cross-reference (relationship relation) approach, as we discussed earlier. This alternative is particularly useful when few relationship instances exist, in ... the entities or only those who are participating in relationship TO AVOID NULLS ex: Table 1 or table how will it be ?

jatin khachane 1 asked in Databases Oct 24, 2018

by jatin khachane 1

568 views

0 votes

2 answers

114

Shivangi Parashar 2 asked in Databases Oct 22, 2018

by Shivangi Parashar 2

1.4k views

0 votes

0 answers

115

ER Diagram to Relation
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ? A. 1 B. 2 C. 3 D. 4

Na462 asked in Databases Oct 12, 2018

by Na462

1.2k views

3 votes

1 answer

116

ER diagram
Is multivalued attribute always create extra table in ER diagram?

srestha asked in Databases Oct 7, 2018

978 views

1 vote

1 answer

117

Korth
In a self referential relationship many to many relationship set, how minimum many tables are required to store in case of partial participation. Example: If an employee can report to several managers and manager can supervise any number of employees- Shouldn't it be 1 table with compose candidate key as Eid,Supid

skywalker_19 asked in Databases Oct 3, 2018

by skywalker_19

986 views

0 votes

1 answer

118

Self-doubt
According to me two tables are enough to represent this ER diagram [Loan,Loans] [Bank,Branches,BankBranch].let me know if I am wrong.

Prateek Raghuvanshi asked in Databases Sep 25, 2018

by Prateek Raghuvanshi

1.2k views

1 vote

0 answers

119

ER diagram to Tables
Tables needed for ER diagram

Mk Utkarsh asked in Databases Sep 23, 2018

681 views

0 votes

0 answers

120

ER Diagram Minimum Tables Needed

smsubham asked in Databases Sep 19, 2018

564 views

Page:

« prev
1
2
3
4
5
6
7
8
9
10
next »

Recent questions tagged er-diagram