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:
 steps to convert er diagram into tables
 convert er diagram to table
 conversion examples of er diagram to relational database
 relational schema example questions
 question to create relational schema from er diagram
 er to schema with solutions
 ER model and relational model questions gate
 er diagram to table shortcuts
 discuss how er model can be convert to relational model
 convert erd into relation
Related