This dissertation has been submitted by a student. This is not an example of the work written by our professional dissertation writers.

Overview

Mobiles are one of the most versatileelectronicsin the present scenario.It constantly keeps us connected with our near ones even when we are travelling out of our city or to another country. It reduces our tension and gives us feel as we are in home. The biggest advantage of mobile phones is they keep you connected. The developer tries to use this advantage in educational institution such as a college to bring down the interaction gap between management, teachers and students.

1.1 Topic: - Smart Consultation Scheduler and Mobile Messaging System

1.2 Purpose of the situation

Everyone in this world wants to do the work at their fingertips. Mobile is best suitable solution to the problem. It minimizes our burdens (example reminder helps us from remembering all the birthdays, meeting etc). It also gives easier access to the internet anytime, anywhere. There is no doughty that our mobile has made our life a lot convenient. One can interact with anyone, anytime from anywhere through mobile. However there are limitations to it. What if a student wants to consult with a teacher for clearing dough about any topic when he is out for an interview? Generally teachers do not give their cell number to all students. What if a student wants to reserve a book from his college library when he is in the way to college? There may be a situation when college wants to inform all students about urgent information, but some of the student might not be present in the college. Suppose a student is in railway station and wants to confirm about the examination timetable for reserving railway seat to his home in the vacations. How can he confirm that?

Smart Consultation Scheduler and Mobile Messaging System (SCSMS) is a solution to make our life further one more step simpler and increase the services provided by the mobile to the next level. It is being developed mainly for an educational institute such as colleges. The main aim of the system is to reduce the communication gape between student, faculty and management. The Smart Consultation Scheduler and Mobile Messaging System is a mobile application which can be used from anywhere. Through Smart Consultation Scheduler and Mobile Messaging System we can fix consultation, get news and lattés updates, reserve library books, check library lone, download e-book from library etc. The student will be able to do lots of thing which they could not do if they were not in college so the application will increase the freedom of the student.

1.3 Target Reader

As the application will be for educational institution like colleges the targeted reader will be:-

Students: - Students will be the most targeted user as they will be the most frequent user. The system is being designed keeping this thing in mind. Most of the features of the application revolve around the student.

Teachers: - Teachers will be seconde most frequent user. They will use the system mainly to assist the students. They will also use the system to deliver important information and news to the student.

Management: The complete system will be maintained by the management. They will be the system administrator. It will be the job of management to create, delete and manage accounts. Moreover management can also send news to the students.

1.4 Topic Background

In today’s scenario the whole world is sifting to the mobile application. It is known third wave in computer evolution series. With over 3 billion mobile users today, mobile devices have become the most ubiquitous communications medium in the hands of the consumers [2]. Mobile application developmentis quite an active arena today, much due to the popularity and increasing demand of mobile phones. Its growing popularity from several years is making the users more and more enthusiastic [3]. Smart Consultation Scheduler and Mobile Messaging System is a system which make work easy and more interactive, it is the solution provider and making task simple and easier.

1.5 Problem Context

Any information is information if it is timely; else, it is of no use. It really becomes a thing to be concerned about when there is a communication gap in any institution. As we all know, today’s era is of Ubiquitous Computing; anytime anywhere. So the system could be used from anywhere and anytime. The present system which is being used by the college is a web based system. To us the system we need a computer or a laptop. So it restrict us as, it is very tough to find a computer with internet working on it, every time we need to use the system. At that particular moment of time the current system is of no use of we are not able to get an internet connected computer or laptop. Due to this limitation we are not able to remain connected with the institution (college). Even if we open it through the mobile browser it is extremely tough for us to navigate the website which is made for high resolution computer or laptop screen in the limited size display of a mobile.

Apart from this we require many more functionality which is not present in the present working system. Suppose a notice comes for any student in his class. But he was not in the class. There is no option it the present system to inform such student automatically. We need to manually call or send SMS to inform him or tell the student’s friend to inform him. As a result many time the information even do not rich the concerned student at time. Hence lot of effort is required, lot of time is wasted and productivity decreases. Loot of work is done manually. So accuracy is also decreased.

1.6 Rationale

The system is being made in order to provide solution to lots of problem faced by the college. It will improve the information process of the college. Let us take a real life example of our college.

“The students were at home after completing their even semester. The college was reopening at the end of July. However the last date for depositing semester fee was near about 15th of July. Students were not aware about last date of fee deposition, as a result 90% of the student was fined for late fee submission.”

Had the SCSMS been implemented this ambiguity could had been solved just by informing the entire student by sending a message two to three weeks before the last date.

There are many tangible and intangible advantages which we can get from the proposed system.

Tangible benefits: -

  • The first and the foremost advantage of the proposed system is that it reduces the communication gap between students, teachers and management.
  • To fix a consultation we do not need to go to the teacher and roam here and there to searching teacher if teacher is not present in his/her office. This could be done just by pressing few buttons on the mobile.
  • Important information could be delivered to the concerned people at time so that no ambiguity can arise.
  • It will make the work smoother were work could be done just by pressing few buttons. So the system would reduce so much of stress from user head.
  • It will make things lot simpler and reduce human effort. Anyone who wants to use the system can use it easily on his/her mobile, as the system is dedicatedly made for the mobile.
  • As there will not be communication gap so productivity will automatically increase.

Intangible benefits: -

  • It will provide security to the user. If we log on to the present used system (which is a web based application) through other’s computer or laptop, our account may get hacked as there may be spyware like password catcher installed in it.
  • It will save wastage of money, as student does not need to move to cyber cafe to use the system.
  • SCSMS will reduce the wastage of time in searching cyber café.
  • It will increase the knowledge of the student. The discussion forum will help to increase the knowledge of the student.
  • It will make the student comfortable in technical round of the placement process. The student can take test of technical round to practice through the proposed system.
  • It will remove the biased process in any polling. As through the proposed system will do it automatically.

1.7 Objectives of System

Smart Consultation Scheduler and Mobile Messaging System is an automated mobile application. The system communicates with the user and provides the complete information as the user in intended to view. It will reduce the communication gap between student and teachers and management. The application is being developed so that the user does not need to move to any new place to do the work. The main objectives of the system are: -

  1. The proposed system will reduces communication gap between management, teachers and students. The various features such as news alert, messaging system, and m-consultation will reduce the communication gap.
  2. The application will provide ‘ease to express to mass of students’ with messaging service. So the information can easily wide spread to a bulk of student keeping them updated about what is going on in the college.
  3. Save time: The proposed system will enable student to fix consultation through their mobile. The student can also reserve book from their college library through the proposed system from anywhere around without going to the library there by reduces wastage of time.
  4. Increased productivity: As the proposed system will reduce the communication gap among management, teacher, student and keeps them updated so that everyone will be able to perform on the latest scenario, optimizing the productivity.
  5. Save wastage of money: As the present system, which is being used by the college is a web based system. So the students have to search a cyber café each time they want to access some information. However the proposed system adds a solution to it, as it is a mobile application it can be accessed from any ware through our mobile.
  6. Reduces human effort: The proposed system will reduce human effort in many ways. The student will not have to go to the teacher to fix consultation. The student will not need to go to library to reserve a book. They can do this just by pressing few buttons of their mobile.

  7. Ends ambiguity: The proposed system has feature to communicate information to the masses. So the student will be updated with the latest news giving no place to ambiguity to arise.
  8. Increase Freedom: According to Bill Gates “I'm a great believer that any tool that enhances communication has profound effects in terms of how people can learn from each other, and how they can achieve the kind of freedoms that they're interested in”. The proposed system will reduce the restriction from the students and increase their freedom.
  9. Improve accuracy: The proposed system is an automatic system hence it will reduce the accuracy removing the silly mistakes made by human.

1.8 Functionality of System

The functionality of the system is divided into three different categories: core functionality, enhanced functionality and special functionality.

Core functionalities:

Automatically fix consultation if the teacher and student both are ready and this time is not allocated to any other student: - First of all the student requests for consultation to the specific teacher. The message is automatically send to the teacher with suggested time when teacher is not having any class or other meeting. However the teacher can change the time according to his/her wish. Now this time is set as consultation hour and message is sent to both teacher and student about it.

View attendance summary: - The student can see the attendance summery from anywhere anytime.

View result of exams: - As soon as the result is declared a message is forwarded to the student informing him about the result. Now the student can view the result if he/she wishes.

Check library lone, fine: - Student can check name of the book that he borrowed from library. He can also find if there is any fine on him.

Class time table and Exam time table: - whenever the class timetable will be changed the new timetable will be forwarded to the entire student. Student can also view exam timetable whenever declared.

News alert: the student can get the latest news in their cell.

