A relational database contains the following tables:
Employee (EmployeeNo, EmployeeName, DateOfBirth, JobDescription,DeptNo)
Project (ProjectNo, ProjectName, Location)Assignment (EmployeeNo, ProjectNo, Role-in-Project)Formulate the following using SQL:i. Find the names of all employees assigned to a project. List the employee
names in an alphabetical order.
March 14, 2009 10:08 PM
March 17, 2009 2:25 PM