The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Task 2 – SQL + Tableau

Task 2 – SQL + Tableau

0
Votes
1
Answer

why are displayed so many records for the same employee number? 
the employee number within the t_employees is unique, and in the t_dept_manager the number of records depend on  the number of contracts made, right?
I would appreciate a detailed explanation on this.

1 Answer

365 Team
0
Votes

Hi Marta!
Thanks for reaching out.
The answer will reflect the structure and data we’ve chosen for the data tables from this database. 
Here’s a brief summary that you will hopefully find useful.
t_employees contains data about all employees, where all employee IDs are a primary key. Therefore, in this table, the employee number can be nothing but unique, since we distinguish the records by the employee number.
t_dept_manager contains information about all managers, and this information is only their employee number, the department where they are managers, as well as the start and end dates (if applicable) for their contract(s).
t_dept_emp steps on t_employees in the sense that it still refers to employee numbers, but shows the departments where they are working, as well as the start and end date of the respective contracts.
As you move along and practice the relevant questions, you will further get used to the data stored in these tables and the relation between them.
Hope this helps.
Best,
Martin