مطلوب مساعدة فى حل الأسئلة

السلام عليكم للجميع

ما عرفت ماذا اعمل بس الموضوع جدا ضروري وارجو المساعده من كل شخص يعرف في الاركل

السؤال الاول:-

take adate parameter

return age must be in years and months

retun the age in day when the age is less than a month

return 0 when the passed date equals todays date

return null when the passed is after todays date.

السؤال الثاني-الفرق بين الوقت الحالي وتاريخ التوظيف للعاملين والمطلوب في النقاط التاليه

0-10 if the number of working years is in the range0-10

11-20 if the number of working years is in the range 11-20

21-30 if the number of working years is in the range21-30

>=31 if the number of working years is in more than 30 years

السؤال الثالث :_

take two parameters; department number and the increment

it increment the employee salary with the passed increment when the differnce

between the average of salaries in the passed department and employee salary is more than 100.

it must handle the exceptions when the passed department does not exist

the procedure can be used to identify the number of updated employees.

السؤال الرابع

ceate afunctin which takes the same paraemters for the above procedure and return the number of update employees based on the above procedure .

ارجو المساعه ويجعله الله في ميزان حسناتكم