TABLE: Employees Last^Name First^Name Dept^Code Phone ----------------------------------------------- Davis Fred 1 227-3484 Harris Martha 3 227-3487 Smith John 2 227-4698 TABLE: Departments Dept^Code Dept^Name Floor --------------------------------- 1 Sales 5 2 Engineering 8