Conversion of ER Model to Relational Model-Questions 

Question 1 :
Consider the following ER Diagram - 

question
a) How many minimum number of tables required ?
Solution :
Step 1 :  Conversion of Strong Entities :
E1
A A1 A2
Primary Key : A
E2
B B1
Primary Key : B
Step 2 : Conversion of Weak Entity :
E3
B C C1 C2
Primary Key : BC
Step 3 : Conversion of Many to One relationship -
E1
A A1 A2 B
Primary Key : A
Foreign Key : B
So, the minimum number of tables required for the ER Diagram will be as follows -

SOLUTION 1

==> 3 tables
b) Which is the common attribute set of each of minimasation table?
Solution :
Attribute B is common in all the tables.
Question 2 :
Movie(id, title, yr) & Actor(id, name, age)
can we join these tables if there is no foreign key given ?
Solution : NO
Question 3 :
E(B,E,F) & R(A,C,D) where,
B: Primary Key of Table E.
A: Primary key for table R and foreign key of table E.
Is it possible to minimize?
Solution :
Yes, ER(B,E,F,C,D) . It is possible to minimize.
Question 4 :
Consider the following ER Diagram and minimize it into relations.

Conversion of ER Model to Relational Model-Questions 4
Solution :
Minimize the ER Diagram into Relations -

Conversion of ER Model to Relational Model-Questions 4Ans

Previous Home Next
Conversion of ERD
to Relational Model
Advantages and Disadvantages
of ER Model

     

Incoming search terms:

  • converting er model to relation question from dbms pdf
  • How to convert a er model to relational model
  • conversion of er diagram to relational database examples with solution
  • questions on how to get relatinal yable from ER diagram
  • How many no of Relation is required to convert the following E-R diagram to Relational model?
  • practical questions on gompertz relational model and there solutions
  • questions and solutions of converting an ER diagram to a relational model
  • Questions to make er model from schema

Leave a Reply