External elements of the TASKS, PROJECTS, and EMPLOYEES tables TASKS ------------ TASK_NO PROJ_NO PROJECT EMPLOYEES TASK BUDGET ------------------- STATUS LEADER EMP_SSN PROJECT_LINK LEADER_LINK NAME SALARY PROJECTS MANAGER ------------------ MANAGER_LINK PROJ_NO Select Link Element In order to define an external element, a special type of element (a link element) must be present in the query table. A is link element essentially a foreign key to another table. By selecting a link element, you will be able to reference data from the linked table.
External elements of the TASKS, PROJECTS, and EMPLOYEES tables TASKS ------------ TASK_NO PROJ_NO TASK STATUS PROJECT_LINK PROJECTS ------------------ PROJ_NO PROJECT BUDGET LEADER LEADER_LINK EMPLOYEES ------------------- EMP_SSN NAME SALARY MANAGER MANAGER_LINK Select Link Element In order to define an external element, a special type of element (a link element) must be present in the query table. A link element is essentially a foreign key to another table. By selecting a link element, you will be able to reference data from the linked table.
_new_ezq_reference.docx