Online Examination Using Farming Based System

1
Online Examination Using Farming Based System

• Ajay Anand(d0267003)
• Kapil More(d0267007)
• Sri Ram(d0267027)
• Yogesh Patrikar(d0267022)

2
Online Examination Using Farming Based System

• Load Balancing
• Corba Architecture
• Platform Independent
• N-tier Architecture
• Analysis and Design
• Database Connectivity
• GUI and Web Server

3
Load Balancing

• The core idea of this project is Load Balancing.
• Load Balancing is done by the Scheduler
• Scheduler Receives the request from the client
  and on the basis of priority/time
  requirement,loads on the servers ,forwards the
  requests to the appropriate server.
• There are lots of servers behind the Scheduler to
  handle the requests.

4
Common Object Request Broker

• Common Object Request Broker Architecture is a
  standard architecture for distributed object
  systems.
• It allows distributed heterogeneous collection of
  objects to interoperate by providing a set of
  standard interfaces.

5
Platform Independent

• This project is Platform Independent.
• Client and Server can reside anywhere in the word
  on any platform.
• Client makes call without knowing where the
  server is .
• Handle Transparency.

6
N-tiers Architecture
Scheduler
7
N-tiers Architecture

• It is an N-Tiers Architecture.
• The Sequence is
• Client-Web Server-Scheduler-Cluster
  Server-Database-.

8
Architecture
APP1
Tomcat
Web Client
APP2
Scheduler
MySQL
APP3
APP4
9
Detail Architecture
Registration, Authentication, .
Registration1, Registration2, Registration3,
.
NS 2000
NS 1000
APS1
Tomcat
Web Client
APS2
Scheduler
MySQL
APS3
Proxy Design Pattern
APS4
10
Scheduler Mechanism.

• function_impl
• give(info)
• waitforlock()
• getlock()
• ..
• client code follows

Function call
Server ID
Scheduler
11
Analysis and Design

• UML(Unified Modeling Language)
• Standard for describing designs
• Visual a set of diagrams
• Use Case Diagrams
• Sequence Diagrams
• Collaboration Diagrams
• IDL

12
Use Case
13
Sequence DiagramSystemAdmin-Config
14
Collaboration DiagramSystemAdmin-Config
15
Sequence DiagramStudent-Examination
16
Collaboration DiagramStudent-Examination
17
Sequence DiagramStudent-ViewResult
18
Collaboration DiagramStudent-ViewResult
19
Sequence DiagramHRAdmin-Login
20
Collaboration DiagramHRAdmin-Login
21
Sequence DiagramStudent-Login
22
Collaboration DiagramStudent-Login
23
Sequence DiagramHRAdmin-PaperCreation
24
Collaboration Diagram HRAdmin-PaperCreation
25
Sequence DiagramStudent-Registration
26
Collaboration DiagramStudent-Registration
27
Sequence DiagramHRAdmin-Report
28
Collaboration DiagramHRAdmin-Report
29
Sequence Diagram SystemAdmin-User-Report
30
Collaboration Diagram SystemAdmin-User-Report
31
Sequence Diagram SystemAdmin-Login
32
Collaboration Diagram SystemAdmin-Login
33
Sequence DiagramSystemUser-Login
34
Collaboration DiagramSystemUser-Login
35
IDL File
//IDL file for corba based client-server online
testing application module Farming_based_system
interface Question attribute unsigned short
current_question_paper typedef sequence
ltstringgt question_paper
//list of questions that are in one
paper typedef sequenceltunsigned longgt
question_no_array
//list of questions previously answered by the
candidate exception QNFException string
reason exception ONSException
string reason exception CFException
string reason //get a question from
the curren question paper such that it is not
previously asked to the candidate void
get_unique_question(in question_no_array
prev_questions_nos , out string question)
raises (QNFException)
36
IDL Continued.

• //verify the answer given by candiate.
• void check_ans(in unsigned long question_no,in
  unsigned long ans_option, out boolean is_correct)
• raises (ONSException)
• //add to new question paper to the database
• void add_question_set(in question_paper
  question_update)
• raises (CFException)
• //change the question paper for coming exam
• void change_current_question_set(in unsigned
  long ques_set_no)
• raises (CFException)

37
IDL Continued

• interface Authentication
• struct Login_detail
• string user_name
• string password
• exception InvalidLoginLException
• void validate_user(in Login_detail details ,
  out boolean validated)
• raises (InvalidLoginException)

38
IDL Continued

• interface Registration
• struct Regist_details
• string name
• string password
• string address
• string sex
• unsigned long phone_no
• string email_id
• exception IDException
• string reason
• //register user for test
• void register(in Regist_details details)
• raises (IDException)

39
IDL Continued.

• //get marks of particular student
• void get_student_mark(in string stud_ID,out
  unsigned long marks)
• raises (reportException)
• //get marks of all students
• void get_marks_report( stud_IDs student_ID,out
  marks student_marks)
• raises (reportException)

40
IDL Continued

• interface report_manager
• struct pass_stud_report
• unsigned long total_registered_stu
• unsigned long total_appeared_stu
• unsigned long total_passed_stu
• struct fail_stud_report
• unsigned long total_registered_stu
• unsigned long total_appeared_stu
• unsigned long total_failed_stu
• typedef sequenceltstringgt stud_IDs//list of
  student ids
• typedef sequence ltunsigned long gtmarks//list
  of marks
• exception reportException
• string reason

41
Database Connectivity

• JDBC
• Mysql

42
Database

• Database onlineexam
• Tables
• ---------------------------
• Tables_in_onlineexam
• ---------------------------
• examresult
• examstats
• questionset
• user
• ---------------------------

43
Schema

• examresult
• ---------------------------------------------
  --------
• Field Type Null Key
  Default Extra
• ---------------------------------------------
  --------
• emailid varchar(100) YES NULL
  
• marks int(11) YES
  NULL
• status char(1) YES
  NULL
• --------------------------------------------
  --------

44
Schema

• examstats
• --------------------------------------------
  ------
• Field Type Null Key
  Default Extra
• --------------------------------------------
  ------
• month int(11) YES NULL
  
• year int(11) YES NULL
  
• t_registered int(11) YES NULL
  
• t_appeared int(11) YES NULL
  
• t_passed int(11) YES NULL
  
• t_failed int(11) YES NULL
  
• --------------------------------------------
  ------

45
Schema

• questionset
• ---------------------------------------------
  ---------
• Field Type Null
  Key Default Extra
• ---------------------------------------------
  ---------
• question_no int(11) PRI
  0
• question varchar(255) YES
  NULL
• opt1 varchar(100) YES
  NULL
• opt2 varchar(100) YES
  NULL
• opt3 varchar(100) YES
  NULL
• opt4 varchar(100) YES
  NULL
• ans int(11) YES
  NULL
• section varchar(25) YES
  NULL
• ---------------------------------------------
  ---------

46
Schema

• user
• --------------------------------------------
  -------
• Field Type Null Key
  Default Extra
• --------------------------------------------
  -------
• emailid varchar(100) PRI
  
• name varchar(50) YES NULL
  
• password varchar(10) YES NULL
  
• address varchar(200) YES NULL
  
• sex char(1) YES
  NULL
• phoneno varchar(10) YES NULL
  
• dob date YES
  NULL
• --------------------------------------------
  -------

47
GUI and Web Server

• HTML
• JSP
• Servlets
• Web Server -Tomcat(linux)

48
Beginning of the end

• Thank you.