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:

  • convert er model in relational data base
  • er diagram to eer diagram Solved prob
  • relational model questions
  • convert entity set into relation algebra
  • convert er diagram to relational model examples commands
  • question on convert in erd and tables in dbms
  • questions with answers for map er to relational schema
  • solved problems that converts entity relational model to relational model in database

Leave a Reply