Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged er-diagram
2
votes
3
answers
31
ER Diagram: What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
daksirp
1.4k
views
daksirp
asked
Apr 23, 2022
Databases
er-diagram
cardinality
+
–
1
votes
1
answer
32
#selfdoubt
 In the above ER diagram how many relational table and attributes will be in respective table??
In the above ER diagram how many relational table and attributes will be in respective table??
BHOJARAM
668
views
BHOJARAM
asked
Dec 21, 2021
Databases
er-diagram
+
–
1
votes
2
answers
33
Minimum number of tables needed to construct a self referential relation with many to many relationship?
I think it needs three tables but have lil bit confusion
Srken
1.7k
views
Srken
asked
Nov 12, 2021
Databases
rdbms
er-diagram
+
–
0
votes
0
answers
34
#DBMS #E-R diagram
Can anyone verify this? What is the minimum number of tables required in the given situation? Assume there are two entities E1 containing attributes A1 and A2 and E2 containing attributes B1 and B2 attributes respectively, and between E1 and E2 relationship is R, which contains attribute C.
Can anyone verify this?What is the minimum number of tables required in the given situation?Assume there are two entities E1 containing attributes A1 and A2 and E2 contai...
Crackca
418
views
Crackca
asked
Oct 19, 2021
Databases
databases
er-diagram
+
–
0
votes
2
answers
35
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?
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 a...
priyanshu710
793
views
priyanshu710
asked
Sep 15, 2021
Databases
er-to-relational
er-diagram
+
–
1
votes
1
answer
36
What is the degree of a Recursive Relation in Er Modelling?
What is the degree of a Recursive Relation in Er Modelling? I think its 1 since only one entity set is participating but can it be 2 since role is different for entity set?
What is the degree of a Recursive Relation in Er Modelling?I think its 1 since only one entity set is participating but can it be 2 since role is different for entity set...
Yashvir
493
views
Yashvir
asked
Sep 10, 2021
Databases
databases
er-diagram
+
–
2
votes
3
answers
37
UGC NET CSE | December 2019 | Part 2 | Question: 23
Find minimum number of tables required for converting the following entity relationship diagram into relational database? $2$ $4$ $3$ $5$
Find minimum number of tables required for converting the following entity relationship diagram into relational database?$2$$4$$3$$5$
soujanyareddy13
2.3k
views
soujanyareddy13
asked
May 12, 2021
Databases
ugcnetcse-dec2019-paper2
er-diagram
+
–
6
votes
5
answers
38
UGC NET CSE | January 2017 | Part 2 | Question: 18
Let $M$ and $N$ be two entities in an $E-R$ diagram with simple single value attributes. $R_{1}$ and $R_{2}$ are two relationship between $M$ and $N$, where as $R_{1}$, is one-to-many and $R_{2}$, is many-to-many. The minimum number of tables required to represent $M, N, R_{1}$, and $R_{2}$, in the relational model are ___________. $4$ $6$ $7$ $3$
Let $M$ and $N$ be two entities in an $E-R$ diagram with simple single value attributes. $R_{1}$ and $R_{2}$ are two relationship between $M$ and $N$, where as $R_{1}$, i...
go_editor
3.4k
views
go_editor
asked
Mar 24, 2020
Databases
ugcnetjan2017ii
databases
er-diagram
+
–
18
votes
3
answers
39
GATE CSE 2020 | Question: 14
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram? Diamonds with double/bold border Rectangles with double/bold border Ovals with double/bold border Ovals that contain underlined identifiers
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?Diamonds with double/bold bor...
Arjun
13.2k
views
Arjun
asked
Feb 12, 2020
Databases
gatecse-2020
databases
er-diagram
1-mark
+
–
1
votes
1
answer
40
ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram
How to represent referential integrity constraint in ER model?pls explain with diagram
aditi19
1.9k
views
aditi19
asked
Jun 7, 2019
Databases
er-diagram
databases
er-to-relational
referential-integrity
+
–
0
votes
0
answers
41
#DBMS_ER Model
A university database contains information about professors (identified by SSN) and courses (identified by courseid). Professors teach courses; each of the following situations concerns the Teaches relationship set. For below situation, draw the ER diagram: ... in a team can teach the course. Model this situation introducing additional entity sets and relationship sets if necessary.
A university database contains information about professors (identified by SSN) and courses (identified by courseid). Professors teach courses; each of the following situ...
Sumiran Agrawal
902
views
Sumiran Agrawal
asked
May 24, 2019
Databases
er-diagram
databases
+
–
0
votes
2
answers
42
Self Doubt: Databases ER diagram
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong entity set) or check side (weak entity set)? and why?
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong enti...
kd.....
827
views
kd.....
asked
Apr 26, 2019
Databases
databases
er-diagram
+
–
1
votes
0
answers
43
#self doubt
my doubt is- when question is said find minimum no.of table to given E-R diagram,and additional condition table are satisfying 1NF/2NF/3NF. how we conclude table is 1NF/2NF/3NF.
my doubt is- when question is said find minimum no.of table to given E-R diagram,and additional condition table are satisfying 1NF/2NF/3NF. how we conclude table is 1NF/2...
sandeep singh gaur
292
views
sandeep singh gaur
asked
Apr 4, 2019
Databases
er-diagram
+
–
0
votes
0
answers
44
self doubt
What is the correct answer of this Question and what are the Minimized tables ???
What is the correct answer of this Question and what are the Minimized tables ???
_Bash_
451
views
_Bash_
asked
Apr 4, 2019
Databases
self-doubt
er-diagram
+
–
0
votes
0
answers
45
DBMS Korth Edition 6 Exercise 7 Question 25 (Page No. 321)
Consider the relation schemas are shown below, which were generated from the E-R diagram in Figure given below. For each schema, specify what foreign key constraints, if any, should be created. teaches (ID, course id, sec id, semester, ... room number) inst dept (ID, dept name) stud dept (ID, dept name) course dept (course id, dept name)
Consider the relation schemas are shown below, which were generatedfrom the E-R diagram in Figure given below. For each schema, specify what foreign keyconstraints, if an...
ajaysoni1924
1.2k
views
ajaysoni1924
asked
Mar 30, 2019
Databases
databases
korth-edition6
relational-model
er-diagram
descriptive
+
–
0
votes
1
answer
46
DBMS Korth Edition 6 Exercise 7 Question 29 (Page No. 321)
Explain the distinction between total and partial constraints.
Explain the distinction between total and partial constraints.
ajaysoni1924
831
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
1
answer
47
DBMS Korth Edition 6 Exercise 7 Question 28 (Page No. 321)
Explain the distinction between disjoint and overlapping constraints.
Explain the distinction between disjoint and overlapping constraints.
ajaysoni1924
854
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
0
answers
48
DBMS Korth Edition 6 Exercise 7 Question 27 (Page No. 321)
Explain the distinction between condition-defined and user-defined constraints. Which of these constraints can the system check automatically? Explain your answer.
Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically?Explain your answer.
ajaysoni1924
556
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
5
votes
0
answers
49
DBMS Korth Edition 6 Exercise 7 Question 26 (Page No. 321)
Design a generalization-specialization hierarchy for a motor vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level.
Design a generalization-specialization hierarchy for a motor vehicle salescompany. The company sells motorcycles, passenger cars, vans, and buses.Justify your placement o...
ajaysoni1924
2.0k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
0
answers
50
DBMS Korth Edition 6 Exercise 7 Question 23 (Page No. 320)
Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design ... , a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
Design a database for an airline. The database must keep track of customersand their reservations, flights and their status, seat assignments onindividual flights, and th...
ajaysoni1924
844
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
0
votes
0
answers
51
DBMS Korth Edition 6 Exercise 7 Question 22 (Page No. 319-320)
Design a database for a worldwide package delivery company (e.g., DHL or FedEx). The database must be able to keep track of customers (who ship items) and customers (who receive items); some customers may do both. ... E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
Design a database for a worldwide package delivery company (e.g., DHLor FedEx). The database must be able to keep track of customers (who shipitems) and customers (who re...
ajaysoni1924
1.6k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
er-diagram
database-design
+
–
4
votes
0
answers
52
DBMS Korth Edition 6 Exercise 7 Question 21 (Page No. 319)
Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle ... , a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
Design a database for an automobile company to provide to its dealers toassist them in maintaining customer records and dealer inventory and toassist sales staff in order...
ajaysoni1924
1.6k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
4
votes
0
answers
53
DBMS Korth Edition 6 Exercise 7 Question 20 (Page No. 319-320)
Consider the E-R diagram in Figure given below, which models an online bookstore. a. List the entity sets and their primary keys. b. Suppose the bookstore adds Blu-ray discs and downloadable videos to its collection. ... model the case where a shopping basket may contain any combination of books, Blu-ray discs, or downloadable video.
Consider the E-R diagram in Figure given below, which models an online bookstore.a. List the entity sets and their primary keys. b. Suppose the bookstore adds Blu-ray dis...
ajaysoni1924
3.1k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
Page:
« prev
1
2
3
4
5
6
7
...
10
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register