بسم الله الرحمن الرحيم
مرحبا شباب
انا طالبه سنه تانيه جامعه ومعي ماده قواعد بيانات 2
ومطلوب مني مشروع بصراحه مش عارفه اعمل فيه حاجه خالص
المشروه لغة PL/sql واوراكل
المشروع راح يتضمن الخطوات التاليه
-Construct your database using 5 tables at least and make the necessary constraints.
Use PL\SQL to do the following:
1. Restrict borrowing of magazine ,it(magazine)has to be for reading only on the library.
2. Monthly your system has to determine the student how must return the Object.
3. Procedure insertBorrow which accept two parameters ( Student _id, Objects _id). (Give the date of barrow initial value sysdate and maxBorrowdate has initial value sysdate + 7 days).
4. Procedure PrintDetails to display all details about the student who has to return the object.
5. Function countBorrowing which return the number of borrowing books in the current month.
6. Function DelRS to delete the records about the student how returned the object . The function should return the number of deleted students .
7. Function maxBorrowing that returns all details abut the student how has the maximum number of borrowing in current month.
8. Organize all of your work in a special Package.
-Use the Oracle Form Builder to create an application form to help the user interacting with your database ,your application has to obtain the following:
9. Check box
10. Radio group
11. List items
12. Buttons(delete,update,save,search)
13. List of values
14. Image item.
Important Notes:
The Last day of submission
Submit two files, one as a hard copy paper file and the other as for Electronic file.
The date of discussion will be announced later.
If a student copies the work of another student, he/she will be assigned a zero grade for the project, any student who supplies their work to be copied will also receive a zero grade. This is not a group project .
بعرف انو الموضوع سهل بالنسبه لبعضكو بس انا بالمره في الماده هادي
بجد بتمنى انو حدا يساعدني فيه
وراح كون كتير شاكره الو
موفقيين