Enhanced functionalities:

  • Get attendance alert:- The student will get attendance alert whenever he will cross the boundary line of attendance such as 3, 6, 9.
  • Reserve a book: - the student will be able to reserve the library book right from his home sleeping in his bed.
  • Download books: - the student can download the e-book and read anywhere he wants.
  • Quick Polling: - It will be used to quick poll and find the eligible candidate for any post such as class representative.
  • Discussion Forum: - the students can discus over any topic in the discussion forum.

Special functionalities:

  • Student can have e- consultation via chatting: - the student can have e-consultation by chatting to work out small problems.
  • Aptitude and technical test: - student can take test to maser themselves where they stand. It will contain mainly multiple choice questions.
  • Download the application through Bluetooth: - any intended student can download the proposed application by moving to a particular place and download the application to his mobile.

Scope and deliverables:

Identification of the scope of the project should be done before developing the system. This allows the developer to know the boundary of the system. So that all the issues related to success of the project can be cleared. It is a fact that no system can be perfect or with no limitation. SCSMS also has some boundaries which add a slate limitation to its scope. Detailed scope of the project has been mentioned below:

Smart Consultation Scheduler and Mobile Messaging System is meant to solve large variety of problems faced. It will reduce the communication gap, reduces time wasting, and reduces human effort and increases performance and accuracy. However there is little limitation to it as well.

Limitations of the scope:

- It will need GPRS facility to work. So by any reason the internet do not work the system will not work.

- It will run only in java supporting mobiles. Although most of the popular like Nokia, Sony Ericsson, Samsung, Motorola, Apple iPhone etc. are J2ME enabled but there are some exception like older versions of Blackberry.

- As the system works on client server architecture, so if the server goes down the entire system will clash.

- It will be used parallel with a website where functionality which requires lot of things to be displayed can be preformed such as marking system.

Chapter 2

Problem Description

“Our problems are man-made; therefore they may be solved by man. No problem of human destiny is beyond human beings”.

- John F. Kennedy

2.1 Problem Description & Proposed Solution

The primary aim of the proposed system is to reduce the communication gap between management, teachers and student and act as a communication channel between them. In the present scenario lot of work is done manually. It requires lot of human effort, time so the end result is not satisfactory. Suppose a student wants to fix a consultation with a teacher. He reaches to the office of the teacher but the teacher was not there. The student stood by the door for 10 min and then went back. After half n hour the student again came but the teacher was not in his office. The student get annoyed went back to his home. So at the end, complete one hour was just a west. There are many more problems faced by the system which is listed below. Most of the problems present in the current system raised because the current system in a website. Many problems are faced as the current system does not have solution to all the features. These problems can be solved through developing a mobile application and increasing the functionality. Below is a list of problem along with the proposed solution:

Problem: To fix a consultation student need to go to the teacher then and get a time and need to come back for consultation on the date and time as fixed by teacher. So lots of time consuming, manual work has to be done.

Proposed Solution: Automatic consultation fixer has been proposed in the proposed system. In this module whenever a student will request teacher for consultation through his mobile, the request will be forwarded to the teacher. As soon as the teacher will approve the request a proposed time will be generated by going through the timetable of the student and teacher. The consultation will be fixed when teacher accept it.

Problem: As the consultation is fixed manually so the time of consultation may collide with other students’ time.

Proposed Solution: The time once allotted a student by Automatic consultation fixer will never be allotted to other student. So there is no chance that time gets collided.

Problem: If student or teacher wants to cancel the consultation then there is no way to inform other.

Proposed Solution: Automatic consultation fixer will have feature to cancel consultation. As soon as teacher or student cancels consultation, a message will be forwarded to other one.

Problem: Some student are of shy and feel uncomfortable in asking problems with teacher, so they will not be able to consult teacher regarding any problem.

Proposed Solution: Even the shy students can have consultation through the proposed system. There will be a feature for m-consultation where students can consult with teacher via chatting through mobile without paying any charge for SMS.

Problem: If a student in not in college then he cannot reserve a book from a library.

Proposed Solution: In the proposed system the application will have a feature of reserving a book form library from anywhere in this world through our mobile having GPRS connectivity.

Problem: The student cannot use library resources when they are not college.

Proposed Solution: In the proposed system the application will have a feature of downloading e-books form library through student’s mobile.

Problem: If a student is out of the college then there is no way to remain connected with the college for latest news updates such news of visit of any company for placement.

Proposed Solution: In the proposed system the application will have a feature of news alert where management or teacher can inform the latest news alert directly to the students mobile.

Problem: There is no way to view the class or examination timetable right from the students’ home.

Proposed Solution: Student can also view the class or examination timetable right from the students’ home through the proposed system.

Problem: The present system does not have any criteria to conduct polling for any post. Polling is done manually so the final output can be biased.

Proposed Solution: Polling has also been added to the system so the result produced by the pool is not biased and more and more student takes part in the poll.

Problem: As now a day the demand of aptitude test is at climax but the present system fails to deliver any such facility.

Proposed Solution: Keeping the demand of aptitude test and student’s need a module for aptitude test module has also been added.

Chapter 3

Literature Review

3.1 Domain Research

3.1.1 Smart Consultation Scheduler and Mobile Messaging System

3.1.2 Major components that should be present in smart consultation scheduler and mobile messaging system

3.2 Research on Similar System

3.3 Architecture of the System

3.1 Domain Research:

3.1.1 Smart Consultation Scheduler and Mobile Messaging System

In the today’s world scenario everyone wish to perform work and task at their fingertip. And mobile is the device which allows them to fulfill their wish more effectively and efficiently. Mobile is the most usable device now days because of lots of benefits attached to it. Mobile is helpful in various ways, it give all the information, news ,events etc and make people aware of things to do and things to remember.

Smart Consultation Scheduler and Mobile Messaging System is a system which make work easy and more interactive, it is the solution provider and making task simple and easier.

This system is based on the college management automation system. The application developed is an automated application suite of Institute or college administration including student information, employee information, library, fees managing, student information, subject, time table, student attendance, marks, discipline, performance etc. It permits the user to retrieve, manipulate and present student data in a meaningful and user friendly manner, generating reports dynamically. Smart Consultation Scheduler and Mobile Messaging System totally work like college automation system but it off with latest technology and of wider use.

This provides various facilities of college online. The main goal and aim of this system is to reduce communication gap between student, faculties and also management. The Smart Consultation Scheduler and Mobile Messaging System is an application to which you can use it from anywhere with your mobile. Through Smart Consultation Scheduler and Mobile Messaging System we can fix consultation, get news and lattés updates, reserve library books, check library lone, download e-book from library etc.

Present systems is web based and this Smart Consultation Scheduler and Mobile Messaging System is mobile service which is more effective and fast and more beneficial.

3.1.2 Major components that should be present in smart consultation scheduler and mobile messaging system

As mobile is the most usable device all over the world now. Everyone wants to access everything on their mobile. Smart Consultation Scheduler and Mobile Messaging System is such an application which can be used anywhere from their mobile. This system include following components: -

  • Attendance system for the students - The student can see the attendance summery from anywhere anytime.
  • Result of the students- As soon as the result is declared a message is forwarded to the student informing him about the result. Now the student can view the result if he wishes.
  • Online Library - Student can check name of the book that he borrowed from library. He can also find if there is any fine on him.
  • Automating Consultation with the teacher (for students), head of the organization and among staff (for staffs)- Automatically fix consultation if the teacher and student both are ready and this time is not allocated to any other student .A student can also take consultation via mean of m chatting.
  • Class time table and Exam time table. - Whenever the class timetable will be changed the new timetable will be forwarded to the entire student. Student can also view exam timetable whenever declared.
  • News alert- There will be facility of sending news to all the students and also to the faculties.
  • Online Polling- There is another feature of online polling, where student can poll about any event.
  • Aptitude Test- Student can give aptitude test from their mobile and can improve their problem solving skill.

3.2 Research on Similar System

Research is a method or practice which direct toward the increase of knowledge, the major goal of research is to gain vast knowledge with the better understanding of the project under study.Smart Consultation Scheduler and Mobile Messaging System is also a solution to make our life further one step simpler. It will be mainly for an educational institute such as colleges. The main aim of the system is to reduce the communication gap between student, faculty and management. The similar kind of system in today’s scenario are limiting and lacking in various features. Therefore to make “Smart Consultation Scheduler and Mobile Messaging System” more efficient it is necessary to compare it with existing system.

Take an example of Webspace of APIIT SD INDIA. In this Webspace there are many functionalities still it lacking behind the “Smart Consultation Scheduler and Mobile Messaging System”. In the current Webspace there is no option to take consultation hour with faculty online. And there is not a feature of aptitude test online polling. The present system does not have any criteria to conduct polling for any post and as now a day the demand of aptitude test is at climax but the present system fails to deliver any such facility. Or also not any feature of class and exam time schedule. In this way this similar system is far behind in functionalities as compared to the proposed system. And on the basis of above mentioned research it has been conclude that propose system have much better functionality and features than existing system.

