Abstract-Clustering is the process of grouping a set of data objects into multiple groups or clusters with high similarities and dissimilarities. Dissimilarities and Similarities are assessed on the attribute values describing the objects and often involve distance measures. Clustering acts as a data mining tool by having its roots in many application areas such as biology, security, business intelligence, web search etc.Our Institute is currently using a software application with a name -Merit System‖, which evaluates the performance of the staff members regarding their level of teaching by considering various factors. It computes the performance level by collecting feedback from every student. It gives the appraisal result in the form of 30 points earned to every staff member. It acts as a tool for the management of our college to gauge the performance level of the teacher which in turn helps them in assessing annual increments and other promotions.The main drawback of this system is its inability in grouping of staff members like Group-A, Group-B, Group-C etc. Because, many of the staff members have scored the performance points in the range of 21 to 30 which will creates lot of ambiguities to the management to make clusters of staff members to these groups. This issue is the prime concern of this paper and it was given with an approach to solve this problem by considering possible optimum soft computing technique that includes Feed Forward Neural Network approach.

No abstract

The intention of this paper is to analyze how a behavior of a student will influence us in gauging their performance level rather than considering their traditional examination scores. This approach is considered to be one of the informal approaches which guide many school managements to identify good, average and poor category of students. The main criteria used here is behavioral science which explores activities and interactions among the student community when they are inside the school campus.School-Wide Positive Behavior Support can assist in addressing the issues related to the prevention, educational identification and effective intervention implementation through its systemic logic, data-based decision making, and capacity building within and across schools.Clustering is the process of grouping a set of data objects into multiple groups or clusters with high similarities and dissimilarities. Dissimilarities and Similarities are assessed on the attribute values describing the objects and often involve distance measures. Clustering acts as a data mining tool by having its roots in many application areas such as biology, security, business intelligence, web search etc.In this survey, we have involved 200 + students who are currently studying engineering streams in various classes that includes first semester to final semester. Their age group was in the range of 18 to 22 years. Their behavioral survey has been conducted over a span of 4 to 6 months by closely observing their activities, mannerisms and then evaluated by entering in to this system by using the evaluation interface. This evaluation interface consists of 15 features with 4 optional choices.Each choice is rated with a specific numeric value. By taking one of the choices among all the 15 features for each of the student, at the end, he/she will get some score which will be stored in a database. With the help of this score, a manual grouping was done. Later, for the same dataset, a soft computing technique has been applied by working with self organizing feature map algorithm for grouping the students.

Join is an operation in accessing the data from table if number of tables exceeds one. Whenever we need the data which is not available from a single table, then it needs to necessitate using join operation. Sometimes join is required even if there is a single table. It all depends on the format in which we need to display the data in the user environment. In join processes, the accessing of the data depends on the joining conditions with different operators. Here, join condition is a must. For this purpose, generally we are using relational operators along with logical operators. The problem presently we are facing is many of them are not knowing exactly all types of joins, their proper syntaxes and their proper usage. Sometimes it is vey difficult for the teacher or trainer to convince the trainees, students, research scholars in giving right practical examples while we teach SQL joins to them. Even if we use some conventional operators, the performance of the query may results in delayed accessing time in retrieving the data from N number of tables. This is due to lack of knowledge of the programmers on evaluation criteria of the joined queries. Since the present tables are dealing with millions of records, if we take these tables as example tables, then it is very difficult to give the exact demonstration regarding the number of records to be accessed, because, many joining concepts dealing with exact number of records which are working based on Cartesian Product. To avoid all these uncertainties, confusion, ambiguities, in this paper, it has been used with only three simple tables which are given from Oracle Corporation in user schema scott/tiger. The number of records used in these tables is very minimum and are meaningful records. After understanding the basics of all SQL joins, then it is necessary to represent the same queries in relational algebraic notations, because, those are the standard and uniform syntaxes which will be applicable in any of the database software. But the present problem is many of the software developers, specialists, programmers, and researchers are not aware of how to represent queries exactly in that syntax. In order to overcome this, the main focus is to make a familiarity in writing the SQL queries in relational algebraic format along with different types of joins. The main focus of this paper is to learn the basic fundamentals of all types of SQL joins along with algebraic notations in a very easiest, convinced and simple approach. On many stages, it is given with live examples along with SQL code and its result set by using SQLPLUS interface.

No abstract