Who Works Where?

Alex, Betty, Carol, Dan, Earl, Fay, George and Harry are eight employees of an organization
They work in three departments: Personnel, Administration and Marketing with not more than three of them in any department.

Each of them has a different choice of sports from Football, Cricket, Volleyball, Badminton, Lawn Tennis, Basketball, Hockey and Table Tennis not necessarily in the same order.

1.Dan works in Administration and does not like either Football or Cricket.

2.Fay works in Personnel with only Alex who likes Table Tennis.

3.Earl and Harry do not work in the same department as Dan.

4.Carol likes Hockey and does not work in Marketing.

5.George does not work in Administration and does not like either Cricket or Badminton.

6.One of those who work in Administration likes Football.

7.The one who likes Volleyball works in Personnel.

8.None of those who work in Administration likes either Badminton or Lawn Tennis.

9.Harry does not like Cricket.

 
Who are the employees who work in the Administration Department?

In which Department does Earl work?

Who is the fan of each sports?

Click here for the complete picture. 

Source 

Employees of Each Department

What was the data given? 

Let's make a table where columns represent the sport & row represents the employee.There are 3 tables 1 for each department. To make table shorter we will use the initials only of sports' & employees' names as below.

Table

A - Alex, B - Betty, C - Carol, D - Dan, E - Earl, F - Fay, G - George, H - Harry. 

F - Football, C - Cricket, V - Volleyball, Bd - Badminton, LT - Lawn Tennis, Bs - Basketball,
H - Hockey, TT - Table Tennis  

Now taking clues one by one into consideration.

1. Dan works in Administration and does not like either Football or Cricket.

Table 1

-------------------------------------------------------------------------------------------

2. Fay works in Personnel with only Alex who likes Table Tennis.

This indicates that Alex is working in Personnel department & likes Table Tennis. Fay working in same department may like any other sports than Table Tennis. No body other working in this department.

Table 2

--------------------------------------------------------------------------------------------
3. Earl and Harry do not work in the same department as Dan.

Hence they must be working in Marketing department!

Table 3

---------------------------------------------------------------------------------------------
4. Carol likes Hockey and does not work in Marketing.

That's why his department must be Administration.

Table 4

---------------------------------------------------------------------------------------------
5. George does not work in Administration and does not like either Cricket or Badminton.

His department must be Marketing & he might be liking Football or Volleyball or Lawn Tennis or Basketball.

Table 5

----------------------------------------------------------------------------------------------