Talend tjava - tjavarow and tjavaflex differences

What is the difference between tjava, tjavarow and tjava flex. This is a very basic question that every Talend data integration enthusiast should know. And, this is one of the most commonly asked question for Talend data integration interview questions.

 

tjava:

 

·         tjava component is used to execute a block of java code as a separate subjob.

 

·         Usually tjava will not have any input or output links.

 

 

·         The code entered in tjava component will be executed first, but only one in a subjob.

 

·         This component applies exclusively to the start part of the generated code of the subjob.

 

tjavarow: 

 

·         tjavarow component applies exclusively to the main part of the generated code of the subjob.

 

·         This component can access the input flow and transform the data.

 

 

·         tjavarow will be usually used as an intermediate component to read the input flow of data and to transform it.

 

·         The code written in this component will be executed iteratively for each of the incoming data row.

 

tjavaflex:

 

·         This component is similar to the tjavarow component, but the difference is that, it has 3 parts, start, main and end.

 

·         The start and end part will be executed only once in the subjob.

 

 

·         The main part will execute iteratively for each of the incoming data row.

 

·         The start and end part is generally used for initialization and processing operations.

 

 

·         The main part is used to read the input data row and apply transformations.

 


Online examination management system project abstract

1. Introduction


This Software Requirements Specification (SRS) document describes the requirements of Online Answer sheet Evaluation System. The document describes the issues related to the system and what actions are to be performed by the development team in order to come up with a better solution. The Main objective of the project is to enhance transparency, accountability, reliability and efficiency in the whole evaluation process.


1.1 Purpose


The purpose of this document is to provide a detailed description of the‘Online Examination System’. This SRS will allow for a complete understanding of the ‘Online Examination Management System’ to be constructed. The main purpose of ‘Online Examination Management System’ is to reduce the manual operation required to evaluate and maintain answer sheets of students.

This is a database project which covers every aspect involved in conducting examinations in a school, college or university. As concerned to scope of the product, answer sheet evaluation is an essential element for educational organizations. The product will avoid the burden of hard copy storage. It will also provide data security as we are using the secured databases for maintaining the documents. We can also conserve the time and human resources for doing the same task. The data can be maintained for longer period with no loss of data.


1.2 Scope


The software product to be produced “Online Examination Management System” which will allow online examination-evaluation and Offline examination-Online evaluation . The system is designed in favor of the universities which help them to save the answer papers and other information about the examination. It helps them from the manual work for which it is very difficult to distribute the answer sheets of the students to evaluators and the evaluators don’t need to go to the evaluation centers or to carry the papers to home. It reduces the errors in summation of the marks. The “Online Examination Management System” supposes to have the following features:

● The system is designed to handle the activities of the exam controller,Chief examiner evaluators, and the students.

● The system will have the ability to manage

-Examination registration by the student

-Online Examination and its Online evaluation by the evaluators

-Online Evaluation of offline exams

-Answer paper uploading

-Result publishing.

● The system will have the ability to send alerts to the teachers for the evaluation of answer papers.

● The system will allow the teachers to give subject preferences.


1.4 References


1. Software Engineering –A Practitioner’s Approach by Roger S Pressman

2. Open source web development with LAMP by James lee and Brent ware Addison Wesley/Person Education Inc.2003

3. http://homepages.dcc.ufmg.br/~rodolfo/es-1-03/IEEE-Std-830-1998.pdf


2. General Description


It describes the general factors that affect the product and its requirements. This section does not state specific requirements. Instead it provides a background for those requirements, which are defined in section 3, and makes them easier to understand.


2.1 Product Perspective


Examination and Answer sheet evaluation is an essential concern of every educational organization. The ‘Online Examination Management System’ allows the universities to manage online and offline examinations, answer sheet evaluations, get evaluators subject preferences, allot and inform evaluators to evaluate the answer papers of the students, publishing the results with much less time . The students of a university can be recognized from their registration number. ‘Online Examination Management System’ is a web based application.


2.2 Product Functions


