The idea of a three-tier DBMS architecture may sound familiar to application developers ... The logical view should support the implementation of database designs sketched out in an ERD diagram.

Application sharing between a client, middleware and enterprise server Application sharing between a client, application server and enterprise database server.

These are some of the advantages of a three-tier architecture: It is easier to modify or replace any tier without affecting the other tiers. Separating the application and database functionality ...