Register

Recent questions tagged er-to-relational

0 votes
3 answers
32
relational model
minimum no. of tables required....!!! How to do such question where aggregation generalization or specialization is involved
minimum no. of tables required....!!!How to do such question where aggregation generalization or specialization is involved
User Avatar
1 votes
1 answer
35
Er Diagram to Table 1
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design). Please explain every point in detail i am weak in ER Diagram to table conversion Please
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).Please explain every point in detail...
User Avatar
3 votes
1 answer
39
Ace Test Series: DBMS - ER Diagram To Relational Table
Answer given is 3 But my answer is 2 . I have combined the Department and Project relation since the participation of Project was total. please someone explain why can't we combine Department and Project.
Answer given is 3But my answer is 2 . I have combined the Department and Project relation since the participation of Project was total.please someone explain why can't we...
User Avatar
2 votes
2 answers
40
No. of Tables
Plz check this Ans given 5 and I was getting 3 Which one correct??
Plz check this Ans given 5 and I was getting 3Which one correct??
User Avatar
1 votes
0 answers
43
Doubt Reg ER Model Cardinality
Each Department is required to have atmost one employee as manager My interpretation is for Department : Cardinality=1 Particiaption=0 for Employee Cardinality=1 and Participation is what? (1 or 0) Are they correct ?
Each Department is required to have atmost one employee as managerMy interpretation is for Department : Cardinality=1 Particiaption=0 for Employee Cardinality=1 and Parti...
User Avatar
0 votes
1 answer
44
ER Diagram
User Avatar
0 votes
1 answer
45
No. of tables for ER diagram
How many minimum tables are required for this er diagram consisting of a many - many relation and total participation of one of the entities.? Can't i merge relation R and entity B? why?
How many minimum tables are required for this er diagram consisting of a many - many relation and total participation of one of the entities.? Can't i merge relation R an...
User Avatar
1 votes
0 answers
48
ER model
If two tables A and B given with relationship table R. Min number of tables possible if below conditions given 1) R is 1:1 2) R is m:n 3)R is 1:m 4)R is m:1 5)total participation of A in R 6)total participation of A and B both in R
If two tables A and B given with relationship table R.Min number of tables possible if below conditions given1) R is 1:1 2) R is m:n3)R is 1:m4)R is m:1 5)total participa...
User Avatar
0 votes
0 answers
49
Self doubt
Suppose their is a many to one relation from A to B. And, the relationship set AB has descriptive attributes. 1. Can we merge AB relationship set with A entity set even when AB has descriptive attributes? 2. What if participation of A in AB is partial?
Suppose their is a many to one relation from A to B. And, the relationship set AB has descriptive attributes.1. Can we merge AB relationship set with A entity set even wh...
User Avatar
5 votes
1 answer
50
Minimum relations required for ER diagram
How many minimum relations required for the above ER diagram? According to me it should be 7. Please let me know the answer according to you.
How many minimum relations required for the above ER diagram?According to me it should be 7. Please let me know the answer according to you.
User Avatar
2 votes
2 answers
51
ER model doubt
How is it opt D ?
How is it opt D ?
User Avatar
4 votes
1 answer
52
Database: Does each multivalued attribute requires a separate table in 1NF?
Following question and answer from GateForum test series: Now see the following text i coped from Korth, we will create an new for each value of multivalued attribute: Hence answer should be 1 for this question.
Following question and answer from GateForum test series:Now see the following text i coped from Korth, we will create an new for each value of multivalued attribute:Henc...
User Avatar
0 votes
0 answers
53
testseries
User Avatar
3 votes
1 answer
54
ER Diagram: Minimum number of tables needed
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram:
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram:
User Avatar
1 votes
1 answer
55
er diagram
User Avatar
15 votes
13 answers
56
Minimum number of tables to represent ER-Diagram
How many minimum relations required for given ER diagram ?
How many minimum relations required for given ER diagram ?
User Avatar
11 votes
4 answers
57
Minimum number of tables to represent ER-Diagram
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.
User Avatar
0 votes
2 answers
58
ER Diagram to RDMS Model
while converting one to one relationship from ER diagram to RDMS, without total participation on either side, we can represent the relationship using primary- foreign key contraint without making a new table?? Am i right??
while converting one to one relationship from ER diagram to RDMS, without total participation on either side, we can represent the relationship using primary- foreign key...
User Avatar
0 votes
1 answer
60
Er to relational tables gate
Please suggest some pdf or study material to study ER To relational tables type question?
Please suggest some pdf or study material to study ER To relational tables type question?
User Avatar
Page: