Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something
which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could
put this as an item of the school as the scope is very huge.
(1)one employee can be in many departments(1 TO MANY) and and each department has one manager.(1 to 1)
--Created a table for EMPLOyee and department---RELATIONSHIP ---> empl_id and dept_id
(2)Also,an employee can work in multiple items/projects(1-MANY) at a time. And a project HAS only one department.(1 to 1)
**Projects table created has codes,the Project name ,Planned budget cost/amount, start_date and end_date AND DEPART_ID
--Also,Created a table for Project and Employee---RELATIONSHIP ---> proj_id and employee_id
This is the full scenario has put above.So,i needed help as I am very confused if i have done the correct relationships.
And,these below items are my plans to allow the schema nd tables support it.
(2)how will a person see all his manager?***A person can have 2,3 managers.(EMP->MANAGER relationship TABLE)
(3)SQL to be able to show a person--->manager-->and their manager's MANAGER
(4)How will managers to view all employees reporting to him.
(5)SQL to support the increase of salaries of employees in a department by percentage or amount wise.
(6)SQL to update or change manager of a department/employee.
(7)If a employee is removed-then all related details should also be removed.
(8)to remove person and department,terminate a person from organisation
SHIFTING a person to different department,assign a person to a department
Projects /Job table EMPLOYEES TABLE-> SALARY info
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!