Individual structure members cannot be passed to a function as arguments.

COGNITIVE ASSESSMENT Which of the following best defines what occurs when you partition a hard drive?

A. The hard drive is divided into separate logical storage areas that appear as distinct drives. B. The hard drive resources are shared among multiple users and devices. C. The hard drive operates as both a client and a server. D. The hard drive is removed from the original computer or device and installed into another.

Answer the following queries using relational algebra:

Consider the following relational schema, where the keys are underlined:

Employee ( ssn, name, gender, address, salary, supervisorSSN, dnumber )
Department ( dnumber, dmname, managerSSN)
DeptLocation ( dnumber, dlocation)
Project (pnumber, pname, plocation)
WorksOn (emplSSN, pnumber, hours)

(a) Retrieve the names of all male employees in department number 666, who work more
than 13 hours per week on project "Catch 22".
(b) Find the names of employees who are two managerial levels below the employee "Joe
Public".
(c) Find names of the department that have no employees.
(d) Find those employees in department number 123 who do not work on any project at
location NYC.