EnggRoom

Note:use only html,servlet,jdbc,servlet using mvc architecture
Objectives
On completion of the case study the participant should be ability to:
 Implement J2EE API’s to develop web based application
 Write business components in J2EE
 Handle databases to store and manage data
 Manage messaging in the application
 Implement coding standards as per code review tool
Pre-requisites
 Database Programming- Oracle 10g SQL
 Technology programming – Core Java along with Java EE
 Knowledge of code quality & Testing tool like JUnit
Duration
 5 days.

SCENARIO:
Knowledge provides you with a training program that is focused in its objective, comprehensive in its course material and yet takes the least amount of time possible. It has all the required infrastructure and excellent facilities for participants to pursue their courses. It has a solid growth over a decade and has their branches across all locations in country. They offer the trainings for all Basic technologies (c, c++, Java, J2ee etc.), Domain (Billing, CRM etc.) and database (Oracle, SQL Server etc.) streams. Currently training requests are managed manually on the register which causes lot of human errors. Also solid history in growth and expansion records concern in record maintenance. So the management decides to implement a system that could handle end to end functionality for all training requests. The proposed system is to avoid any kind of manual operations and for ease of operations.
The trainings are categorized as open (where individual can nominate) and corporate (request coming from company for few employees). Every company / individual can use their login details to proceed. If they are using the proposed system for the first time, the new User ID is created for them. They have to provide their details for User IDs. After logging in, individual can see the calendar for planned trainings in month. The proposed system also displays list of various offerings available with them. The corporate user can raise a training request by submitting the necessary details for the training while individual user can see the calendar and nominate for the available trainings. If the training required for the individual is not available in calendar he can raise a request. Such requested trainings can be scheduled only if there are minimum 10 nominations received. The information is sent to the individual user accordingly. The various discount schemes are available for group requests and to those users who have taken the training from this organization earlier. The corporate training rates are different than the individual training rates. There is an SLN (Service Level Norm) attached as 30 days for all in-house trainings( the training is facilitated at same location where the request is raised) If the in-house trainer (at same location mentioned by participant) is not available, other location options can be provided to user.
All the trainers’ details are maintained centrally with their skills. For the corporate training requests, executive checks the trainer’s availability in the month and sends a confirmation to requester. The data for the trainer is then updated in database.
For individual open training, 20% of the nonrefundable course fees need to be paid at the time of registration. Remaining course fees if paid by cheque, needs to be paid 5 days in advance of the training date. If in cash, it has to be paid latest by the 1st day of training. In card payment, 2% of tax is applicable. For all corporate trainings, payment is done at the end of training. All corporate trainings would get 5% discount in total training cost. The training organization will have to pay 25% of the total amount per participant to the trainer for the training conducted. The training executive keeps a track of all conducted trainings and sends the details of all delivered training to HR per month. Only Training manager can cancel the training by specifying the reason. If any training got cancelled, the entire amount has to be returned to the participant.
At the end of the month HR will send a XML file with trainer-wise participant’s payment detail. After every billing process a message is sent to Audit Queue which will maintain audit data in the database. Trainers should be able to see his/her trainings scheduled in a month. Training Manager will be able to generate expected reports.

Business Processes
• Registration Process (required only for users who is using system for first time. others can directly proceed to login process)
o INPUT: Participant information (For corporate user, company information is provided.)
o Validation / Business rules : every User must have unique & auto generated user id
o Output : generate unique training id and store details in the database
• Login Process
o Input: login details which varies based on end user details
o Validation / Business Rules: access control will be different based on the login, with 3 re-login attempts after that account gets locked.
o Output: welcome screen
• Training request process
o Input : training details
o Validation / Business rules:
 trainings will only be possible for future dates
 Already planned trainings for month should be visible
 Once booked request can changed by training executive only
 faculty availability is checked on the training dates specified by requester
 any training cancellations will be done only by training manager
 the appropriate message is sent to the requester
 training schedule date adjustment is possible a week prior to scheduled training.
o Output : training confirmation
• Participant Payment process (this information can be filled by user or executive)
o Input: the mode of payment
o Validation / Business rules :
 the payment amount should be as per the rules and compared with current system date
 if the amount is not paid when expected, 2% charges are applicable
 training can be attended by the participant only if he has no dues
o Output: the confirmation page to be displayed with Balance amount to be paid along with its expected due date
• Corporate user Payment process (this information can be filled by user or executive)
o Input: the mode of payment
o Validation / Business rules :
 the payment amount should be as per the rules
 the total training amount has to be paid within 15 days of completion of training
 Output: it should display thank you page with the message about the total amount they have paid

• Trainer Payment process
o Input: training executive sends the trainer wise details for the courses he delivered in xml format
o Validation / Business rules :
 for absent or transferred participants, the charges will not be paid to the trainer, so process xml file for correct data and not the actual training participant requests
 if any training got canceled / rescheduled in between, the charges will not be paid.
 Billing.xml must be conform to predefined schema
 Output: payment details for trainers has to be kept ready and send message to Audit queue
• Auditing Process
o Input: read message from Audit queue
o Output: Update tables accordingly.
• Reports
o Input: relevant input for specific reports
o Output: Expected output is
 trainer-wise delivered training details
 technology-wise trainings delivered
 company wise trainings attended
 trainers availability in month
 trainer wise planned trainings
 trainer-wise payments
 month-wise payments
 month wise cancelled trainings
 trainer wise cancelled trainings






