The objective is to build a software system that is user friendly and accurately generates and stores data that assists examination and answer paper evaluation. The software system should be convenient for evaluators. The aim of proposed system is to develop a system with improved facilities. The proposed system allows the university to choose offline/online exams for particular courses. For the online examinations, students can login to the system using login ID and password at the time of examination. The answer scripts of each student will be stored in the database. In the case of offline exams, store scanned versions of answer sheets will be stored in the database. Information such as university register number, question paper, and the answer key are also stored on the database. The answer sheets are encrypted using md5 encryption technique to prevent unauthorized access. Therefore an intruder will see the encrypted answer sheets as a meaningless data. Also the register numbers of the answer sheets and answer scripts are encrypted so that the identity of the student is not revealed to the evaluator. It displays error messages if an answer has not been unevaluated or more marks are given in the mark sheet than prescribed. The evaluator checks the answer scripts or answer sheet by comparing it with the answer key. The system generates a mark sheet by tabulating the marks given by the evaluator in the answer scripts of the semester examination and the marks allotted to the student in the internal assessment. However, the marks of the internals are not visible to the evaluator as it may prejudice him while he evaluates the semester answer scripts. Chief examiner can do a random evaluation of answer sheets.The chief examiner finalizes the marks for each paper. He also can check who evaluated the paper and ask for explanation if required or assign another teacher for revaluation. Since the answer scripts are protected from downloading and editing the documents, nobody can tamper with them. It can help in announcing results much earlier as the manual effort is reduced. 

2.3 User Characteristics


The users of the system are:

· Administrator

The administrator is assumed to be have good data management skills and have access to all the data within the system. Administrator can add users.

· Faculty

Faculty can contribute to the question bank by selecting a question pattern.

· Exam Controller

Exam Controller will have access to all examination data fields, but will have limited access to user and privilege data information.

· Evaluators/Teachers

Evaluators will only be able to view answer scripts or sheets and assign marks for them. They are not able to edit or remove any information within the system.

· Students

Students who applied for the scrutiny are allowed to see the answer sheet and they can see the results of examination.

· Chief examiner

Chief examiner will have access to the answer sheets of particular subjects to verify the results.


2.4 User Documentation


The end users of ‘Online Examination Management System’ will be provide a user’s manual for the administrator, exam controllers, chief examiner and evaluators. To assist the user in understanding the product better and to assist them in better utilization of the product and its features, we will be providing an interactive user interface (in DOC format). We also will be giving details to the users where they can understand different features of the system


2.5 Assumptions and Dependencies


We are assuming that the users will not use our product to download copyright. Also, we expect that the users not only use the software to view resources, they will also be updating details and resources for being viewed by other users. We also assume that product users will not do malicious activities on the software.

Stored Procedures in MySQL with example


Stored procedures can is an efficient mechanism to provide code re usability.  MySQL Stored procedures can be used as an API which can be used from different programming languages. Below is an example of a MySQL stored procedure, which selects the values from a table named flowers by taking the id as argument.

DELIMITER //

CREATE PROCEDURE flower_list

(fid int)

BEGIN

  select id, name from flowers where id=fid;

END //

DELIMITER ;


