Database Design and Views

Please respond to BOTH of the following questions:

Question A

The author’s approach to database design is to develop an ER model and then convert those models to relational tables.

  • Why do you suppose this approach is used?
  • What aspect of database design is generally missed in the ER Model that the conversion to relational tables addresses?

Question B

Research the concept of a “view” and share the pros and cons.