One of the common requirements when building an application on relational database tables is the ability to incorporate attribute from different sources into a data view which is more representative of the application requirement, rather than the database schema. ADF Business Components provides a powerful feature which can be used, for example, when viewing Emp data, you would want to displayed Department Name from the Dept table rather than just DeptId, which is less intuitive to the end users. This ADF Insider Essentials explains how you can do this.
Reference- ADF insider essential