Answer to Question #159755 in Databases | SQL | Oracle | MS Access for Sandy

Question

An analyst investigating University Student course registration system has found the following rules are applied by registration department:

All applications for course registrations received by the campus are checked by student affairs department. Student affairs first checks the pre requisite of the selected courses for each application and adds that credit to the student's fee balance. If the credit hour exceeds the limit defined for that program, student's application is rejected and is intimated to reselect the courses as per defined limit of credit hours. All such students who have selected the courses according to university policy their fee voucher is generated and that the fee voucher has been passed to the accounts manager who will contact them in the next three days. After the payment of fee, confirmation is to be sent by accounts manager through SMS. In case fee voucher is generated and is not collected by the student reminder message is sent reminding the student of the payment of fees. Construct a Decision Table for the described process.  

Answer 1

The answer to your question is provided in the image: