1.      Explain why CASE tools can not Automatically convert All ERDs to RDBMS tables

 

• Many CASE tools can NOT transform certain complex relationships (e.g, Ternary)

 

 

• There often many valid alternatives, and the designer must choose the best one

 

 

• The designer must be prepared to evaluate the correctness of the CASE generated solution