Consider the following Schema of Shaheen Airline Pakistan; they want you to generate reports by using the following Retired Employee Information Database. Retired Employee (eid:int, name:varchar(25),age:int, pension:int) Duration_Work(eid:int, did:int, dname:varchar(25), work_to,work_from,percent_time:DATETIME) Department_Worked(did:int, dname:varchar(25), depart_budget:long int, manager:int) Design ERD for the above scenario 1) What are the ages of the retired employees who have pension more than Rs 1 Lac? 2) Find the names of the retired employee who serves the department more than 30% of time of their life and have a budget of over Rs 10 Lac. 3) Find the name of the employee who exactly serves one department only in their whole life? 4) Find the name of the departments who have an/are retired to be employee(s) having age between 50 to 60 only? 5) Find the name of the retired employee who serves only “Cargo Department” or who serves the department more than half of their life time in single department.( Hint : Use UNION (U) Set Operation)
Consider the following Schema of Shaheen Airline Pakistan; they want you to generate reports by using the following Retired Employee Information
Retired Employee (eid:int, name:varchar(25),age:int, pension:int)
Duration_Work(eid:int, did:int, dname:varchar(25), work_to,work_from,percent_time:DATETIME)
Department_Worked(did:int, dname:varchar(25), depart_budget:long int, manager:int)
Design ERD for the above scenario
1) What are the ages of the retired employees who have pension more than Rs 1 Lac?
2) Find the names of the retired employee who serves the department more than 30% of time of their life and have a budget of over Rs 10 Lac.
3) Find the name of the employee who exactly serves one department only in their whole life?
4) Find the name of the departments who have an/are retired to be employee(s) having age between 50 to 60 only?
5) Find the name of the retired employee who serves only “Cargo Department” or who serves the department more than half of their life time in single department.( Hint : Use UNION (U) Set Operation)
Step by step
Solved in 5 steps with 6 images
