I can’t design a database for this scenario

[asgareee]

You have been sub-contracted to design the database system supporting the Academic Human Resources (AHR) department for the “We Are The Best - WATB” college. The initial analysis of the college’s AHR Department has shown the following:

• The AHR department is responsible only for academic posts.
• The AHR department keeps information for every academic who has ever been employed:

�� Personal information: full name, age, address, nationality, qualifications (along with date the qualification was awarded and awarding institution/body);

�� Work related information: current post name and grade, starting date, previous posts, dates of every post held, and current salary. End of Contact date is also included if the person has left.

�� Information regarding the various roles that an academic might hold in the college and information on the additional payment (on top of the salary) that these roles attract.

• The rules of the AHR department state that an academic might hold only one post per time but they might occupy more than one role; For example a Senior Lecturer (post) might be holding the roles of Head of Department (role) and Research Leader (role).

• The posts that can be fulfilled by an academic are: Lecturer, Senior Lecturer, Principal Lecturer, Reader, and Professor.

• The roles that can be fulfilled by an academic are Research Leader, Programme Director, Course Leader, Head of Department, Associate Head of Department, Quality Leader, Learning and Teaching Leader, Recruitment Officer, and Examinations Officer.

• The AHR department holds information on who occupies these roles in each department of the college.

• The college has 5 departments: Computer Science, Arts, Business, Physics and Mathematics.

• Each department has a maximum of one Head of Department and a maximum of two Associate Heads of Department. An academic cannot occupy the roles of Head of Department and Associate Head of Department at the same time.

• Only academics that hold senior posts can occupy the roles of Head of Department and Associate Head of Department. Senior posts are: Principal Lecturer, Reader, and Professor. The rest of the roles can be occupied by any academic irrespective of the post they hold.

• Academics might hold the same role more than one time. For example, the current Head of the Mathematics department, was also Head of the Department from 2001 – 2002.

Please let me know how should I design it's tables and queries.