مساعدة عاجلة لإخواني مصممي الداتا بيس

متابعين

بتاريخ: 5 يناير 201016 سنة

مرحبا يعطيكم العافية اخواني

أنا مريت بمنتداكم وانا ابحث عن مهتمين بلغة الأوراكل وعترت بمنتداكم الطب

انا عندي مشروع صغير عبارة عن داتا بيس لبنك يضيف أشخاص وبينات لهم

وواجهت مشكلة فيه لغة الإستعلامات على الداتا بيس اتمنى مساعدتي في حل المشروع
وهاي الإستعلامات المطلوبة انا حليت الأول وهي حله
select MIN(salary) as Min_Salary
from Employees
where Bno='&Enter_The_Bno'

بالنسبة لإنشاءالجداول انا كذلك حليتها بس باقي هاي الإستعلامات

Part 2 DML:-
1- Make query to retrieve the minimum salary in each branch of the bank.
2- Make query to retrieve the matched and unmatched clients address with matched branch address.
3- Make query to retrieve all data about the employee who had served the maximum number of clients.
4- Make query to retrieve the number of employees in the Collaboration services part in each branch of the bank.
5- Make query to retrieve the name of the client who has deferent address with his branch.
6- Make query to retrieve all information about the branch with the maximum number of employees.
7- Make query to retrieve the creditors (the client has be creditor when the summation of his withdrawing C_value < his balance).
8- In the end of each month your balance may be changed by deposit or withdraw processes, therefore you must find the final balance after this processes.