Question: Make program contain:- 1- Company that has name, Departments, Manager. 2- Department has noOfEmployee, name, Manager. 3- Employee has Name, Age, Id, Phone, Address, Salary.

Make program contain:- 1- Company that has name, Departments, Manager. 2- Department has noOfEmployee, name, Manager. 3- Employee has Name, Age, Id, Phone, Address, Salary. 4- I can add , edit , delete , search for Employee a. Add if noOfEmployee in department didnt Complete and age > 25 the default salary is 4000 b. If I edit his department check For noOfEmployee in another department before Edit c. If he ask to edit his salary check if the last increase for his salary from 6 month increase his salary by 500 pound. d. Delete decrease noOfEmployee in dep. e. Search available by dep name , name , age . 5- The same as no 4 for Company and Dep if I delete company or Dep , You Should delete Employees 6- I can ask for available noOfEmployee in Dep .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!