Conversion of ER Model to Relational ModelQuestions
Question 1 :
Consider the following ER Diagram 
a) How many minimum number of tables required ?
Solution :
Step 1 : Conversion of Strong Entities :
E1 
A 
A1 
A2 
Primary Key : A 


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 
==> 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.
Solution :
Minimize the ER Diagram into Relations 
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
 practical questions on gompertz relational model and there solutions
 How many no of Relation is required to convert the following ER diagram to Relational model?
 erd to relational schema questions and solutions
 er model to table practice question
 er diagram to table conversion example
 step er to relational table
Related