Conclusion

on the basisof research which has been carried out above it has been clear that “Smart Consultation Scheduler and Mobile Messaging System” is more effective, more functional and efficient as compared to the existing system. This system will make various tasks of college easier and will make them more interactive. It will save time get waste in taking consultation hour through mobile and it will give news about any event or about anything immediately. This system will be helpful and quite handful for the student and faculties.

3.3 Architecture of the System

Architecture of the “Smart Consultation Scheduler and Mobile Messaging System” system is 3-Tier Client/Server Architecture.

3-tier application is organized into three major disjunctive tiers on layers.

Client Tier (made in J2ME)

Application Tier (made in J2EE)

Database Tier (MySQL)

Benefits of using 3-Tier architecture are mentioned below:

  1. Main benefit of 3-Tier architecture is that any other tier can be replaced without affecting the other tiers. For example if the developer finds any bug in calculating fine, only J2EE application page to calculate fine need to be changed without changing J2ME client application.
  2. Improved security as it is implemented at multiple levels. If we uses direct communication between the database and the mobile application. Database name, password can be extracted and then the hacker can do anything even can delete the database.
  3. Only valid data is allowed to be updated in the database and the risk of a scoundrel client application corrupting data is removed. As the database will be at the server and only authorized person will have the username and password to access it.
  4. Improved data integrity. As the database will be at the server so every user will use same database. Hence data integrity will be improved.
  5. It has improved scalability because the application servers can be deploying on many machines [5]. Even the number of user will be increased the web application can be deployed on multiple server to support this large chunk of users.

Chapter 4

Research Methods

“Research is to see what everybody else has seen,

and to think what nobody else has thought”

- Albert Szent-Gyorgyi

Overview:

4.1 Primary Research

4.2 Secondary Research

4.3 Academic Research

4.4 Technical Research

4.4.1 Programming Environment Research

4.4.2 Database Research

4.5 SYSTEM ARCHITECTURE

4.1 Primary Research

Primary research involves gettingoriginal datadirectly from the user about the product or market [4]. It is the initial research that is done during the development of a system. The primary objective of the primary research is to gather preliminary information which could support the designing of the application. So it is fundamental step, in order to continue with development of the application. Along with this, primary research is also used to gather user requirements on the system being developed and to estimate the feasibility of the proposed system. Primary research is done with the direct involvement of the targeted reader.

There are many techniques to carry out primary research such as Questionnaires, Interview, Brain Storming, Onsite observation, Pilot study, Focus Group etc. However the developer have used questionnaire to perform primary research.

Questionnaires

It is a method of gathering information from a group of individuals using identical procedures for each person. Questionnaireis a data collection tool in which written questions are presented that are to be answered by the respondents in written form. The questionnaires are to be distributed to the student of a college who are using similar type of system. These students can suggest the good feature present in the system and the limitation in the present system which they are using.

Justification: The target readers are already using simpler type of system having few of the functionality as the proposed system have. So users are aware about it up to some extent and they know what they want and what they do not. The proposed system is made for large group of user. Questionnaire makes the work easy as it can be conducted on a group of individuals using identical procedure.

There are three types of questionnaire depending on type of user; Students, Teachers and administrator.

Sample Questioner

Dear Respondent:

The developer is a Final Year Degree student from Asia Pacific Institute of Information Technology who is currently doing a Final Year Project which entitled Smart Consultation Scheduler and Mobile Messaging System. The main purpose of the system is to reduce the communication gap between management and teacher and student by reaching to their cell phones. The system will help the student and teacher to fix consultation automatically by suggesting a time when both of them are free through checking the timetable of student and teacher. With the help of this mobile application the student can reserve a book from library or check for fine, issued book on his account. Management can send the latest news or information about any meeting directly to the student’s cell. The student can check attendance summery, result, examination and class timetable through this system. Student can go for an aptitude or similar test having multiple options to verify their level. However these features can be moderated depending on your response. So your response is highly important for me.

As you are part of such institution and familiar with such system so you can help us in defining the structure or functionality of the system. These questionnaires will not take more than 5 minutes of your time. It is having objective type question where you need to check one or more option or write one/few words depending on the question.

The questionnaire does not contain any such emotional or personal question. However the information provided by you will not be disclosed to anyone. Even if the developer needs to be share, it will not be done without your permission.

Thank you a lot for participating. Please proceed further to the questionnaire section.

PERSONAL INFORMATION

Name _____________________________________________________

E-Mail _____________________________________________________

Questionnaires (for student)

1. Have you come across Smart Consultation Scheduler and Mobile Messaging System (SCSMS) or similar application?

[ ] Yes

[ ] No

If yes please specify the system’s name: ____________________________________

_____________________________________________________________________ Justification: This question will let me know about any pre-existing system from which the developer can generate an idea about user requirement and working of the system.

2. Based on your opinion what will be the greatest advantage of such system (SCSMS)?

[ ] Reduce the communication gap between management, teacher and student

[ ] Time saving

[ ] Require less effort

[ ] Other

If others, then please specify hear _________________________________________

____________________________________________________________________ Justification: this question will let me to know about interest behind using the system.

3. Do you have GPRS connectivity in your mobile?

[ ] Yes

[ ] No

Justification: As the system works totally on GPRS, so will provide the developer an idea about whether most of them can use the system or not.

4. How should be the interface of the system look like?

[ ] List Type

[ ] widgets (menu based, as in mobiles)

[ ] Other

If other, then please specify ______________________________________________ _____________________________________________________________________ Justification: It will help the developer to finalize the interface of the system which will be more liked by the user.

5. How would you like to search to search a teacher for fixing a consultation?

[ ] By teacher’s name

[ ] By subject

Justification: This question will help the developer to identify, how to search a teacher for consultation for better user satisfaction.

6. Can your problem be solved through m-chatting with teacher?

[ ] Yes, some of them

[ ] Yes, all of them

[ ] No

Justification: This question will help the developer to generate an idea about whether the student needs the m-chatting.

7. How would you like to search a book to reserve it from a library?

[ ] By book’s name

[ ] By category

Justification: Since the book can be searched through different ways. This question will help the developer to provide the options that is more accepted by the user.

8. Would u like to download and read an e-book on mobile?

(It will take some time as the book will be downloaded from server.)

[ ] Yes

[ ] No

Justification: This question will tell the user majority whether the user wants this facility or not.

9. Do you have “Adobe Reader Lite” installed in your mobile?

[ ] Yes

[ ] No

Justification: Since we need “Adobe Reader Lite” to open an e-book. So this question will say whether setup of “Adobe Reader Lite will also need to be provided along with the application setup.

10. How would you like to view the attendance summery?

[ ] In percentage

[ ] Number of absent and present

Justification: This question will help the developer to know preferred way for viewing the attendance.

11. Do you like to have discussion forum in SCSMS?

(Note: - You will be able to write and read very limited content due to limited screen size.)

[ ] Yes

[ ] No

Justification: As there is a size constraint with the discussion forum. So this will let the user know that is the user satisfied with that.

Questionnaires (for teachers)

1. Have you come across Smart Consultation Scheduler and Mobile Messaging System (SCSMS) or similar application?

[ ] Yes

[ ] No

If yes please specify the system’s name: ____________________________________

_____________________________________________________________________ Justification: This question will let me know about any pre-existing system from which the developer can generate an idea about user requirement and working of the system.

2. Based on your opinion what will be the greatest advantage of such system (SCSMS)?

[ ] Reduce the communication gap between management, teacher and student

[ ] Time saving

[ ] Require less effort

[ ] Other

If others, then please specify hear _________________________________________

____________________________________________________________________ Justification: this question will let me to know about interest behind using the system.

3. Do you have GPRS connectivity in your mobile?

[ ] Yes

[ ] No

Justification: As the system works totally on GPRS, so will provide the developer an idea about whether most of them can use the system or not.

4. How should be the interface of the system look like?

[ ] List Type

[ ] widgets (menu based, as in mobiles)

[ ] Other

If other, then please specify ______________________________________________ _____________________________________________________________________ Justification: It will help the developer to finalize the interface of the system which will be more liked by the user.

5. The discussion forum should be

[ ] Only for students

[ ] Both, for students and teachers

Justification: This question will let the developer know whether the teachers are interested in it or not.

6. Are you comfortable with “m-Consultation” provided to the student to clear there confusion through mobile chatting with the teachers?

[ ] Yes

[ ] No

Justification: This question will let the developer whether the teachers are comfortable for chatting with student to clear their concept.

7. What should be the maximum size of the message used to inform the student(s) about any information?

(Note: - We have limited size of screen to display it.)

[ ] Up to 250 characters

[ ] Up to 500 characters

[ ] Up to 750 characters

[ ] Up to 1000 characters

Justification: This question will help to identify the maximum number of characters needed by the teachers to deliver the notice.

Questionnaires (for administrator)

