مشروع: design a request courses coordination database system

بتاريخ: 7 ديسمبر 200817 سنة

يا اخوان
الحقوني
انا سويت شويه منه
بس مشكله التعارف كيف تنحل
يا اخوان
الله يسعدكو ويغفر الكو
ما ظل غير كم يوم
تكفون يا اخوان

PL/SQL programming

In the project, we propose to design a request courses coordination database system.
This database system should be able to record all information about courses, sections the schedules and teachers.
For ex: the course table:
Course (course_id, name, duration).
Functional components of the project:
Following is a list of functionalities of the system. More functionality that you find appropriate can be added to this list.
1. The teacher should be able to:
• Login to the system
• Look for the available courses and their schedules
• Add a course. If the course is always chosen the system should display an exception.
• Remove a course

• The system should provide the result time table according to the teacher choices if there is no conflict else the system should display an exception and the conflicting courses.
• The teacher must not choose more than 3 courses.
• If the number of hours in the lecturer schedule exceeds 16 hours or exceeds 14 hours for a professor assistant, the system must store this information in the database.
Steps to start off the project:
1. Design a database for "Courses" "Schedules" and the teachers who log on the system
2. Answer to the above functionalities (you make it as a procedure)
3. Use the “Application Express Developer Guide” to develop a graphical interface to your database system.

اقتباس