[/size][/font]



































Objectives
On completion of the case study the participant should be ability to:
 Implement J2EE API’s to develop web based application
 Write business components in J2EE
 Handle databases to store and manage data
 Manage messaging in the application
 Implement coding standards as per code review tool
Pre-requisites
 Database Programming- Oracle 10g SQL
 Technology programming – Core Java along with Java EE
 Knowledge of code quality & Testing tool like JUnit
Duration
 5 days.

SCENARIO:
Knowledge provides you with a training program that is focused in its objective, comprehensive in its course material and yet takes the least amount of time possible. It has all the required infrastructure and excellent facilities for participants to pursue their courses. It has a solid growth over a decade and has their branches across all locations in country. They offer the trainings for all Basic technologies (c, c++, Java, J2ee etc.), Domain (Billing, CRM etc.) and database (Oracle, SQL Server etc.) streams. Currently training requests are managed manually on the register which causes lot of human errors. Also solid history in growth and expansion records concern in record maintenance. So the management decides to implement a system that could handle end to end functionality for all training requests. The proposed system is to avoid any kind of manual operations and for ease of operations.
The trainings are categorized as open (where individual can nominate) and corporate (request coming from company for few employees). Every company / individual can use their login details to proceed. If they are using the proposed system for the first time, the new User ID is created for them. They have to provide their details for User IDs. After logging in, individual can see the calendar for planned trainings in month. The proposed system also displays list of various offerings available with them. The corporate user can raise a training request by submitting the necessary details for the training while individual user can see the calendar and nominate for the available trainings. If the training required for the individual is not available in calendar he can raise a request. Such requested trainings can be scheduled only if there are minimum 10 nominations received. The information is sent to the individual user accordingly. The various discount schemes are available for group requests and to those users who have taken the training from this organization earlier. The corporate training rates are different than the individual training rates. There is an SLN (Service Level Norm) attached as 30 days for all in-house trainings( the training is facilitated at same location where the request is raised) If the in-house trainer (at same location mentioned by participant) is not available, other location options can be provided to user.
All the trainers’ details are maintained centrally with their skills. For the corporate training requests, executive checks the trainer’s availability in the month and sends a confirmation to requester. The data for the trainer is then updated in database.
For individual open training, 20% of the nonrefundable course fees need to be paid at the time of registration. Remaining course fees if paid by cheque, needs to be paid 5 days in advance of the training date. If in cash, it has to be paid latest by the 1st day of training. In card payment, 2% of tax is applicable. For all corporate trainings, payment is done at the end of training. All corporate trainings would get 5% discount in total training cost. The training organization will have to pay 25% of the total amount per participant to the trainer for the training conducted. The training executive keeps a track of all conducted trainings and sends the details of all delivered training to HR per month. Only Training manager can cancel the training by specifying the reason. If any training got cancelled, the entire amount has to be returned to the participant.
At the end of the month HR will send a XML file with trainer-wise participant’s payment detail. After every billing process a message is sent to Audit Queue which will maintain audit data in the database. Trainers should be able to see his/her trainings scheduled in a month. Training Manager will be able to generate expected reports.

Business Processes
• Registration Process (required only for users who is using system for first time. others can directly proceed to login process)
o INPUT: Participant information (For corporate user, company information is provided.)
o Validation / Business rules : every User must have unique & auto generated user id
o Output : generate unique training id and store details in the database
• Login Process
o Input: login details which varies based on end user details
o Validation / Business Rules: access control will be different based on the login, with 3 re-login attempts after that account gets locked.
o Output: welcome screen
• Training request process
o Input : training details
o Validation / Business rules:
 trainings will only be possible for future dates
 Already planned trainings for month should be visible
 Once booked request can changed by training executive only
 faculty availability is checked on the training dates specified by requester
 any training cancellations will be done only by training manager
 the appropriate message is sent to the requester
 training schedule date adjustment is possible a week prior to scheduled training.
o Output : training confirmation
• Participant Payment process (this information can be filled by user or executive)
o Input: the mode of payment
o Validation / Business rules :
 the payment amount should be as per the rules and compared with current system date
 if the amount is not paid when expected, 2% charges are applicable
 training can be attended by the participant only if he has no dues
o Output: the confirmation page to be displayed with Balance amount to be paid along with its expected due date
• Corporate user Payment process (this information can be filled by user or executive)
o Input: the mode of payment
o Validation / Business rules :
 the payment amount should be as per the rules
 the total training amount has to be paid within 15 days of completion of training
 Output: it should display thank you page with the message about the total amount they have paid

• Trainer Payment process
o Input: training executive sends the trainer wise details for the courses he delivered in xml format
o Validation / Business rules :
 for absent or transferred participants, the charges will not be paid to the trainer, so process xml file for correct data and not the actual training participant requests
 if any training got canceled / rescheduled in between, the charges will not be paid.
 Billing.xml must be conform to predefined schema
 Output: payment details for trainers has to be kept ready and send message to Audit queue
• Auditing Process
o Input: read message from Audit queue
o Output: Update tables accordingly.
• Reports
o Input: relevant input for specific reports
o Output: Expected output is
 trainer-wise delivered training details
 technology-wise trainings delivered
 company wise trainings attended
 trainers availability in month
 trainer wise planned trainings
 trainer-wise payments
 month-wise payments
 month wise cancelled trainings
 trainer wise cancelled trainings