1. Have you come across Smart Consultation Scheduler and Mobile Messaging System (SCSMS) or similar application?

[ ] Yes

[ ] No

If yes please specify the system’s name: ____________________________________

_____________________________________________________________________ Justification: This question will let me know about any pre-existing system from which the developer can generate an idea about user requirement and working of the system.

2. Based on your opinion what will be the greatest advantage of such system (SCSMS)?

[ ] Reduce the communication gap between management, teacher and student

[ ] Time saving

[ ] Require less effort

[ ] Other

If others, then please specify hear _________________________________________

____________________________________________________________________ Justification: this question will let me to know about interest behind using the system.

3. Do you have GPRS connectivity in your mobile?

[ ] Yes

[ ] No

Justification: As the system works totally on GPRS, so will provide the developer an idea about whether most of them can use the system or not.

4. How should be the interface of the system look like?

[ ] List Type

[ ] widgets (menu based, as in mobiles)

[ ] Other

If other, then please specify ______________________________________________ _____________________________________________________________________ Justification: It will help the developer to finalize the interface of the system which will be more liked by the user.

5. Do you need the option to block users?

[ ] Yes

[ ] No

Justification: This question will help the developer to identify whether the SA need the blocking option or not.

6. Do you want to limit the maximum number of messages send by a student within a given time frame?

[ ] Yes

[ ] No

Justification: This question will let the developer whether the administration wants to limit maximum number of messages to reduce its misuse.

7. Do you need to shutdown the application during holyday?

[ ] Yes

[ ] Only those functionality which require teacher’s co-operation

[ ] No

Justification: This question will let the developer to know how the administrator wants to run the system.

4.2 Secondary research

Secondary research occurs generally when a Primary Research has been completed. We perform secondary research when project requires a summary or collection of existing data. Secondary research includes sources that already exist such as previous research reports, newspaper, magazine and journal content, and government and NGO statistics.

Secondary research requires the preliminary stage of research to determine what is known already and what new data is required. However there may be cases where, secondary research may make be the only research technique used.

4.2.1Academic Research

Methodology Selection Research

This segment elucidates the methodology model adopted for the project development from initiation to implementation and testing. There are many methodologies existing, among them many have becoming much popular since they facilitate IT company to foster their project development and allow to maintain acknowledged quality to keep project user requirement fulfilled. This research stage establishes a bird's eye view of the intended software product, and uses this to establish the basic project structure, evaluate feasibility and risks associated with the project, and describe appropriate management and technical approaches [6].

The main aim of choosing different development plan is to take better decision. It is descriptive or prescriptive characterization of how software is or should be developed. As the demand of the system may change to a little bit depending on the customer’s request so, the developer have chosen iterative model.

Iterative Model

It is at the heart of a cyclicsoftware development processdeveloped in response to the weaknesses of thewaterfall model. It starts with an initial planning and ends with deployment with the cyclic interactions in between. It does not begin with full system or project requirements. In iterative model we can move to the previous phases if needed. Development of system starts with some basic specification. However we can reevaluate to additional functionality. This procedure can be repeated in order to produce an upgraded edition of software in a cyclic manner.

Iterative model has following phases which run in a loop:-

