AnsweredAssumed Answered

Two salary options?

Question asked by redzwanlatif on Jan 20, 2013
Latest reply on Jan 24, 2013 by comment

Hi. I'm building a tuition management software. I need to put 2 salary options (percentage, per hour) in the system. My problem is with the relationship. If I use percentage options, the software should count the salary based on this formula :

 

All the teachers get 10% of the monthly fee as their salary. Let's say a teacher teach a subject that costs $45 per month. There are 10 students studying the subject. 5 students in Class A and 5 students in Class B.

 

Formula :

 

(10% x $45) x 10 students

 

My Relationship :

 

Students ->> Subjects Line <<- Subjects

Students ->> Students Payment

Teachers ->> Teachers Payment

 

Do you have any idea on how to calculate the salary automatically?

Which table should I put the 'fee per month, percentage, student payment' field?

I really need some idea for this. Thanks for your help . Really appreciate it.

Outcomes