INSY3402: Database Management

The University of Texas at Arlington

Professor Kirs

 

ERD to RDBMS: Sample Problems and Exercises

 

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

 

         SEE ANSWER

 

2.      We listed six (6) basic steps in mapping ERDs to RDBMS tables. List them and explain how each one works.

 

         SEE ANSWER

 

3.      Explain why a binary (or n-ary) 1:1 relationship might be used instead of collapsing the relationship into one table.

 

         SEE ANSWER