## Computer Science: An Overview: Global Edition (12th Edition)

One solution is $$\begin{array}{l}{\text { TEMP } \leftarrow \text { SELECT from JOB }} \\ {\text { where Dept = "PERSONNEL" }} \\ {\text { LIST } \leftarrow \text { PROJECT JobTitle from TEMP }}\end{array}$$ In some systems, this results in a list with a job title repeated, depending on how many times it occurred in the personnel department. That is, our list might contain numerous occurrences of the title secretary. It is more common, however, to design the PROJECT operation so that it removes duplicate tuples from the resulting relation.
One solution is $$\begin{array}{l}{\text { TEMP } \leftarrow \text { SELECT from JOB }} \\ {\text { where Dept = "PERSONNEL" }} \\ {\text { LIST } \leftarrow \text { PROJECT JobTitle from TEMP }}\end{array}$$ In some systems, this results in a list with a job title repeated, depending on how many times it occurred in the personnel department. That is, our list might contain numerous occurrences of the title secretary. It is more common, however, to design the PROJECT operation so that it removes duplicate tuples from the resulting relation.