(http://www.snyders.us/images/solutions/Iterative.jpg Accessed on 1.10.2010)

RequirementsPhase: In this phase the requirements for the software are gathered and analyzed. Iteration should eventually result in a requirements phase that produces a complete and final specification of requirements.

Design phase: In design phase a software solution to meet the requirements is designed. This may be a new design, or an extension of an earlier design.

Implementation & Test Phase: Implementation & Test Phase deals with the software coding, integration and testing.

Review Phase: In review phase the software is evaluated, the current requirements are reviewed, and changes and additions to requirements proposed.

In iterative for each cycle of the model, a decision is made as to whether the system produced by the iteration appropriate, or kept as a starting point for the next cycle. Ultimately a point will be achieved where the requirements are complete and the system can be delivered, or it becomes impossible to enhance the system as required, and a fresh start has to be done in order to achieve the requirement.


The greatest advantage of iterative its successive approximation. The benefit of iterative software development lifecycle methods depends on how rapidly they converge on the final solution. The key behind successful use of an iterative model is rigorous change of requirements, and verification (including testing) of each version of the software requirements for each cycle of the model. Every individual cycle of the model produces system that requires testing at the unit level, for software integration, for system integration and for acceptance. Since the system evolves through successive iteration, tests have to be repeated and extended to verify each version of the system [7].

Reason to choose Iterative Model:

The most important reason for choosing iterative model is the flexibility it has. Iterative Design is, at the surface level, really only different from the waterfall methodology in one way.In other words, iterating is designing and, more specifically, understanding what one is designing through actually creating it. Perhaps most importantly, an underlying principle of the iterative method is thatuntil you have actually built what you are designing, you are not going to be able to fully understand it. There are many great reasons for going iterative. One of the most significant is the ability to discover design problems earlier and thereby reduce overall project risk. As all the functionality of the proposed system is divided into three level depending on their need; core functionality, enhanced functionality and special functionality, so iterative model is best fitting the system requirement.

Few more reasons behind choosing iterative model are:

Discover Problems Earlier: One of the greatest threats to any design is discovering design problems late in the project lifecycle. The later you make the discovery, and the bigger the problem, the greater the risk to your project. However with Iterative Model it takes very little time to solve the problem. As in the proposed system there are many individual independent units so the problem at each cycle can be removed so that there is no problem in after integrating them.

Get Reliable User Feedback: When presenting sketches, prototypes to users for their feedback, we are effectively asking them to imagine how the product will work, to prototype it in their mind as it were, and then provide feedback on what they are imagining. So with iterative model there is always a chance of betterment of the system. Most of the units of the proposed system are independent from one another so after completing each cycle we can perform user acceptance test.

It helpsidentify the source of the last error(compilation or execution); because you know it's in the code you just added in this iteration. These makes finding bugs much faster and reduce the time wasted in bug finding.

4.3 Technical Research

After this is the part of the research developer can come to the conclusion about every technology which is going to be used in order to develop the system. The research work has to been performed in such a way that on each topic short descriptions of available technologies are given and directly compared them the proposed system.

4.3.1 Programming Environment Research

Aim of this research is to recognize the leading programming languages and the platforms that can be used for developing the proposed system. In order to choose a programming language for developing the proposed system, the most important factor that should be considered is platform independence. As the proposed system is a mobile application so platform is very important. After completing the research, the developer has decided to choose J2ME for development of the proposed application. However J2EE will also be used in order to communicate with server.

J2ME

J2ME is aimed squarely at consumer devices with limited power. Many such devices (e.g., a mobile phone or pager) have no option to download and install software beyond what was configured during the manufacturing process. With the introduction of J2ME, "micro" devices no longer need to be "static" in nature. Not unlike a web browser downloading Java applets, an implementation of J2ME on a device affords the option to browse, download and install Java applications and content.( Muchow John W. , December 21, 2001, Core J2ME Technology & MIDP, Prentice Hall PTR,)

Our life is getting changed a way by small consumer electronics. Even when we are not in home, mobile phones let us communicate with others at home or office. They let us send email, surf the internet and run applications of all shapes and forms. Now we have access to the features inherited by the java on mobile with the introduction of Java for such devices. However it would not be a good idea to have the entire J2SE API available on micro device. There are many reasons behind that. We cannot have all the functionality available AWT on a mobile phone having limited display. The reason behind introduction of J2ME (Micro Edition) was the need of consumer and demand of J2SE and J2EE. Within “Micro Edition” the capabilities of devices may vary greatly. The size of display of various devices may vary a lot. Even the mobile phones with same size of display may have different capability. Generally a cell phone is limited in their physical size. To accommodate broad range cell phones J2ME introduces the concept of profile and configuration.

Configurations

Sun introduced the Configuration to support the broad range of products that fit within the scope of J2ME.It allows J2ME to be comparable with a broad range of devices. It is directly tied with JVM. The core Java libraries of the JVM is defined by configuration for that particular Configuration. It is mainly of two types CDC and CLDC.

Connected Device Configuration (CDC)

It is mainly for PDA, setup box etc having less memory but not very much.

  • 512 kilobytes (minimum) memory for running Java
  • 256 kilobytes (minimum) for runtime memory allocation
  • Network connectivity, possibly persistent and high bandwidth

Connected, Limited Device Configuration (CLDC)

This is mainly for mobile phones having very limited power, limited memory, and limited processor. The minimum requirements of CLDC are:

  • 128 kilobytes memory for running Java
  • 32 kilobytes memory for runtime memory allocation
  • Restricted user interface
  • Low power, typically battery powered
  • Network connectivity, typically wireless, with low bandwidth and intermittent access

Again inside similar type do devices memory, power, display can differ. This can be controlled through profiles.

Profiles

It is fine that devices will come under one configuration or other. A mobile phone and pager will fit in CLDC. But, configuration of the device can still vary from one other. This broad range of capabilities issues can be addressed and make technology profile was introduced by Sun. Profile provides a libraries for developer for a cretin type of device. Most used profile for mobile phones is Mobile Information Device Profile (MIDP).

APIs for user interface components, persistent storage, input and event handling, networking and timers is defined by MIDP taking into consideration the screen and memory limitations of mobile devices.

(LI SING, KNUDSEN JONATHAN, 2005, Beginning J2ME: From Novice to Professional, Apress)

Justification behind selecting J2ME

Write once, run anywhere (WORA): J2me inherits platform independence feature from J2SE. As the proposed system is a mobile application and there is large verity of mobiles used by students. So we need a language that supports most of them.

More than 3 million used in this world are java enabled. So the scope of not running of application on user application is reduced up to a large extent.

Security: Second compelling reason for using Java for small device development is security. The Java Virtual Machine (JVM) used in the CLDC implements only a partial bytecode verifier that means that part of the important task of bytecode verification must be performed off the MIDP device. Second, the CLDC does not allow for application-defined class loaders. So the security feature is much enhanced in J2ME. So the user’s personal information like results can remain secret [8].

4.3.2 Database Research

Developer has opted J2ME as programming language and now it is time to select the backend for the application for storing valuable information. Due to this reason, a thorough research on the database that provides maximum integrity to J2ME. Through research the developer was able to finalize the database. MySQL will be used as the backend.

MySQL

Database is divided in two flavours: a flat database (or non-relational database) and a relational database. Relational database is much more oriented to the human way of thinking and is often preferred over the flat databases that are just stored on hard drives like a text file. MySQL is a relational database.

Relational database contains tables that store data. Table contain rows and columns. The columns define the kinds of information that will be stored in the table.

MySQL is a fast, reliable,multi-user, multithreaded, Relational Database Management System (RDBMS). It is one of the most popular databases. Its popularity is also increase because it is an open source database which means it is free of cost and can be downloaded easily through internet. Another advantage of MySQL is it is Platform independent.

The reasons behind choosing MySQL are

MySQL is Open source, which can be available any time

MySQL has no cost of development purpose.

It is Platform Independent.

It is day by day updating with new facilities.

Good for smallapplication.

It has a good power these days [10].

SYSTEM ARCHITECTURE

There are mainly two types of network Architecture peer to peer architected and client server architecture. The proposed system will have client server architecture. It describes the relationship between two computers in which one computer makes a request (called client) and other serve the response to the request (called server). In a client-server environment files are kept at the centralized, high speed server and clients can access these file from server. Network access speeds are usually faster than those found on other architecture such as peer-to-peer, which is reasonable given the vast numbers of clients that this architecture can support.

Advantage:

  • Client-server has faster access speeds as large numbers of clients are designed to support file transfer.
  • It becomes easier to upgrade applications and files as they are held on one single place.
  • Require less memory as only one copy of the file is used by all the system.
  • As security is handled by the server so security is enhanced in a client server network.

Chapter 5

Analysis and Design

5.1 CRITICAL ANALYSIS OF RESEARCH WORKS

5. 2 DESIGNING

5.2.1 Use case diagrams

5.1 CRITICAL ANALYSIS OF RESEARCH WORKS

Analysis is done after the primary and secondary research being done by the developer. It is done to draw conclusion by infringing the data collected through the primary and secondary research. So in this part of the document analysis is to be done on the primary research that was done through questionnaires for Smart Consultation Scheduler and Mobile Messaging System.

Analysis on primary research

Have you come across Smart Consultation Scheduler and Mobile Messaging System (SCSMS) or similar application?

[ ] Yes

[ ] No

Inference – This question gives an idea that most of the users are familiar with system similar to the system. So the developer can conclude that the views provided by the users will be very genuine.

Based on your opinion what will be the greatest advantage of such system (SCSMS)?

[ ] Reduce the communication gap between management, teacher and student

[ ] Time saving

[ ] Require less effort

[ ] Other

Inference –This question gives an idea that most of the user view SCSMS as a solution to reduce the communication gap between management, teachers and students. However many user also thinks that the SCSMS is to for time saving and reducing human effort. So while developing the system, the developer should take care all the three options.

Do you have GPRS connectivity in your mobile?

[ ] Yes

[ ] No

Inference – This question give an idea to the developer that most of the users are having GPRS connectivity. So scope of the proposed system is increased up to a large extent.

How should be the interface of the system look like?

[ ] List Type

[ ] widgets (menu based, as in mobiles)

[ ] Other

Inference – This question gives an idea to the developer how the interface of the system should be. After viewing the chart developer can understand that most of the users prefer widgets.

How would you like to search to search a teacher for fixing a consultation?

[ ] By teacher’s name

[ ] By subject

Inference – This question gives an idea to the developer that most of the users prefer to search teacher through their name.

Can your problem be solved through m-chatting with teacher?

[ ] Yes, some of them

[ ] Yes, all of them

[ ] No

Inference – This question an idea that most of the students believe that yes some of the problem could be solved through m-consultation.

How would you like to search a book to reserve it from a library?

[ ] By book’s name

[ ] By category

Inference – This question an idea to the developer that students prefer to search book by category.

Would u like to download and read an e-book on mobile?

(It will take some time as the book will be downloaded from server.)

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that student would like to download book from the server.

Do you have “Adobe Reader Lite” installed in your mobile?

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that most of the students are having “Adobe Reader Lite” installed in it.

How would you like to view the attendance summery?

[ ] In percentage

[ ] Number of absent and present

Inference – This question gives an idea to the developer that most of the student like to view the report in percentage.

Do you like to have discussion forum in SCSMS?

(Note: - You will be able to write and read very limited content due to limited screen size.)

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that students have a mixed view about discussion forum.

The discussion forum should be

[ ] Only for students

[ ] Both, for students and teachers

Inference – This question gives an idea to the developer that most of the teachers wants to participate in discussion forum.

Are you comfortable with “m-Consultation” provided to the student to clear there confusion through mobile chatting with the teachers?

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that the teachers do not have any problem in helping students through m-consultation.

What should be the maximum size of the message used to inform the student(s) about any information?

(Note: - We have limited size of screen to display it.)

[ ] Up to 250 characters

[ ] Up to 500 characters

[ ] Up to 750 characters

[ ] Up to 1000 characters

Inference – This question gives an idea to the developer that most of the teachers think that UP to 1000 character will be better option for convening the information.

Do you need the option to block users?

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that administrator wants the feature of blocking the student.

Do you want to limit the maximum number of messages send by a student within a given time frame?

[ ] Yes

[ ] No

Inference – This question gives an idea to the developer that administrator do not want to impose any limitation in number of messages send.

Do you need to shutdown the application during holyday?

[ ] Yes

[ ] Only those functionality which require teacher’s co-operation

[ ] No

Inference – This question gives an idea to the developer that the administrator does not want to shutdown the system event during off days.

Conclusion

Through analyzing the system the developer can conclude that the user have great hope from the proposed system. They view the proposed system as a solution for many of their problems and will reduce the communication gap between management, teacher and students, reduce the wastage of time and human effort. The system has very high scoop of getting success.

5. 2 DESIGNING

5.2.1 Use case diagrams

Use case diagram for Administrator

Description

Use Case Name

Log In

Description

The administrator can log in through this form.

Actors

Administrator

Assumptions

The user has administrator application and just opened the application and is not logged in

Steps

Enter valid username and password

Click on the “Log In” button

http://www.bredemeyer.com/pdf_files/use_case.pdf

Use Case Name

Add Poll

Description

The administrator can create a new poll hear

Actors

Administrator

Assumptions

The user is logged in

Steps

Add question or post for which student views will be taken.

Add option or candidate for poll.

Use Case Name

Delete Poll

Description

The administrator can delete a poll from a list of existing poll

Actors

Administrator

Assumptions

The user is logged in

Steps

Selects a poll from list of existing list.

Press delete to delete the selected poll

Use Case Name

Send News or messages

Description

The administrator can send notice or message to the students.

Actors

Administrator

Assumptions

The user is logged in

Steps

Admin

Selected poll can be deleted hear

Use case diagram for Teachers

Description

Use Case Name

Log In

Description

Teacher can log in through this form.

Actors

Teacher

Assumptions

The user has teacher’s application and just opened the application and is not logged in

Steps

Enter valid username and password

Click on the “Log In” button

Use Case Name

Fix Consultation

Description

Teacher can accept consultation request send by students

Actors

Teacher

Assumptions

User(teacher) is logged in

Steps

Select the request send by student

If date and time subjected by application is not fine then chance it to preferred time and date.

Select “Fix” from the menu if reedy to provide consultation

If not interested then select “Reject” from the menu

Use Case Name

Check Consultation

Description

Teacher can check for consultation request send by students

Actors

Teacher

Assumptions

User(teacher) is logged in

Steps

Select “Check Consultation” from “ConsultationMenuForm”

Use Case Name

Cancel Consultation

Description

Teacher can cancel for consultation request send by students

Actors

Teacher

Assumptions

User(teacher) is logged in

Steps

Select the request send by student which the user wants to cancel

Select “Cancel Consultation” from the menu

Use case diagram for Students

Request for consultation

Normalization is a method to efficiently organizing the data in database. There are mainly two goals of normalization: reducing redundancy and ensuring data dependencies make sense (only storing related data in a table). It avoids duplication of data and anomalies (insert Anomaly, delete anomaly and update anomaly). Actually it has seven forms but we follow just up to3rd normal form.

http://databases.about.com/od/specificproducts/a/normalization.htm

Zero NF

Initially all the attribute are identified and clubbed under single table, i.e. SCSMS.

1stNF

In the First Normal form all the rows should have only one value thus this was done by taking 1 value at each row. To making each record unique designer has break the table into 12 different table and then primary key is assign to each table.

Sr. No.

Table Name

Primary Key

Field Name

1.

Attendance

ATTENDANCE_ID

ATTENDANCE_ID, DATE, SUBJECT, STUDENT_ID, STATUS, TEACHER_ID

2.

Class-timetable

TIMETABLE_ID

TIMETABLE_ID, SEMESTER, BRANCH, SECTION, DAY, SUBJECT, TYPE, LECTURE_ ROOM, START_TIME, END_TIME, TEACHER_ID

3.

Consultation

CONSULTATION_ID

CONSULTATION_ID, STUDENT_ID, TEACHER_ID, TIME, REQUEST_DATE, ISACCEPTED, ACCEPTED_DATE,

4.

Discussion

DISCUSSION_ID

DISCUSSION_ID, TOPIC, STUDENT_ID, DISCUSSION_DATE, DISCUSSION

5.

Exam

EXAM_ID

EXAM_ID, SEMESTER, SUBJECT, DATE, TIME, DURATION

6.

Library

BOOK_ID

BOOK_ID, BOOK_NAME, AUTHOR, PUBLICATION, SUBJECT, STATUS, STUDENT_ID, RESERVE

7.

Marks

MARKS_ID

MARKS_ID, SEMESTER, SUBJECT, STUDENT_ID, MARKS, RELEASE_DATE,

8.

News

NEWS_ID

NEWS_ID, DATE, TIME, NEWS, DETAILS,

9.

Poll_detail

QUESTION_ID

QUESTION_ID, QUESTION, START_TIME, START_DATE, END_TIME, END_DATE

10.

Poll

POLL_ID

POLL_ID, QUESTION_ID , OPTION1, OPTION2, OPTION3, OPTION4

11.

Student

STUDENT_ID

STUDENT_ID, NAME, SEMESTER, PASSWORD,

12.

Teacher

TEACHER_ID

TEACHER_ID, NAME, PASSWORD

2ndNF

In the Second Normal form all the functional dependencies is removed. In Second Normal Form every non key attribute is fully functionally dependent on the primary key i.e., every non primary key attribute needs the primary key to be uniquely identified.

Developer identified functional dependency in table “Library” and “Poll”. For removing functional dependency designer has break table “Library” in two parts one is “Library” and “Book-reserved”. The same concept is applied with “Poll” table and it has been break into two parts “Poll”, and “Poll_option”.

Sr. No.

Table Name

Primary Key

Field Name

1.

Attendance

ATTENDANCE_ID

ATTENDANCE_ID, DATE, SUBJECT, STUDENT_ID, STATUS, TEACHER_ID

2.

Class-timetable

TIMETABLE_ID

TIMETABLE_ID, SEMESTER, BRANCH, SECTION, DAY, SUBJECT, TYPE, LECTURE_ ROOM, START_TIME, END_TIME, TEACHER_ID

3.

Consultation

CONSULTATION_ID

CONSULTATION_ID, STUDENT_ID, TEACHER_ID, TIME, REQUEST_DATE, ISACCEPTED, ACCEPTED_DATE,

4.

Discussion

DISCUSSION_ID

DISCUSSION_ID, TOPIC, STUDENT_ID, DISCUSSION_DATE, DISCUSSION

5.

Exam

EXAM_ID

EXAM_ID, SEMESTER, SUBJECT, DATE, TIME, DURATION

6.

Library

BOOK_ID

BOOK_ID, BOOK_NAME, AUTHOR, PUBLICATION, SUBJECT, STATUS, STUDENT_ID

7.

Book-reserved

RESERVE_ID

BOOK_ID, STUDENT_ID, DATE

8.

Marks

MARKS_ID

MARKS_ID, SEMESTER, SUBJECT, STUDENT_ID, MARKS, RELEASE_DATE,

9.

News

NEWS_ID

NEWS_ID, DATE, TIME, NEWS, DETAILS,

10.

Poll_detail

QUESTION_ID

QUESTION_ID, QUESTION, START_TIME, START_DATE, END_TIME, END_DATE

11.

Poll

POLL_ID

POLL_ID, STUDENT_ID, QUESTION_ID, OPTION_ID

12.

Poll_option

PTION_ID

PTION_ID , POLL_ID, POLL_ID , OPTION

13.

Student

STUDENT_ID

STUDENT_ID, NAME, SEMESTER, PASSWORD,

14.

Teacher

TEACHER_ID

TEACHER_ID, NAME, PASSWORD

3rdNF

In Third Normal Form there is no transitive functional dependency between non key attributes.

Developer has found transitive dependency was present in “Discussion” table and “Library”. For removing transitive dependency between non-key attributes designer has changed some part of the table which is shown below:

Sr. No.

Table Name

Primary Key

Field Name

1.

Attendance

ATTENDANCE_ID

ATTENDANCE_ID, DATE, SUBJECT, STUDENT_ID, STATUS, TEACHER_ID

2.

Class-timetable

TIMETABLE_ID

TIMETABLE_ID, SEMESTER, BRANCH, SECTION, DAY, SUBJECT, TYPE, LECTURE_ ROOM, START_TIME, END_TIME, TEACHER_ID

3.

Consultation

CONSULTATION_ID

CONSULTATION_ID, STUDENT_ID, TEACHER_ID, TIME, REQUEST_DATE, ISACCEPTED, ACCEPTED_DATE,

4.

Discussion

DISCUSSION_ID

DISCUSSION_ID, TOPIC_ID, STUDENT_ID, DISCUSSION_DATE, DISCUSSION

5.

Discussion_topic

TOPIC_ID

TOPIC_ID, TOPIC

6.

Exam

EXAM_ID

EXAM_ID, SEMESTER, SUBJECT, DATE, TIME, DURATION

7.

Library

BOOK_ID

BOOK_ID, BOOK_NAME, AUTHOR, PUBLICATION, SUBJECT, STATUS

8.

Book-reserved

RESERVE_ID

BOOK_ID, STUDENT_ID, DATE

9.

Book-issued

ISSUE_ID

ISSUE_ID, BOOK_ID, STUDENT_ID, DATE

10.

Marks

MARKS_ID

MARKS_ID, SEMESTER, SUBJECT, STUDENT_ID, MARKS, RELEASE_DATE,

11.

News

NEWS_ID

NEWS_ID, DATE, TIME, NEWS, DETAILS,

12.

Poll_detail

QUESTION_ID

QUESTION_ID, QUESTION, START_TIME, START_DATE, END_TIME, END_DATE

13.

Poll

POLL_ID

POLL_ID, STUDENT_ID, QUESTION_ID, OPTION_ID

14.

Poll_option

PTION_ID

PTION_ID , POLL_ID, POLL_ID , OPTION

15.

Student

STUDENT_ID

STUDENT_ID, NAME, SEMESTER, PASSWORD,

16.

Teacher

TEACHER_ID

TEACHER_ID, NAME, PASSWORD

5.2.2 Entity Relationship diagrams

5.2.3 Database diagrams

5.2.4 Data dictionary

Table Name: Attendance

Field name

Data type

Description

ATTENDANCE_ID

BIGINT(20)

Primary key to identify different attendance

DATE

ARCHAR(11)

Store date on which attendance is marked

SUBJECT

ARCHAR(20)

Store subject of which attendance is marked

STUDENT_ID

BIGINT(20)

Store student whose attendance is marked

STATUS

ARCHAR(10)

Store present of absent

TEACHER_ID

INT(5)

Store teacher id who marked attendance

Table Name: Book-issued

Field name

Data type

Description

ISSUE_ID

BIGINT(20)

Primary key to identify different issues of book

BOOK_ID

BIGINT(20)

Store the book id to be issued

STUDENT_ID

BIGINT(20)

Store student id on whose account book will be issued

DATE

ARCHAR(11)

Stores date on which book is issued

Table Name: Book-reserved

Field name

Data type

Description

RESERVE_ID

BIGINT(20)

Primary key to identify different reserved book

BOOK_ID

BIGINT(20)

Store the book id to be reserved

STUDENT_ID

BIGINT(20)

Store student id on whose account book will be reserved

DATE

ARCHAR(11)

Stores date on which book is reserved

Table Name: Class-timetable

Field name

Data type

Description

TIMETABLE_ID

BIGINT(20)

Primary key to identify different classes

SEMESTER

INT(2)

Store semester for class time table

BRANCH

ARCHAR(15)

Store branch for class time table

SECTION

ARCHAR(2)

Store branch for class time table

DAY

ARCHAR(10)

Store day for class time table

SUBJECT

ARCHAR(20)

Store subject for class time table

TYPE

ARCHAR(10)

Store type for class time table

LECTURE_ROOM

ARCHAR(10)

Store lecture room for class time table

START_TIME

ARCHAR(8)

Store start time for class time table

END_TIME

ARCHAR(8)

Store end time for class time table

TEACHER_ID

INT(5)

Store teacher id for class time table

Table Name: Consultation

Field name

Data type

Description

CONSULTATION_ID

BIGINT(20)

Primary key to identify different consultation

STUDENT_ID

BIGINT(20)

Store student id for consultation

TEACHER_ID

INT(5)

Store teacher id who will provide consultation

TIME

ARCHAR(8)

Store time for consultation

REQUEST_DATE

ARCHAR(11)

Store request date for consultation

ISACCEPTED

CHAR(3)

Store consultation is accepted or not

ACCEPTED_DATE

ARCHAR(8)

Store accepted date for consultation

Table Name: Discussion

Field name

Data type

Description

DISCUSSION_ID

BIGINT(20)

Primary key to identify different comments for any

TOPIC_ID

BIGINT(20)

Store id of the question on which student comments.

STUDENT_ID

BIGINT(20)

Store student id who posted the comments

DISCUSSION_DATE

ARCHAR(8)

Store date on which comment was posted

DISCUSSION

ARCHAR(250)

Store comments provided by student

Table Name: Discussion_topic

Field name

Data type

Description

TOPIC_ID

BIGINT(20)

Primary key to identify different question

TOPIC

ARCHAR(50)

Store question on which discussion will be done

Table Name: Exam

Field name

Data type

Description

EXAM_ID

BIGINT(20)

Primary key to identify different exam

SEMESTER

INT(2)

Store semester who will face exam

SUBJECT

ARCHAR(20)

Store subject of the exam

DATE

ARCHAR(11)

Store date on which exam will be conducted

TIME

ARCHAR(8)

Store time on which exam will be conducted

DURATION

INT(1)

Store duration of the exam

Table Name: Library

Field name

Data type

Description

BOOK_ID

BIGINT(20)

Primary key to identify different book

BOOK_NAME

ARCHAR(25)

Store name of the book

AUTHOR

ARCHAR(25)

Store author of the book

PUBLICATION

ARCHAR(25)

Store publication of the book

SUBJECT

ARCHAR(20)

Store subject to which book belongs

STATUS

ARCHAR(10)

Store status of the book(issued, reserved or free)

Table Name: Marks

Field name

Data type

Description

MARKS_ID

BIGINT(20)

Primary Key

SEMESTER

INT(2)

Store semester for which the marks has been allotted

SUBJECT

(20)

Store subject for which the marks has been allotted

STUDENT_ID

BIGINT(20)

Store student id to whom marks has been allotted

MARKS

INT(3)

Store marks allotted

RELEASE_DATE

ARCHAR(11)

Store release date after which student can view the marks.

Table Name: News

Field name

Data type

Description

NEWS_ID

BIGINT(20)

DATE

ARCHAR(11)

TIME

ARCHAR(8)

NEWS

ARCHAR(30)

DETAILS

ARCHAR(300)

Table Name: Poll_detail

Field name

Data type

Description

QUESTION_ID

BIGINT(20)

QUESTION

ARCHAR(70)

START_TIME

ARCHAR(8)

START_DATE

ARCHAR(11)

END_TIME

ARCHAR(8)

END_DATE

ARCHAR(11)

Table Name: Poll_option

Field name

Data type

Description

PTION_ID

BIGINT(20)

POLL_ID

INT(3)

PTION

ARCHAR(30)

Table Name: Poll

Field name

Data type

Description

POLL_ID

BIGINT(20)

STUDENT_ID

INT(10)

QUESTION_ID

INT(3)

PTION_ID

INT(4)

Table Name: Student

Field name

Data type

Description

STUDENT_ID

BIGINT(20)

NAME

ARCHAR(30)

SEMESTER

INT(2)

PASSWORD

ARCHAR(15)

Table Name: Teacher

Field name

Data type

Description

TEACHER_ID

BIGINT(20)

NAME

ARCHAR(30)

PASSWORD

ARCHAR(15)

5.2.5 Class Diagram

5.2.5.1 Class diagram for mobile application made in J2ME

5.2.5.2 Class diagram for server side application made in J2EE

Class Diagram for Student Class

Class Diagram for Teacher

Class Diagram for Attendance class

PTL00783301Asia Pacific Institute of Information Technology Page | 99

Smart Consultation Scheduler & Mobile Messaging System

5.2.6 Sequence Diagram

Sequence diagram for consultation module

Sequence diagram for attendance module

Sequence diagram for search, reserve issue book

Sequence diagram for class time table module

Sequence diagram for result module

5.2.2 Activity Diagram

Activity Diagram for complete system

Activity diagram for Login

Activity diagram for Library

Activity diagram for Consultation

Chapter 6

Implementation

“A good idea is about ten percent and implementation is 90 percent.”

- Guy Kawasaki

6.1 Modules Implemented

6.2 Pseudo code

6.1 Modules Implemented

Smart Consultation Scheduler & Mobile Messaging System is a mobile application however uses web application to communicate with the server. The mobile application provides the interface to the user and the web application is solely responsible for the communication between the database server and the mobile application. This architecture enhance the system preference as only data need to be communicated not the interface. This will also provide better visibility to the system as interface is designed dedicatedly for the mobile phones.

Module list of complete system is cited below:

  • Consultation

§ Request for consultation

§ Approve consultation

§ Cancel consultation

§ View consultation

  • Attendance

§ View attendance summery

§ Get attendance alerts

  • Library

§ Reserve book

§ Check library fine

§ Check library lone

§ Download book

  • Exam

§ View exam result

§ View exam date

  • Class time table

§ Check class time table

  • News

§ Send news alert

§ Get news alert

  • Poll

§ Vote for eligible candidate

  • Discussion Forum

§ View discussion

§ Post opinion

  • Aptitude Test & technical test

§ Post test

§ Take exam

6.2 Pseudo code

Pseudo code of some of the complex module mentioned below

Request for consultation

Read STUDENT_ID from session

Read TEACHER_ID

REQUEST_DATE= today’s date

ISACCEPTED=”NO”

ACCEPTED_DATE= today’s date

TIME= current time

alidate Entries

IF input is valued THEN

Generate CONSULTATION_ID

Flag=0

WHILE Flag=0

Flag=1

IF ACCEPTED_DATE.DAY =”Saturday” or “Sunday” THEN

ACCEPTED_DATE= ACCEPTED_DATE + 1 DAY

ELSE

IF TIME ≥ 10 AND ≤ 17 THEN

READ FROM TABLE CLASS-TIMETABLE WHERE CLASS-TIMETABLE.TEACHER_ID= TEACHER_ID

IF CLASS-TIMETABLE. DAY= ACCEPTED_DATE.DAY AND CLASS-TIMETABLE.START_TIME ≥ TIME AND CLASS-TIMETABLE.START_TIME ≤ TIME THEN

TIME=TIME + 5 Minutes

Flag=0

ENDIF

ELSE

ACCEPTED_DATE= ACCEPTED_DATE + 1 DAY

TIME=9

Smart consultation scheduler & mobile messaging system Flag=0

ENDIF

ENDIF

IF Flag=1 THEN

STORE CONSULTATION_ID, STUDENT_ID, TEACHER_ID, TIME, REQUEST_DATE, ISACCEPTED, ACCEPTED_DATE IN CONSULTATION TABLE

ENDIF

ENDWHILE

ELSE

SHOW Message “Invalid input”

ENDIF

Approve consultation

Read TEACHER_ID from session

READ FROM TABLE CONSULTATION WHERE CONSULTATION.TEACHER_ID = TEACHER_ID AND ISACCEPTED=”NO”

SHOW CONSULTATION

IF Time is changed THEN

TIME=NEW_TIME

ENDIF

IF Teacher accept Consultation THEN

ISACCEPTED=”YES”

UPDATE CONSULTATION

SEND Message to Student

ELSE

DELETE CONSULTATION

SEND Message to Student

ENDIF

View attendance summery

Read STUDENT_ID from session

Read SUBJECT

Present=0

Absent=0

Absent_With_Reasion=0

READ FROM TABLE ATTENDANCE WHERE ATTENDANCE. STUDENT_ID = STUDENT_ID AND ATTENDANCE. SUBJECT = SUBJECT

WHILE READ

IF STATUS=” Present” THEN

Present= Present + 1

ELSEIF STATUS=” Absent”

Absent= Absent + 1

ELSE

Absent_With_Reasion= Absent_With_Reasion + 1

ENDIF

ENDWHILE

Total= Present + Absent + Absent_With_Reasion

SHOW “Total classes” + Total

SHOW “Total present” + Present

SHOW “Present %” + (Present*100/Total)

SHOW “Total absent” + Absent

SHOW “Absent” + (Absent*100/Total)

User Manual

Step 1: Open the application in your phone.

(Note:

Step 2: Login screen will be displayed as shown in Fig.6.1.

Fig. 6.1 | Login screen

Step 3: Enter user ID and password click on menu and select submit as shown in Fig.6.2

Fig. 6.2 | Select submit

Step 4: Menu list will be displayed select the function you want to perform. And press Select. (Fig. 6.3)

Fig. 6.3 | Menu Screen

Step 5: Select news to view News. A list of news will be displayed. Select the news to view news (Fig. 6.4)

Step 6: Select news to view News. A list of news will be displayed. Select the news to view news (Fig. 6.4)

Fig. 6.4 | News List

Step 7: Read news. Select Back to move back to News list screen (Fig. 6.5)

Fig. 6.5| News detail

Step 8: Repeat similar steps for other functionality. To logout from the application move to the menu list screen and press logout.

Hope you will enjoy the application.

ImplementationManual

Installation of application includes few easy very steps which need to carry out:

Step 1: There are three type applications depending on type of user:

Student application: Only for student

Teacher application: Only for teachers

Administrator application: Only for administrator (management)

Step 2: Download the application (.jad file) depending on the type of user form the hot space through bluetooth.

Step 3: Save it to your phone memory or memory card.

Step 4: Now browse it in your mobile and run it. It will take few minutes to get installed. Just wait and after installation the application will start running.

Step 5: From next time run it just by opening it.

Chapter 7

Testing

“If we fail, we fall. If we succeed - then we will face the next task.”

- Gandalf

After completing the implementation phase, the developer has reached to the testing phase. Deferent type of testing will be preformed to insure the quality output of the system and better satisfaction of customer.

Black Box Testing: Test Cases

Module: Log In

Project Name:

Smart Consultation Scheduler & Mobile Messaging System

Test Case Name:

Log In

Test Case Number:

SCSMS – 1

Written by:

Kundan Bharadwaj

Approved by:

Project Developer

Description:

This module is responsible for proper authentication of user and redirecting the authorized user to home screen.

Scenario

#

Function to Test

Expected Results

Actual Result

Remark

1

alidation on Various Textboxes

If incorrect input format then color of textboxes will change to red

Color of textboxes changed

Pass

2

Wrong User Id or password

Gives an message showing invalid username or password

Message shown

Pass

3

Correct User Id or password

User will be redirected to home screen

User redirected

Pass

Module: Request for consultation

Project Name:

Smart Consultation Scheduler & Mobile Messaging System

Test Case Name:

Request for consultation

Test Case Number:

SCSMS – 2

Written by:

Kundan Bharadwaj

Approved by:

Project Developer

Description:

This module is responsible for storing the consultation request in the database.

Scenario

#

Function to Test

Expected Results

Actual Result

Remark

1

alidation on Various Textboxes

If incorrect input format then color of textboxes will change to red

Color of textboxes changed

Pass

2

Assigning suggested time

At the suggested time there should not be any class of the teacher

Suggested time and class time do not clash

Pass

Module: View attendance summary

Project Name:

Smart Consultation Scheduler & Mobile Messaging System

Test Case Name:

iew attendance summary

Test Case Number:

SCSMS – 3

Written by:

Kundan Bharadwaj

Approved by:

Project Developer

Description:

This module is responsible for showing total number of absent and present.

Scenario

#

Function to Test

Expected Results

Actual Result

Remark

1

alidation on Various Textboxes

If incorrect input format then color of textboxes will change to red

Color of textboxes changed

Pass

2

Total number of class, absent, present and absent with reason

Total number of class should be equal to sum of number of present, number of absent and absent with reason

Sum of present, absent and absent with reason do not matches with total number of class.

Fail

Changes Made:

Difference in sum of present, absent and absent with reason do not matches with total number of class led to the failure. The error occurred due to invalid enter in the database. It was resolved by updating the database value.

Earlier value in database: “P”

Updated value: ”Present”

Module: View attendance summary

Project Name:

Smart Consultation Scheduler & Mobile Messaging System

Test Case Name:

iew attendance summary

Test Case Number:

SCSMS – 4

Written by:

Kundan Bharadwaj

Approved by:

Project Developer

Description:

This module is responsible for showing total number of absent and present.

Scenario

#

Function to Test

Expected Results

Actual Result

Remark

1

Total number of class, absent, present and absent with reason

Total number of class should be equal to sum of number of present, number of absent and absent with reason

Sum of present, absent and absent with reason is equal to total number of class.

Pass

Chapter 8

Critical Evaluation

“When we evaluate or criticize another person, it says nothing about that person; it merely says something about our own need to becritical.”

− Unattributed

This part of documentation covers how useful system is for targeted users which are faculty, students and administrator. It covers system being developed is according to the user requirements. If system is fulfilling user requirement then it is a successful project. This system i.e. - Smart Consultation Scheduler and Mobile Messaging System is a project which being developed in order to provide solution to lots of problem faced by the college. It will improve the information process of the college. It IS beneficial in many ways for the users using this system.

The first and the foremost advantage of the proposed system is that it reduces the communication gap between students, teachers and management. To fix a consultation we do not need to go to the teacher and roam here and there to searching teacher if teacher is not present in his/her office. This could be done just by pressing few buttons on the mobile. Important information could be delivered to the concerned people at time so that no ambiguity can arise. It will make the work smoother were work could be done just by pressing few buttons. So the system would reduce so much of stress from their head.It will make things lot simpler and reduce human effort. Anyone who wants to use the system can use it easily on his/her mobile, as the system is dedicatedly made for the mobile. As there will not be any communication gap so productivity will automatically increase. It will provide security to the user. If we log on to the present used system (which is a web based application) through other’s computer or laptop, our account may get hacked as there may be password catcher installed in it. It will save wastage of money, as student does not need to move to cyber cafe to use the system. SCSMS will reduce the wastage of time in searching cyber café. It will increase the knowledge of the student. The discussion forum will help to increase the knowledge of the student. It will make the student comfortable in technical round of the placement process. The student can take test of technical round to practice through the proposed system. It will remove the biased process in any polling. As through the proposed system will do it automatically.

Chapter 9

Conclusion

Today is the world where mobile devices are the important part and most adaptable electronic devices as they make us connected to each other with our colleagues, friends, dear ones when we are away from them or when we are travelling to other part of the world. The main feature of mobile devices is to get us connected to each other. This advantage of mobile devices are briefly used in the development of educational institution such as colleges and school to carry out the communication gap between faculties, students and management. Each and every person in this world wants to perform the task at their fingertips. Burden has been minimized by the mobile devices. Mobile devices provide us internet connectivity anytime anywhere. There is no doubt that mobile devices make the people life convenient and happening.

The system solved the problem it was suppose to:

After the completion of the system it is checked that system is solving the problem and fulfilling all the specification. As the system of college is that we have to go to teacher for contact, now this system solves this problem and can contact to teacher directly. As if we want to use the college system we have to use it in the college campus but this developed project solves this problem we can use this system from all over the world. Students can fix consultation by using mobile devices with teachers.

The limitations and errors in the developed system:

As this system which can’t run without GPRS. Maximum features which hare deployed are limited for the teachers, maximum facilities of this system is for the students. As there is limitation of this system is that, there is no option for holiday check list means consultation can be fixed on holiday.

Possible Future Enhancement:

As the future enhancement holiday consultation problem will be solved there will be no consultation on holidays and more facilities will be provided to teacher in order to increase their scope in the system.

what would you have done differently if you were given the time to redo the project

If there will be time to redo the project there will be more functionality to the teachers. Problem of fixing consultation on holidays will be solved..

The main computational challenge in your system

As mobile application has limited space so there will be less memory but computation part is of high level and tough to eradicate this problem interaction with web based system has been done.

The learning experience gathered

  • After the completion of the system got knowledge of J2EE and J2ME
  • Used the various new software such as Microsoft project, visio etc
  • After the successful completion of this project gained the experience of how to industry based project.

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.