Dark Mode

Recent questions tagged er-to-relational

0 votes

0 answers

1

ER Diagram
Can someone please provide me with the correct explanation for this question

practicalmetal asked in Databases Oct 26, 2023

by practicalmetal

363 views

0 votes

1 answer

2

Dbms practice - Self doubt
Consider the below instance of relation : Employee: Emp_rating Emp_name Emp_mail Emp_sal 1. Surabhi sm301@gj 40000 2. Vishu sp11@ap 60000 1. Surabhi Null 50000 3. Yashy ar@dy 60000 The maximum possible number of alternate keys for the above relational instance is/are _____

Rahhul A asked in Databases Aug 3, 2023

418 views

0 votes

0 answers

3

Entity-relationship and Relational Model:el:Convert the following entity-relationship diagram into tables of relational model

Usama2112 asked in Databases Jan 1, 2023

423 views

0 votes

2 answers

4

ER Model to Relational Model Conversion
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side? Can i have just a single table with all attributes and (A1,B1) as a composite primary key?

priyanshu710 asked in Databases Sep 15, 2021

by priyanshu710

761 views

1 vote

1 answer

5

ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram

aditi19 asked in Databases Jun 7, 2019

1.9k views

0 votes

1 answer

6

Virtual Gate Test Series: Databases - ER to Relational Model
how many tables are required?

aditi19 asked in Databases May 28, 2019

1.4k views

0 votes

1 answer

7

RDMS table
How many minimum Relations required from the following ER Diagram which are satisfy 4 NF?

s_dr_13 asked in Databases Mar 6, 2019

459 views

0 votes

1 answer

8

Confused
In ER-DIAGRAM to Relation conversion : I can't understand how to handle the following points How to deal with one-to-one relationship with any of the entity having total participation in relation? How to deal with One-to-many relationship with an entity ... in the relationship? How to deal with many-to-many relationship with total participation of one or both the entities in relation?

Shivam Kasat asked in Databases Jan 17, 2019

by Shivam Kasat

625 views

0 votes

2 answers

9

ER to relation
Answer has R4 and E2 merged, I cant visualize how? what will be primary key? What will be other attributes?

bts1jimin asked in Databases Jan 16, 2019

574 views

0 votes

0 answers

10

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

11

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

12

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

600 views

1 vote

0 answers

13

Na462 asked in Databases Nov 14, 2018

by Na462

686 views

0 votes

0 answers

14

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

490 views

1 vote

1 answer

15

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

16

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

0 answers

17

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

18

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

srestha asked in Databases Oct 7, 2018

976 views

1 vote

0 answers

19

ER diagram to Tables
Tables needed for ER diagram

Mk Utkarsh asked in Databases Sep 23, 2018

675 views

0 votes

0 answers

20

ER Diagram Minimum Tables Needed

smsubham asked in Databases Sep 19, 2018

560 views

0 votes

1 answer

21

Recursive relationship set
How to create relation tables for a Recursive Relationship set ? Is it same way as any other relationship set ?

Harsh Kumar asked in Databases Sep 13, 2018

849 views

0 votes

0 answers

22

How to convert below E-R Model into relational model ?

radha gogia asked in Databases Sep 6, 2018

411 views

1 vote

0 answers

23

DBMS ER to relational model

bts1jimin asked in Databases Aug 30, 2018

1.3k views

0 votes

0 answers

24

Combinational circuits

Kiran 568275148 asked in Digital Logic Aug 25, 2018

by Kiran 568275148

761 views

1 vote

6 answers

25

#DBMS ER Model - Minimum Number of tables
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?

Abbas2131 asked in Databases Jul 30, 2018

2.3k views

1 vote

1 answer

26

# ER diagram
Consider an entity department has attributes dno, dname, phone, office where dno is key and phone and office both are multivalued attributes then minimum no of tables required??

G Shaheena asked in Databases Jul 14, 2018

384 views

3 votes

2 answers

27

Number of tables
What is minimum number of tables requires, to represent above ER diagram? (Does total participation and partial participation will take a role in this question)?

srestha asked in Databases Jun 5, 2018

2.6k views

Page:

Recent questions tagged er-to-relational