The image admin030.gif illustrates views and location transparency. Two servers are shown, a remote sales database and a local HQ database.The sales database contains the scott.emp table with the following columns: empno, ename, job, mgr, hiredate, sal, comm, deptno.The HQ database contains the jward.dept table with columns deptno and dname. A client is shown accessing a customized view that contains selected columns from each table (empno, ename, and dname).
End of image description.