0 Replies - 4701 Views - Last Post: 26 January 2012 - 03:21 PM

#1 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Relational Algebra Expression

Posted 26 January 2012 - 03:21 PM

I need some help putting this together. I have a database that looks like the following:

Employee (empNo, fName, lName, address, DOB, sex, position, deptNo)
Department (deptNo, deptName, mgrEmpNo)

I need to figure out how to display the total amount of employees that are managed by James Adams.

This is what I have but I think it's only going to produce '1' because I think it is saying "Count total employees who have the position manager, first names James and last name Adams.

ℑCOUNT empNoposition = 'manager' ∧ fName = "James" ∧ lName="Adams"(Employee))

Any Help is appreciated.

Is This A Good Question/Topic? 0
  • +

Page 1 of 1