Here we specify a double slash (//) as the delimiter while the procedure is being defined, so that the default delimiter (;) in the procedure definition, can be passed through the server.
The procedure can be executed from MySQL command prompt as well as from MySQL workbench by using the call function along with the argument value for id. This can also be called from triggers, other procedures and also from various application programmers. Recursive call from the same procedure is also possible. Below is an example call to this procedure.
call flower_list(101);

This will return the row from flowers table where id equals 1.

Parameters in MySQL stored procedure


There can be three types of parameters in MySQL stored procedures namely IN, OUT and INOUT.

The default parameter mode is IN. The IN parameter requires that the procedure call must pass an input parameter. The value of out parameter is passed back to the calling program and also its value can be changed inside the stored procedure. The INOUT parameter specifies that the calling program must pass the input parameter to the procedure, its value can be changed inside the procedure and pass the value back to the calling program.

Below is an example MySQL stored procedure with IN and OUT parameters.

DELIMITER //

CREATE PROCEDURE flower_list

(in fid int, out fname varchar(50))

BEGIN

  select name into fname from flowers where id=fid;

END //

DELIMITER ;

This MySQL stored procedure can be executed by invoking the call function with in and out parameter as shown below.

call flower_list(102, @fnames);
select @fnames;

Centralized Student Allotment Process Project Abstract


1. INTRODUCTION 

 

The CENTRALIZED STUDENT ALLOTMENT PROCESS (CSAP) is a Software Project with the main objective to create an automated admission processing system for all engineering programs at various colleges conducting those programs.. The following subsections of the Software Requirements Specifications (SRS) document provide an overview of the entire CENTRALIZED STUDENT ALLOTMENT PROCESS.

1.1 Purpose

 

The Software Requirements Specification (SRS) describes the functions and detailed description of the requirements for the CENTRALIZED STUDENT ALLOTMENT PROCESS (CSAP). This SRS will allow for a complete understanding of what is to be expected of the CSAP to be constructed. The clear understanding of the CSAP and it’s functionality will allow for the correct software to be developed for the end user and will be used for the development of the future stages of the project. This SRS will provide the foundation for the project. From this SRS, the CSAP can be designed, constructed, and finally tested.

The purpose of the SRS document is to describe the external behavior of the CSAP system. Requirements Specification defines and describes the operations, interfaces, performance and quality assurance requirements of the centralized allotment process system. The document also describes the non-functional requirements such as user interfaces and the design constraints. The SRS captures the complete requirements for the system.


1.2 Scope

 

As concerned to scopes of the project, it will automate the admission process and various operations involved in it. The system is designed for the allocation of seats for various engineering programs in various colleges, which help the students as well as the colleges to do the admission process easily within less time and human effort. The product will avoid the burden of the manual operation required to maintain all the records of Colleges and Students. It will also provide data security as we are using the secured database for maintaining documents. We can also conserve time and human resources for doing the same task. The data can be maintained for longer period with no loss of data. Its other factors are cost cutting, operational efficiency, consist view of data and integration with other institutions. Main challenges are effectively sync internal and external operations in such a manner that job can be finished within time limit and integration with different agencies on an agreed upon common data format.

The main reason for choosing this topic is to reduce the time and complexity of maintaining the records and also to easily perform the task of book keeping. It also helps in accurate maintenance admission details which can be referenced by students in later years.


Following are some of the scopes of the proposed system :

 

A single application will be sufficient for applying to different colleges/programs. · This system reduces considerable amount of paper work in the manual admission procedure. · Can be used to maintain admission details which can be referenced by students in later years. · It overcomes all the human biases in the admission process. The system provides security through password authentication and use of secured Database.

1.3 Definitions, Acronyms and Abbreviations

 

CSAP : CENTRALIZED STUDENT ALLOTMENT PROCESS
Administrator : Authority of the system who manage all the things
Registered candidate : The user who registered in the system for the admission process.
End users : Normal user who visit the system to understand about the procedures of CSAP
Colleges : Colleges which comes under the system of Centralized Allotment Process
Database : Collection of all the information monitored by this system.

1.4 References

 

· Software Engineering –A Practitioner’s Approach by Roger S Pressman
· Fundamentals of Database systems by Ramez Elmasri and Shamkant B.Navathe
· http://www.iitd.ernet.in/jee/
· IEEE SRS Format

Online Banking System Project Abstarct

ABSTRACT


ONLINE BANKING is a user friendly banking website which help the customers to do their banking needs without go to bank. It helps to keep the date without any duplication and helps to keep records in a well ordered structure. Banking websites are usual in these times. So online banking website have some additional features. The customer can apply for loan and cheque book through online and can see the update through his account. A new customer can send his registration form through online to the bank. The Manager of the specified bank can see the application and call the customer for later verification on a convenient time. The security features applied to this system are MD5 encryption of data which helps to prevent the identification of original data and CAPTCHA for prevent online bots to attack the website. For make the passwords more secure, the system ask for a specified password format. The administrator can import the customer data to the database from a CSV file. So the data in a CSV file with a predefined format can import to database in a single. As a banking software, in need high security and protection from unauthorized attack. This system ensures maximum protection from many kind of attacks. It gives highly user friendly environment for the customers as well as the employees in the bank. The customers, employee and the super admin has entirely different user area. The main aim of this structure is to protect the employee, administrator account from outsiders. The employee and administrator account are usually configure as intranetworking. So the external network users cannot access to it. This banking system consists of mainly 3 kinds of users. The Super administrator, Employees in the bank and the customers. All the data are stored and accessed from a common database. The users can access the database with limited privileges. The Administrator of the network has full privilege on the customer account and employee accounts. A new employee is added by the administrator. The employee have access to all the customers in the branch which he belongs to. Employees are of different kinds in a bank. It include bank manager, asst. manager, cashier and other staffs. All of them have access to the employee account with different access privileges. The banking system has some features which are not available in other banking websites. The features are online cheque book request and online loan request. For prevent there services from internet bot attacks, the system is packed with the security CAPTCHA. Another factor is the user friendliness of the system. Users can easily work with the system.The product to be produced is an Online Banking System which will automate the different functions inside a bank. The system is helpful for normal users who wants to know about the transactions and transfers he made, employees who have to made the transactions, transfers and other banking functions, and super administrators who have the privilege to access all the data in the system. It helps the users to view the transactions and transfers he made, track the status of his loan and cheque book requests, etc. The Online Banking system supposes to have the following features:

• The system is desired to handle all the activities for a bank.

• The system will provide the users to see the transactions/transfers which he made, request for new loan/ cheque book, view and edit the user profile, etc.

• It helps the bank employees to make a transfer, transactions, view those transactions, accept the new user request, etc.

• Provides the administrator the full control over the user accounts and employee accounts.

• The system will provide the users to apply for a new account, apply for loan, 

• It helps the administrators to control the entire system.

• The bank manager can create and manage a new customer account.

• This Project investigates the entry threshold for providing a new transaction apply for cheque book, check the deposit and withdrawal details, etc. service channel via the real options approach, where the entry threshold is established by using an Internet banking system designed for the use of normal users(individuals), Industrialists, Entrepreneurs, Educational Institutions(Financial sections), Organizations and Academicians under transaction.

• Rate uncertainty.

• Customer must have a valid User Id and password to login to the system

• If a wrong password is given thrice in succession, that account will be locked and the Customer will not be able to use it. When an invalid password is entered a warning is given.

• To the user that his account is going to get locked.

• After the valid user logs in he is shown the list of accounts he has with the bank.

• On selecting the desired account he is taken to a page which shows the present 

• User can request for the details of the last ‘n’ number of transactions that he has 

• A report can also be taken of this.

• User can make a funds transfer to another account in the same bank. User is balance in that particular account number.performed.

• User can transfer funds from his account to any other account with this bank. If provided with a transaction password which is different from the login password. the transaction is successful a notification should appear to the customer, in case it is unsuccessful, a proper message should be given to the customer as to why it failed.

• User can request for cheque book/change of address/stop payment of cheque’s

• User can view his monthly as well as annual statements. He can also take print 

• Generate reports at every section

• Administrator can take a backup of the database for every instance that is 

• All users are authenticated to avail the services.

• FAQ section is also included for end users benefit. out of the same. happening, periodically.


PROPERTIES OF ONLINE BANKING


The properties of the Online Banking System are

• User Friendly Interface

The system has a high user friendly interface. So the users can easily identify the purpose of each buttons and text fields. This make the working easy and it helps to gain more time than in other systems.

• Easy Customization of Data

The bank may have several branches in several areas. The administrator of the website  can manage the name and address of each of these branches. So the particular details will appear on the website when a customer or employee belongs to that branch is signed in.

• High Security

As it is a banking website, it need high security from outside threats. Which will help the system to be more stable. This system is checking the client side and server side validations. This two side verification helps when client side verification turned off. Then the user cants bypass the verification because it also provides a server side validation.

• Efficient

This system is efficient than traditional systems. In traditional systems, we used to keep a manual record of the transactions made by the customers, details of the customers and employees, etc. In such a system, the chances of error is high or duplication of data will be high. But in an online system, we are keeping a well-structured database which helps to keep the data without duplication. The searching function will be more efficient in such a system. With the help of a single click, the authoritative person can see the transaction made by a particular customer or the transactions made by al the customers belongs to the bank.


1. INTRODUCTION


This Software Requirements Specification (SRS) specifies the requirements of the “ONLINE BANKING” system and e-Banking Solution (EBS), which will be used in the Banks. This document will be used by the customer to ensure all specifications are correct and verified by the software engineer to design the system. This document fully and formally describes the requirements of the proposed system. The purpose of this section is to provide the reader with general, background information about the system online banking. It sets out the functional and non-functional requirements and includes a description of the user interface and documentation and training requirements. It will include all the baking facilities which include Deposit, Withdrawal, Money Transfer, etc.

1.1 Purpose


The Software Requirements Specification (SRS) will provide a detailed description of the requirements for the ONLINE BANKING. The SRS describes the functions and performance requirements of the system. The clear understanding of the system and its functionality will allow for the correct software to be developed for the end user and will be used for the development of the future stages of the project. This SRS will provide the foundation for the project. From this SRS, the Online Banking system can be designed, constructed, and finally tested. This SRS will be used by the software engineers constructing the system and the end users. The software engineers will use the SRS to fully understand the expectations of this Online Banking system to construct the appropriate system. The end user will be able to use this SRS as a “test” to see if the software engineers will be constructing the system to their expectations. If it is not to their expectations the end users can specify how it is not to their liking and the software engineers will change the SRS to fit the end users’ needs. The purpose of the SRS document is to describe the external behaviour of the Online Banking system. Requirements Specification defines and describes the operations, interfaces, performance and quality assurance requirements of the Online Banking System. The document also describes the non-functional requirements such as user interfaces and the design constraints. The SRS captures the complete requirements for the system.

1.2 Scope


As competition has intensified and customer needs have also increased, so too have the challenges faced by banks. The pressure on margins has increased, often driven by new market entrants with lower cost bases, and the avalanche of new regulations and compliance seems to gather pace daily. Customers demand access to their financial information regardless of their location or the time of day, and if their current financial institution can’t provide it they can always go to someone else who can.Often installed decades ago, legacy core banking systems just can’t cope – it may be impossible to support the latest products and when it is, the process is complex, time consuming and expensive. Just keeping these systems running can often consume more than 70% of the IT budget leaving little money to gain advantage over competitors. Gaining insight into customer needs can be extremely difficult, involving the collation of a large amount of data from disparate systems held in different formats. And by the time the data is collected it is often too late – the customers’ needs have moved on. We can see long queues of customers in a bank every now and then. This queue is the final result of the slow processing speed (Due to manual entries or non-interactive Software) of the Bank. So, a highly interactive and user friendly solution should be developed. With the implementation of Core Banking Solution (CBS), the customers’ status has been changed from ‘Branch Customers' to "Bank Customers". It is immaterial with which branch of the Bank the customer deals with. When he is a CBS branch customer, all the banking facilities are extended through multiple branches connected under CBS. The customer can walk into any of the CBS branches (need not necessarily his own branch) for the banking needs such as Cash Deposit, Cash withdrawal, Cheque deposit, Transfer of funds, etc. For the smooth working of the bank, the Core Banking Solution needs to be designed in such a way that, all the operations that were previously performed with difficulties are performed easily in this system. For the customers an internet solution is the most appropriate one as almost all customers have access to it.The project is mainly based on the idea of developing an open source banking solution which would replace the existing costlier banking solutions. All the operations that are carried out in the bank manually (like new account registration, deposit, withdrawal, cheque book issue etc.) would be performed automatically and easily by the Core Banking Solution. This would also enable the banks to reduce their annual budget on software expenditures by a greater percentage. There would just be no need to spend hundreds of crore on the banking software any more, as the project would be developed on Open Source License based Technologies. It could also be modified by a group of experts as per requirements and at any time. The concept of Centralized Banking is taken into account in this solution. A well interfaced GUI would be used for connecting to the main database server for updating and retrieving the data of the customers. It would also deal with the Employees of the Bank, their registration, removal, manager allotment, etc.The e-Banking Solution deals with the customers. It would facilitate the customers to perform a wide range of functions like check blocking, fund transfer, cheque book request, viewing account statement etc. over the internet. This would reduce their pains to go to the bank each for each and everything. The Customer would no more be considered as the 'Customer of the Branch' but shall be considered as 'Customer of the Bank No Geographical Limits'. The Online Banking System which will automate the functionalities inside a bank environment. The system is designed for the banks which help the staffs to do the banking processes easily and the data will be stored more efficiently without duplication. The Online 

Banking System supposes to have the following features:


• Easy management of users

• Account categorization

• Easy deposit and withdrawal functions

• Online loan application

• Flexibility of users to work with

• Avoid conflicts in data

1.3 Definition, Acronyms, and Abbreviations


Bank: A place where the customers deposit money for safe keeping.

Bank Employee: The employees of the bank who perform the banking operations.

Bank Customer: The people who have an account in the bank.

CBS: Core Banking Solution

EBS: e-Banking Solution

User: The person who will be using the Product (CBS or EBS)

Online Banking System -SRS Page | 10


1.4 References



  •  Software Engineering –A Practitioner’s Approach by Roger S Pressman
  •  PHP5 Unleashed By John Coggeshall ,Sams Publishing.
  •  Apache Server 2 Bible By Mohammed J. Kabir , Hungry Minds Publishing.
  •  Sam’s Teach Yourself PHP, MySQL and Apache All in One By Julie C. Meloni, Sam’s Publishing 
  • MySQL Building User Interfaces, By Matthew Stucky, New Riders Publishing.