Flex Based Business Catalyst .Net Project

Project Scope

Flex Based Business Catalyst is a venue where services in relation to the completion of projects or the performance of tasks (Services) may be bought and sold. Flex Based Business Catalyst allows companies and/or individuals who require Services (Service Buyers) to advertise their requirements and companies or individuals who provide Services (Providers, Professionals) to offer their Services using a competitive bidding process. When a Buyer advertises a project in the website, the Buyer shall specify a closing time and date (Closing Date) by which time all offers to provide such Services (Bids) must have been submitted by Providers. Within five (5) business days of the Closing Date the Buyer shall select a Bid at the Buyer’s sole discretion. Flex Based Business Catalyst will automatically be notified of the selection via the Website. Upon notification of a successful Bid, the Buyer will be automatically notified of the Provider’s contact details and the Provider of the Buyer’s contact details via the Website.

Product Perspective

As a freelance provider, you can search or browse for projects by category, keyword, locations and many other criteria. Using the keyword search facility to find jobs with specific qualifications, you can then use the search filter to narrow your search results by location, distance, feedback and ratings etc.
More IT Service Providers, Experienced Freelancers, College and University Students are taking advantage of Flex Based Business Catalyst to Find More Work, Manage Projects Online and Get Paid Securely.

Product Features
Flexibility
– Companies can quickly staff up when needed, and scale down when demand is low
– Increase growth by tapping into the  Flex Based Business Catalyst pool of fully rated professionals
– Gain access to a wider skills set locally & internationally
Cost effective
– Open and transparent bidding system ensures quality and competitive quotes are received from skilled professionals around the world
– The use of remote labor ensures less overheads, less office space and no cost or liability in firing staff
– Cheaper when compared to traditional forms of hiring staff e.g. agency or recruiter fees

Control
– Release payment only when requirements are met and results are delivered.
– Stored communications and ability to leave public feedback inspires great performance.

User Classes and Characteristics
As it is website for freelancing the registered user plays an important role because, he is the one who can find more professionals to work on projects and also can post a new project details and can also bid for a particular project.

Software requirements:
o    Microsoft .Net framework
o    Flex Builder
o    Microsoft C#.Net language
o    Microsoft SQL Server

Class Diagram
Class Diagram
Sequence Diagram
Sequence Diagram
Usecase Diagram
Usecase Diagram

Freelancers:
Freelancer who wants to access the website needs to register by giving his personal and professional details. Then user will be given unique user id and password. Login into website by giving the credentials. User can search for professionals and projects. Can view selected professional profile in detail. Can send message to individual professional.

Projects:
Registered user can view the projects and can bid for that project. Can post new project details. If the bid is selected then user will be intimated through website.

Billing:
User will have to deposit funds in the website’s account before bid approval. And user can view account details like funds in account, funds released etc., Can view the account report between selected dates.

Flex Based Web Ms Sql Explorer .Net Project

Scope of the Project:

This Flex Based Web Ms Sql Explorer application web database explorer aims to increase the scope of database administration by building the remote administration tool to interact with sql server located over the web. The main scope of the project is to build a website that gives access to the Microsoft sql server over a web. So that, the user can perform all type of operations such as creating the tables, retrieving and updating the database tables, deleting the rows and modifying the tables etc.

Brief Description of the Project:

Administrators are typically among the people most highly trained in solving the database issues at a side , the improvements in normal sql explorer allows valuable resource to spend more time working on database design and application data access issues.

The scope of database administration of such complex task is still limited to the desktop over a LAN network where the server is installed in a single system, which acts as a server, and the other systems as client work under the client environment to interact with the sql server.

The client systems which are connected to server over a LAN network can access the Microsoft sql server and database tables by using the username and password provided by the administrator, which is already exists. But now, we are developing a web application which access to Microsoft sql server over a web. The user can access this web application from anywhere from any remote location whatsoever at the same time maintaining the security aspects.

In order to overcome the problem of installing the Microsoft SQL software in every user system and to reduce the repetitive work of the database administrator, our project provides a Web address to access the Microsoft SQL server by all the web users. And we provide a username and password to the user to access the server with security over the web.

Features of this project are:

  • Reduces the repetitive work performed by the database administrators.
  • Improves the normal SQL explorer.
  • Maintains security for SQL server similar to enterprise manager.
  • No need of installation of the SQL software in every user system.
  • Reduces the time for access.
  • Enhances security.
  • Can be extended to other software making it a remote freeware.

Software Requirements:

  • Microsoft .Net framework.
  • Microsoft ASP.Net .
  • Microsoft C#.Net language.
  • Microsoft Visual Studio
  • Internet Information Services (IIS).
  • Flex Builder
  • Microsoft SQL Server
Class Diagram
Class Diagram
Sequence Diagram for Entered or Selected Text
Sequence Diagram for Entered or Selected Text
Use case Diagrams
Use case Diagrams

Modules Description of the Project

Databases Access Module:
In this module user can access the database by giving credentials like username, password and database name to which database he wants to connect. Once we connect to the database then we can able to manipulate tables, views and stored procedures. And we can execute the select commands with the query parser.
Object Browser: After validation user can view all the tables, views and stored procedures in the accessed database.

Tabbed Query Windows:  Application provides tabbed query windows to execute the commands with the query parser. User can open several query windows and execute the queries.  User can execute the queries like selecting, updating, altering stored procedures etc,.

Query Result Windows: After execution of a query result will be displayed in result window, any messages displayed in messages window and any history related to that query will be displayed in history window.

Syntax Highlighting: Syntax will be highlighted while writing query in query window.

Table Operations: User can insert new values into table and modify the table structure. Insert and modify user interfaces will be provided to user like we have it in enterprise manager.

Flex Based Web Ms Sql Explorer Home Page Flex Based Web Ms Sql Explorer Query Page Flex Based Web Ms Sql Explorer Query Page1 Flex Based Web Ms Sql Explorer Query Page2

FUTURE  ENHANCEMENT:

Presently this project works only for Sql Server database only, in future this project can be implemented for other databases also.
As a future enhancement we are planning to implement this project not only for database administrators but also for other users like employees in organization

Myoffers Advertising C#.Net Project

Myoffers is mainly an advertising web application. this is the application which is developed for having all the advertisements in one place where users or customers can see all the ad’s in one web application and come to know all about the products. In this application all the best offers present in the site are displayed to users.

In this site users can be of 3 types 1)user 2)Registered user 3)Advertiser.

User can just view the offers present in the site and can also view best offers and the offers which will dispose in short time.

Register users can have all the capabilities like user and in addition he is registered with the site and can even give rating to the offer and can search for the ad’s

Advertiser can login into the site and can place an add related to him. Advertiser as to register before he can login into the site.

Use Case Diagram for the Advertizer
Use Case Diagram for the Advertiser
Use Case Diagram for the registerd user
Use Case Diagram for the registered user

Introduction

Myoffers is mainly an advertising web application. this is the application which is developed for having all the advertisements in one place where users or customers can see all the ad’s in one web application and come to know all about the products. In this application all the best offers present in the site are displayed to users.

Purpose

  • The purpose of the project is to develop a web application which can make customers view all the offers under one site and can make users know where he can get the best offer for the product he wants and help other customers by giving rating to the best offers present in the city.

  In this website helps customers or user by getting all types of products by different outlets under one roof. This site shows the best offers present in the site and the offers which are about to dispose are also displayed.

Scope

This system only shows which offer is running in which shop(advertiser) in city or who are registered with our site not all the offers present across the city. In this system user has to register with our site to give rating to a particular ad or offer. Normal user does not have all the facilities such as registered users.

Goals :

 The Goal of the project is to develop a web application which can make customers view all the offers under one site and can make users know where he can get the best offer for the product he wants and help other customers by giving rating to the best offers present in the city.

The customer can bookmark the best add so that when he log’s in he can get the best ad’s according to him

Features of our project (Advantages)

  • Customers can know the best offers in the city
  • Can know best offer of a particular product from different outlets so customer can choose which offer is best for him
  • Customer can rate the offers which may help the other customers

System Analysis

Existing System

                              Generally customers know about the offers of the product or a brand through different ways like seeing in newpapers , hoardings etc. There is no site which gives information about all the products and all the brands in a single site. Users or customers have to log in into particular brand website to know all about the products and it’s offers.                      

Proposed system:

In our website customer can check all the offers of all the products and all the brands posted by different advertisers at one place and can know the best offers present in the city. Can compare the offers of same brands with different advertiser’s and can choose the best. Customer or registered user can give rating to a particular ad if he likes it. Can also see the best offers posted by advertiser at one place. And the offers which are getting disposed soon can also be seen at one place

Functionalities:

  • User
  • Restaurant Manager
  • Advertiser
  • Super Admin

Overall description

In our website customer can check all the offers of all the products and all the brands posted by different advertisers at one place and can know the best offers present in the city. Can compare the offers of same brands with different advertiser’s and can choose the best. Customer or registered user can give rating to a particular ad if he likes it. Can also see the best offers posted by advertiser at one place. And the offers which are getting disposed soon can also be seen at one place

Super Admin:

Super Admin unique id’s to the advertisers of various Shopkeepers .After giving id’s to the advertisers, the advertisers can login With their username and password and can provide information regarding the Offers they were present in their shop with complete details regarding the product which includes the product name, product category, actual price, offer price, to date & from date.

After the advertiser provides the information regarding the product and before it is being published in the site it will be verified by the super admin and then it will be published. Super admin purpose is to validate the information and to provide only valid information to the users.

Advertiser:

Advertiser purpose is to publish the information

regarding the products in their shop with complete details. He advertises the original price and also the discount price for which the user can purchase it. He provides the information regarding each and every item on which he have provided offer so that the user can select their best choice. He advertises the period of time that the particular item will be under offer.

Restaurant Manager:

Restaurant Manager Will Add the All Restaurant Information by city Wise And Add the Amounts.

User :

Users are of two types registered users and normal users. Registered users first need to register in to the site; if they are already registered they can login in to the site with their username and password so that they view the best offers regarding the products that were present in the particular shop. Once they view the products and their details then they will have a clear idea about the product, so that the user can go to the particular shop and buy the product.

Normal users who are not registered ones can’t access all the information of the product; they can just view the products but complete details will not be provided.

CONCLUSION

Hence from this software the Employees will be able to login with their Respective Username and password then enter their Expenses with the respective receipts, and then send mail to the manager, Once manager received the mail from the Employees, then he will verify the Bill s claimed by the employees and he can approve or reject the bills, if he reject the bill he send a mail to that particular employee why he is rejecting that particular expenses. If he accepts that expense claimed by the employee then he send the details to the next level, in the next level can be the director or the chair person of the Organization. Once the head person accept the reimbursement, the he send the details to the account related department for credit that much amount to the particular person.

This way we have created very user friendly and effective software which is not only helpful to an employee but also to every other person in the company using dot net.

Organization Automation System .Net Project

Introduction: Now a Day’s most of the companies maintain all of their records on paper. However with growing business it is very hard to maintain all record. Because of this employees are missing lots of opportunities of this manual process. Also employees are spending lots of time on bench. To overcome this situation we’ve developed Organization Automation System.

Basically Organization Automation System is a web application that provides different training to their employees/students. For that they have different class rooms, also it have virtual class rooms to teach from long distance. Organization Automation System will manage all these things online. Also each employee may have multiple resume and other documents with their experience. For this purpose Organization Automation System provides Safe Source with different inbuilt version facility.
And it also maintain the record that classes how, when, who are going to conduct them. There may be some online classes for those who stay away from the consultancy. Now-a- days it’s very complicated to accommodate everyone at a place and take a class. The online classes make it simpler to the company to do that.

Organization Automation System also maintains the salary details of the employees and trainers of the company. The employee from the consultancy has different pay and trainers of different languages have different pay. And it also maintains the records of class timings based on trainee and subjects.

Intended Audience and Reading Suggestions:

This  SRS  is nothing but Short description of our Project. We have prepare this SRS(Introduction) to show to our HOD’s, Faculty, Pricipal & the College Management.

Project Scope:

The scope of this project is used only in  particular organization . It miantains
all the  information about the organization that can be accessed by the members of  organization
Overall Description:
product perspective
Existing system:

most of the organizations maintain all of their records on paper  so it may loss the paper . very hard to maintain all record on the paper it takes much time  . Because of this employees are missing lots of opportunities of this manual process. Also employees are spending lots of time on bench. To overcome this situation we’ve developed Organization Automation System.

Proposed system:

We proposed in this project was fully accessed in web so that all members  can
see  through username and password to each and every member in  an organization  must and
should have an userid and password to access the information about the organization. It  mainta
in the record that classes how, when, who are going to conduct them. There may be some online
classes for those who stay away from the consultancy. Now-a- days it’s very complicated to
accommodate everyone at a place and take a class.

product  features:

The admin can assign the class  timings  to an trainers at what time to what time,
subject  name and also class room  .the trainers can upload materials ,videos,assignments .the
employees can see timings , subject name and can download materials and videos .employee can
access through  internet any where

 user Class and Characteristics:

Admin : Admin has all the permissions to recruit the new employees as well as trainees. He has to prepare the time tables of different classes based on the subjects contained by the  trainee . he can also have the permissions to modify(update, delete) the records  of the employees as well as the trainees. He has all the rights to remove the particular trainee or employee from their current position. He has the  full control over the employees and trainees who are working in his organization. Employee: There is a user i.d and password of the particular organizational website which he has to login that was given by the administrator. After login into that website, he can choose his  favourite subject which he has to learn. He can also view the timings of his subject in that website. There the  options to the employee to learn his
favourite subject either directly or through online.Trainers: First of all he has to select his favourite subject to teach to the employees.  He is capable of delivery his subject physically or through online. Then the admin will select the timings to the particular trainee when he has to deliver his/her subject.

Operating Environment:  
Microsoft .Net framework 3.5, Microsoft Visual Studio 2008, Microsoft ASP.Net 3.5, Microsoft C#.Net language, Microsoft SQL Server 2005, ADO.NET, Intel Pentium 4 or more, 1 GB or more, 40 GB hard disk recommended for primary partition.

System Features

 Module 1
  Admin :
Admin has the privileges to Register a new Employees , Trainers etc. and he can assign the timings to the classes based on the trainers subjects. And he can view update and delete the records of       Employees and Trainers

Module 2
Employee :
Employee need to login to his Account by using username and password given by  Admin, Employee can select the subject that he want to learn and he can view the timings of the selected class, and he can learn the things by directly or by online based on selection

Module 3
Trainers:
Trainers has the capability to teach subjects by online / directly. First he can select
the subjects that he knows, based on Trainers selection admin can assign the timings

Module4
client
Client can register in this site by using all the necessary data like his company established date, address and mobile no, phone no etc. after he registered he has to login by using his user name and password   he can post for the new project to develop from the organization when he post for the new project admin has to check the bid details and he has to accept and will assign the project members to the particular project.

Software requirements:
•    Microsoft .Net framework 3.5
•    Microsoft Visual Studio 2008
•    Microsoft ASP.Net 3.5
•    Microsoft C#.Net language
•    Microsoft SQL Server 2005
•    ADO.NET
•    Microsoft C#.Net language
•    Microsoft SQL Server 2005
•    ADO.NET

Employee screens

Create Home Page As Below

Home Page

This is home page of employee. As soon as the employee opens the web link this page appears. Here the details of the Organization Automation System project will be present. The details such as the no. of clients present with the site. Here there is a option called login, from which employee can login to the employee details page.

Create Login Form as Below With 3 Roles ( Employee, Trainee, Admin)

Login Form as Below With 3 Roles

After the employee clicks on the login tab in the previous page, the login page is generated. The employee will enter the username and password to proceed further. The username name and the password should be correct. If either the password or username is not correct, the error message will be shown. There is also a option incase the employee forgot the password. There will be question through which the employee can remember the password.

Employee Role

Create Employee Home With Following Options

Create Employee Home With Following Options

As soon as the employee enters the username and password provided to him the welcome page appears. The welcome page specifies the welcome message along with name. There are various tabs present, for example:

  1. Home tab specifies the link to the home page where all details related to the website will be present.
  2. Update profile tab helps the employees to update their personnel which present with the organizers.
  3. Update resume tab helps the employees to update their resume, that particular page is displayed.
  4. View resume tab helps the employees to view the resume and make changes directly.
  5. Subject’s page shows how many types of subjects are present and which will be suitable to that particular employee.
  6. Learn tab suggests the various methods the site is providing for employees to learn either it can be in campus or online.
  7. Timings tab display the timing of classes along with the subject.
  8. Change password helps the employee change their password .
  9. logout

update profile page

The update profile page displays the data needed to be entered into the website which stores the data in the database. The various fields such as the first name, last name, username should be mentioned. Along with that the date of birth, age, and gender should be entered.

The employees along with entering the personal details they have to mention their salary details, their contact information and the phone number and email id.

The employee can edit these details also. Or cancel the entered information. After entering all the information and clicking on the update button the data is saved in the concerned database.

This page displays the options for the employee to upload their resume. They have to browse and just click on the upload tab where the resume will be stored in the database.

Create View Resumes Page. When Ever User Clicks the Link it Will Display all his uploaded Resumes as Follows

This page displays the uploaded resumes. The names of the uploaded resumes will be displayed. From this page there is no logout option.

The employee can select the desire resume and see the information present in the resume.

Create Subjects to learn Page As Follows

The above page display the subject details already selected. There is a table which shows the classes the particular employee has selected. There is another option wherein the employee can select other subjects from the dropdown list. And click on the add to list button. The employee can even cancel the page.

Create A Page Learn.aspx With Following Design

The page displays the information for the employee to download the material they want to study. The employee has to just select the required subject from the drop down list. The material name will be displayed in the tabular form along with subject name. the employee can select the required hyperlink material name and download it.

Create Timings Page With Following Design

When the employee selects the timing for the class, the data will be presented in the tabular form. The employee has to select the subject , after that the data will be shown the first name, class and class time will be shown.

Create A Change Password Page With Following Design And Write Code For ChangePassword Button

The Organization Automation System website provides the employees to change the password. For this employee has to enter the old password, later on the new password which they want to change and confirm the password and click on the change button the password is saved.

If the employee wants to retain the old password they can just click on the cancel button

Trainee Module screens

Create Trainer HomePage As Follows

This is the home page of trainee. The trainee can navigate to any page depending on their requirements.

Create Update Profile Page As Follows And Write Code for Edit And Update Buttons So That User Details Must Updated in Database

The trainee will enter their personal and professional details. The trainee will enter the name, data of birth, age, salary, address, and phone number and mail id. All this details will be stored in the data base. The trainee can edit the details they have entered by just clicking on the edit button and to update all the entered the details, the trainee have to click on the update button.

Create Subjects Known Page With Following Design

The trainee after entering all the details, the above page is displayed. The page shows a welcome message. Here the trainee can select the subject and add to the existing list. Side by side the table will show the subject selected list.

If the trainee does not want the selected subject, they can just cancel the data.

Create Assigned Subjects Page With Following Design And Write Code For Displaying Assigned Subjects to Him As Follows

The above page displays the trainee name, the subject they are going to teach and the class timings.

Create a Page name as Teach with following Design

The Organization Automation System project makes the work of the trainee easy. The trainees can select the subject from the dropdown list options and select the required file /video/material to teach. And later upload the details to the data base.

Admin Module screens

Create Admin Home Page As Follows

This is the home page for admin. The page displays the welcome message for admin and the companies’ information will be present. The admin is provided with various tabs such as:

  1. Home: the home page will be displayed.
  2. Register: the employee or trainee will register.
  3. Assign class timings: the admin will assign the class timings for employees online and the employees present in the office premises.
  4. Change password: the admin can also change the password of all the employees or trainee’s.
  5. Logout: the admin can logout from this page.

Registration

Employee Single Registration

Employee Bulk Registration

This page displays the format and fields required for the employee to register to this website. The employee has to enter their first name, the last name; the username through the employee will enter into the website. There is called check availability through employee will be able to clarify if already the name is existing or not. The employee has to enter the password and confirm it. The date of birth , age, gender, salary, address along with the phone number and email should be entered.

The employee specifically should language known and his role. The employee can have a security question and security answer which will help them retrieve their password easily. After this by clicking on the register tab the data is saved or stored in the respective database.

Trainee Registration

This page displays the format and fields required for the trainee to register to this website. The trainee has to enter their first name, the last name; the username through the trainee will be able to enter into the website. There is called check availability through trainee will be able to clarify if already the name is existing or not. The trainee has to enter the password and confirm it. The date of birth , age, gender, salary, address along with the phone number and email should be entered.

The trainee specifically should language known and his role. The trainee can have a security question and security answer which will help them retrieve their password easily. After this by clicking on the register tab the data is saved or stored in the respective database.

Admin here issues the class timings by selecting the subject. The data is present in the tabular format. The admin just has to select the trainee name and then assign the timings of the class. The table contains all the details of the name, subject and class timings.

Assign projects

Assigned Employees

View New Projects:

View Resumes

Learn

Send Project Info To client

View Messages

Change Password

Client Home:

View project details

Send request to project

View Status of Project

send message

Send Message Page

Conclusions and Future Scope of the Project

  • It is easy to use, since it uses the GUI provided in the user dialog.
  • User friendly screens are provided.
  • The usage of software increases the efficiency, decreases the effort.
  • It also provides the user with variable options in administering.
  • It has been thoroughly tested and implemented.

Multi Point and Multi Section Order Based Serving System in a Modern Restaurant

OVERVIEW OF THE PROJECT

In the present scenario the current process of serving the customers in a restaurant is by taking the orders manually which are selected from the menu card and further placing the order in the kitchen wherein the master chef makes the other cooks to prepare the items accordingly whenever the customer wishes to order for the new item then again the same procedure repeats, finally this whole process has certain problems like including lot of man power.
Evaluating this scenario we are trying to develop an application where the man power is reduced by implementing the touch screens wherein the order can be placed by just touching the required items/menu on the screen, the session continues until the customer wishes to pay the bill. There are three main modules in the system they are central administration system, user/table terminal and kitchen terminal.

ARCHITECTURE

Multipoint and multisection order based serving system is a 2 tier architecture where as the presentation and business logic will be in one layer and the database interaction will be in other layer. SQL Server2005 is used as backend storage and ASP.NET is used for presentation layer. C#.NET is used to write the entire application code.

TECHNOLOGIES USED

We have used Microsoft’s .NET Technologies: ASP.NET 2.0, C#.NET 2.0, AJAX Extensions (version for .NET 2008). For database, sql server2005 is taken as backend.

PURPOSE OF THE PROJECT

Our Modern Restaurant System is a software application which can be implemented by providing touch screen facility that puts your business at your fingertips and makes it easy, too. This software enables the customer to view the menu card on the touch screen and order the items by himself with the touch of the finger on the screen.

SCOPE OF THE PROJECT

The main scope of the Multi Point and Multi Section Order Based Serving System in a Modern Restaurant project is to overcome the following consequences of Delay in serving, Misconception of order, More requirement of manpower which are the most common disadvantages existing in present situations. Avoiding these leads to the benefits of more number of customers, reducing the erroneous data entry, give the customers what they actually want and improving customer’s satisfaction, fast billing procedures.

Unit Testing

SYSTEM ANALYSIS

EXISTING SYSTEM

In this system the customer is given a menu card from which he needs to select the items and orders are noted down by the waiter manually. Then the waiter submits this order to the kitchen head, who instructs the chefs. On the request of the customer for the bill, the waiter informs the cashier to generate the bill and gets back the bill to the customer for payment. Due to this there are many drawbacks such as :
a. Delay in serving
b. Misconception of order
c. More requirement of manpower.

To avoid all these we will switch to Modern Restaurant System.

PROPOSED SYSTEM

Our MRS is an innovative solution for restaurants which can create craze among the youngsters. MRS is a windows based application developed in .Net. This application is concerned with 3 modules:

1. Back Office
2. KPS
3. User Terminal

This software enables the customer to view the menu card on the touch screen and order the items by himself with the touch of the finger on the screen.

Multi Point and Multi Section Order Based Serving System in a Modern Restaurant
Also he can know the amount he need to pay. When the customer feels to receive the bill he can just close the session so that the bill will be generated at the server end and also it will be displayed on the table screen.

Orders entered by the customer at the client station automatically display at the cooks station, increasing the speed with which orders can be prepared and decreasing the wasted time of servers walking back and forth to the kitchen! When the customer closes the session, the order information along with the bill details automatically send to the server where the bill is generated avoiding misconceptions in the bill.

SOFTWARE REQUIREMENTS:

a) OPERATING SYSTEM : Window XP
b) LANGUAGE : C#.Net
c) WEB TECHNOLOGIES : ASP.NET
d) SERVER  : ISS-5.0

Architecture:

ArchitectureUsecase diagram for the entire modules:

Usecase diagram for the entire modulesSequence diagram for admin:
Sequence diagram for admin

sequence diagram for kitchen terminal

sequence diagram for kitchen terminal

sequence diagram for table terminal:

sequence diagram for table terminalcollaboration diagram for kitchen terminal
collaboration diagram for kitchen terminalcollaboration diagram for admin:
collaboration diagram for admincollaboration diagram for user terminal:
collaboration diagram for user terminalER-Diagram:

ER-Diagram

A new technique has been introduced to automate the ordinary serving system in a restaurant. Use of touch screens will save lot of time of all the customers visiting the restaurant for placing their orders and also the servers for delivering the orders without any time lapse. This application reduces human effort to a very large extent because the customer need not wait for the waiter to come and take his order and then after finishing his order he does not manually request to pay the bill, automated billing is enabled where he can pay the bill easily by a simple finger touch on the screen. Misconception of the waiters in serving the orders will also be reduced to wider extent because the orders are correspondingly displayed on kitchen screen and respectively served in FIFO basis. Touch equipment is durable for longer time; even if they wear out after a period of time they can be easily replaced and maintained using the modern technology trends. This innovative technology thereby improves the customer satisfaction and also leading to profits by serving more number of orders in less period of time.

FUTURE SCOPE

As future works, we want to focus on three major issues. Firstly, a gateway can be enabled for secured authentication purpose when the bill payment is made by the customer using the credit card or debit cards. Next, the registration page for the user can be designed not only in English but also in other regional languages using corresponding software so that this application will be more user friendly. Finally, a particular id can be assigned to each and every user when he first time visits the restaurant his information will be stored in the database and when he again visits the restaurant next time if he logs in using this id he can enjoy further benefits provided by the restaurant.

Welcome Screen – The first screen on the table terminal
Welcome Screen – The first screen on the table terminal
Registration Page on table terminal
Registration Page on table terminal
Menu screen on table terminal
Menu screen on table terminal
Items list of selected items
Items list of selected items
Items list of sent items
Items list of sent items
Items received from the table
Items received from the table
items just selected are in black colour
items just selected are in black colour
Admin’s home page
Admin’s home page

iSpeak – Next Generation Application C#.Net Project

                                   iSpeak – Next Generation application

Description:

In our day to day life we come across so many situations where we need to go through articles over Internet and documents of different types. It is general tendency for any human being to overlook few words or sentences while going through articles which may lead to any kind of mistake based on the importance of the article or document that he/she is going through.

The idea of the iSpeak project is built, based on the recent enhancements taken place in Internet Explorer [IE8] from Microsoft Corporation. In IE8 user has a provision of searching a text by selecting a search keyword from the present website page he/she is in. This Idea made us to think of this project, which we call them as Next Generation Speech applications.

The main Idea of the present iSpeak – Next Generation Application is when the users are surfing through an article in Internet Explorer; we wanted some one to speak for the user instead he /she going through entire article. For that we wanted to build a new concept of select and speak in IE. This is purely research and development in this area.

iSpeak_Next Generation application

Moving further this idea can be implemented across all the browsers which we wanted to define as Future scope of the project. Along with this, if the users wanted to read any kind of document such as .txt, .doc, .PDF we wanted to build a desktop utility to read entire/selected portion of the text for him/her. In the initial stages of Research and development we will be starting with one voice and later we try to implement different types of voices [Male and Female] with different ages. Even we want our project to support saving those selected/Entire file as wav format so that user can listen to the article whenever he/she wants instead of searching.

Modules & Functionalities in this Project:

The following are modules /functionalities of the projects.

  1. Reading selected text of Website in IE

When ever user selects some text and commands the IE then our application need to speak out the selected text. Even user can have a provision of saving the same text to Database for future reference.

    1. Speak module
    2. Saving to Database module

Practical applicability: Read all your emails in IE, white papers, articles, encyclopaedias etc

  1. Documents reader module

In this module user can upload any kind of document [.Txt, .Doc, .PDF ] to listen to the text in the document.

Even the application should be able to handle selected text reading.

  1. Document Reader
  2. Saving to Database module
  3. Selected text reading functionality
  1. A desktop application is build to search for all the saved documents for future reference.
  2. Different voice compatibility

We are trying to make this application compatible for different voices [Male and Female.]

  1. Different age groups compatibility

We are trying to make this application compatible for different age groups too.

  1. Converting selected text to Wav format for further reference.

Technologies used:

  • Microsoft .Net C# 2005 or above
  • SQL server 2005 or Above

Type of Project: Research and Development.

Note:

This ISpeak project is under Research and Development so, there could be much number of features coming as and when we explore it. We may have to modify the abstract slightly.

Use case Diagrams:

Use case Diagrams

Sequence Diagrams:

Sequence Diagram for Entered or Selected Text:

 Sequence Diagram for Entered or Selected Text

Sequence Diagram for Text File Reading:

 Sequence Diagram for Text File Reading

Doc File Read:

 Doc File Read

PDF Reading:

PDF Reading

Reading from Browser:

 Reading from Browser

Class Diagram:

 Class Diagram

Water Tax Billing System Project

Main aim of this Water Tax Billing System project is to implement an application which deals with maintaining water tax managing activities like generating a water tax bill, customer personal records and other administrative activities. Initially, all the information about customers will be entered and maintained, which in turn helps to generate water tax bill based on the customer’s consumption of electricity. This system will reduce manual work for maintaining records in files.

This system provides effective mechanism to manage water tax bills for admin by recording each and every activity. Regular transactions which include bill generation, payment etc. and exceptional transactions that are related to  change of customer’s address, not  clearing bills within due date etc. also will have to be handled by the system

Following is the list of modules that comprise this system:

a)      Managing the generated bills

b)      Managing Customer records

c)      Tracking bill status

d)     Menu design and integrating of all   modules

Main functions of these modules are:

Managing Customer records

a)      To create customer file

b)      To update customer file

c)      To generate Reports

d)     To search for customer information

Managing the water tax bills

a)      To create Bills file

b)      To update bills file

c)      To generate Reports

Tracking bill status

a)      To update payments

b)      To notify defaulters

c)      To generate Reports

Menu design and integrating of all  modules

a)      To display system banner.

b)      To process menu.

c)      Integration of all the modules

d)     To provide security

Network Intrusion Detection System

This lacks standard interface for the low-level interaction. The characteristic affects the portability of used can be categorized as an ordinary system that can be used to detect only a known or ungeneralised set of users. The main drawback lies in the fact that the system cannot be generalized. The system acts as a subsystem of the firewall itself.  The system contains the details of the intruder, which is then forwarded to the firewall.

Network Intrusion Detection System Home Page

Drawbacks

The system has no access to the data in the packets. The existing system only checks with the IP address of the arriving packets. It is possible to identify the intruder with the IP address and not with the contents of the packet. It sometimes happens that the data arrive with data that has the capability of hacking the information from the network. This is possible using certain keywords. The existing system fails to detect such intrusion. The existing system is a faster one as far as the performance is considered.

Network Intrusion Detection System details

Network Intrusion Detection System Data Flow Diagrams

Benefits 

The most important feature of the system is that the system can generalize the type of intrusion. Large amount of checking has to be done in the packets with the data stored in the adaptive model database.

Software Configuration:

FRONT END:           VB.NET

BACK END:           MS SQL SERVER

The output forms are: –

Intruder details display Form.

Adaptive modal display Form.

IP request Form.

Port scanning Form.

Ping Machine Form

TCP sniffing Form.

UDP sniffing Form.

All packet sniffing Form

Packet Detection Form

Data Mining Form

Active Machine Form

Instance Management Form

Instant Message Form

Reports Form.

Input forms are: –

Login Form.

Change Security Form.

Intruder registration Form.

Intruder alteration Form.

Adaptive modal registration Form.

Adaptive modal modification Form.

Locking Form.

CONCLUSION:

The project ‘Network Intrusion Detection System’ is meant for providing security to a system by forwarding the validated packet details to the firewall.

The current system has four modules.

Registration     : To register intruders and data model details.

Sensor : For capturing raw data packets.

Detector          : Detection of the intruder packet and forwarding packets to the firewall for blocking.

Options           : Monitoring certain system details by the administrator.

The administrator, who is the only user, can monitor all the network traffic that is the packets arriving into the network filtering the protocol type that is whether the packet is TCP or UDP. The administrator can also find out which all are the intruder packets and can forward the message for blocking the packets to the firewall.

Considering the current trends and the developments the future might offer, this is a secure system with a promising bright future in the coming networking era.

Detection Details

TABLE STRUCTURE:

Table number            :           1

Title                            :           Administrator Login

Table Name               :           Login

Description                 :           The table stores in the login user ID and the password for the authorization checking. It is used both during login and locking.

Constraint                  :           The user ID is the primary key.

Field name Type Length Description
Username Varchar 25 User Identification
Password Varchar 25 User Password

Table Number           :           2

Title                            :           Intruder Registration Details

Table name                :           Intruder

Description                 :           The details of already known intruders

Constraints                :           The int code is the primary key, IP address not null.

Field Name Type Length Description
Intcode Numeric 9 Intruder Code
Ipaddress Varchar 25 Ip Address
Intdesc Varchar 25 Intruder Description
Regdate DateTime 8 Registration Date
Starttime DateTime 8 Start Time
Endtime DateTime 8 End Time

Table number            :           3

Title                            :           Adaptive Model Table

Table name                :           Modal

Description                 :           The Adaptive model is created and stored

Constraints                :           The modcode is the primary key

Field name Type Length Description
Modcode Numeric 9 Model Code
Regdate DateTime 8 Registration date
Pattern Varchar 200 Model Pattern

Table Number           :           4

Title                            :           The Intrusion block details

Table name                :           Detection

Description                 :           The packets detected of intrusion are stored here.

Constraints                :           The Detipaddr  is the primary key 

Field name Type Length Description
Detipaddr Varchar 25 Detected IP Address
Detdate DateTime 8 Detection Date
Dettime DateTime 8 Detection Time
Protocol Varchar 10 Protocol
Dettype Varchar 25 Detection Type

Network Administrator Assisting Tool

This system is used to make security professional aware of packets entering and leaving the monitored network. It is used to sniff out the network packets. It helps to increase packet throughput as inspecting every packet can slow traffic considerably. It is an essential tool that compliments any security suite such as firewall and a good antivirus.

Large amount of checking has to be done in the packets with the data stored in the adaptive model. The system uses up LAN bandwidth. It has double the total network bandwidth requirements from any LAN. The system is more adaptable to cross platform environments.

Network Administrator Assisting Tool

The important modules of the system are: 

  • Admin
  • Detection
  • Monitor
  • Remote Control
  • Utility
  • Recovery Service

Admin: Administrator registers the intruder’s known IP addresses and  the harmful data.

Detection: Packets are detected comparing the IP address and data table.

Monitor: Pinging and shortest path is found.

Remote Control: Shut down, Restart and log off activities are done.

Utility: Change password, locking the application in server system  and Sending messages is done.

Recovery service: Backups of the data running in client machine is maintained.

INTRODUCTION

NETWORK ADMINISTRATOR ASSISTING TOOL 

The project named “Network Administrator Assisting Tool” is a system that not only detects the intruders by IP address; it detects the system with its contents also. It is used to sniff out the network packets. It helps to increase packet throughput as inspecting every packet can slow traffic considerably.

Large amount of checking has to be done in the packets with the data stored in the adaptive model. The system uses up LAN bandwidth. It has double the total network bandwidth requirements from any LAN. The system is more adaptable to cross platform environments.

Aim:

The proposed system can be used to attain information relating to network. It can be used to retrieve the information regarding the current systems in the network, the ports in use, locking the system etc. The system is first fed in with the currently available intruders and the kind of data that are to be kept out of network. Information once is stored into the system is used to check the data packets. The IP addresses that are registered are forwarded to the firewall once found among the packets. The case is different with the adaptive modal. The unwanted type of data that are stored in the adaptive modal database is compared with the data that is passing through the network. On finding any packet that contains any of the contents of the adaptive modal database they are registered as intruders and the information is stored in the database.

Network Administrator Assisting Tool Administration

 SOFTWARE SPECIFICATION 

Platform: Windows 2000/XP

GUI Tool: API

Environment: C#.NET

Database: Microsoft® SQL Server™ 2000

SYSTEM STUDY 

DETAILED STUDY

The most important feature of the system is that the system can generalize the type of intrusion. Large amount of checking has to be done in the packets with the data stored in the adaptive model database.

Features

  • The system proposed can be used to attain information relating to the network
  • It can be used to retrieve the information about the current systems in the network, the ports in use, locking the system etc.
  • The proposed system can be used to get the shortest path for the packet from source to destination.
  • The system is used to monitor currently active machines in the network and with that admin can logoff, shutdown or restart the system from the server machine.
  • The system can take the backups from the client machine and restore it back to the client machine.
  • The system is first fed in with the currently available intruders and the kind of commands that are to be kept out of the network. Information once is stored into the system is used to check the data packets. The IP addresses that are registered are forwarded to the firewall once found among the packets.
  • The case is different with the adaptive modal. The unwanted type of data that are stored in the adaptive modal database is compared with the data that is passing through the network. On finding any packet that contains any of the contents of the adaptive modal database they are registered as intruders and the information is stored in the database.

NAAT Data Flow Diagrams

EXISTING SYSTEM

Drawbacks of existing system

  • The existing system does not provide proper security over the network.
  • It needs manual processes to stop the intruder.
  • Administrator has to be in front of the system all the time.
  • Since the existing system does not have any details about the hosts, an unauthorized access cannot be detected easily.
  • The intruder cannot be found at appropriate time and blocked.
  • The existing system does not use any shortest path algorithm, so that it takes a large amount of time to transfer data packets from one host to another.
  • Cannot ensure whether the packet has been send are received at the destination.
  • The server application can be used by an unauthorized user as the existing system does not provide the facility of locking the application.
  • It does not provide activities such as shut down, log off and restart.

NAAT Data Flow Diagram1

PROPOSED SYSTEM

The project named “Network Administrator Assisting Tool” is done by using C#.NET as a Frontend and SQL Server as a Backend. This system compliments any security suite such as firewall and antivirus. The system not only detects the intruders by IP address; it detects the system with its contents also. The system checks the database for the already registered intruders. If found intruding, they are forwarded to the firewall for blocking. The firewall is responsible for the blocking of the packets.

The proposed system can be used to attain information relating to network. It can be used to retrieve the information regarding the current systems in the network, the ports in use, locking the system etc. The system is first fed in with the currently available intruders and the kind of data that are to be kept out of network. Information once is stored into the system is used to check the data packets.

The IP addresses that are registered are forwarded to the firewall once found among the packets. The case is different with the adaptive modal. The unwanted type of data that are stored in the adaptive modal database is compared with the data that is passing through the network. On finding any packet that contains any of the contents of the adaptive modal database they are registered as intruders and the information is stored in the database.

NAAT Data Flow Diagram2

Benefits of proposed system: 

  • User friendly
  • Ease of access
  • Fast retrievals
  • Single point system administration and maintenance
  • Added security to system
  • Can be implemented in network
  • Easy to mention an IP address.

DATABASE DESIGN

The database design is a must for any application developed especially more for the data store projects. Since the chatting method involves storing the message in the table and produced to the sender and receiver, proper handling of the table is a must.

In the project, login table is designed to be unique in accepting the username and the length of the username and password should be greater than zero.

The complete listing of the tables and their fields are provided in the annexure under the title ‘Table Structure’.

Admin

Table Name                 :           Admin

Purpose                       :           Maintain Host In formations and Login Details

Table Structure            :

Field Data Type Length Description Key
Hip Var char 20 Host IP Primary
Hname Var char 20 Host Name
Passwd Var char 29 Pass word
Ltime Date/Time 10 Login Time
Ldate Date/Time 10 Login date

Adaptive Model

Table Name                 :           Adaptive model

Purpose                       :           Maintain Packet Informations

Table Structure            :

Field Data Type Length Description Key
Hip Var char 20 Host IP Foreign
Tdata Var char 20 Type of data
Size Numeric 10 Size of data

Intruder Registration

Table Name                 :           Intruder Registration

Purpose                       :           Maintain Intruder Information

Table Structure            :

Field Data Type Length Description Key
Iip Var char 20 Intruder IP Primary
Rtime Date/Time 10 Reg Time
Rdate Date/Time 10 Reg Date
Tdata Var char 20 Type of data

Intruder Blocking

Table Name                 :           Intruder Blocking

Purpose                       :           Maintain Intruder Blocking Informations

Table Structure            :

Field Data Type Length Description Key
Iip Var char 20 Intruder IP Foreign
state Boolean 10 State

Backup Process

Table Name                 :           Backup

Purpose                       :           Maintain Backup data

Table Structure            :

Field Data Type Length Description Key
Hip Var char 20 Host IP Foreign
Dip Var char 20 Dest IP
Tdata Var char 20 Type of data

Remoting

Table Name                 :           Remote

Purpose                       :           Maintain Remote Process Information

Table Structure            :

Field Data Type Length Description Key
Hip Var char 20 Host IP Foreign
hname Var char 20 Host name
actionp Var char 20 Action perf
actiont Date/Time 10 Action time
actiond Date/Time 10 Action date

Monitoring

Table Name                 :           Monitor Table

Purpose                       :           Maintain Ping, Port scanning and Route Tracing

Information

Table Structure            :

Field Data Type Length Description Key
Hip Var char 20 Host IP Foreign
Dip Var char 20 Dest IP
Ctime Date/Time 10 Conn time
Cdate Date/Time 10 Conn date
Spath Numeric 10 Shortest path
Portno Numeric 10 Port number Primary

CODE DESIGN

The code design should be such that with less amount of coding we can achieve more results. The speed of the system will be more if the coding is less. Whether the data in the system is usable and readable by the system is depending on the coding.

In the project, the coding is being done such that proper validations are made to get the perfect input. No error inputs are accepted. In addition care is taken such that the data integrity and referential integrity is not violated in the database.

Checking the username and password, non-acceptance of duplicate username is made properly.

In addition, coding is designed such that concurrency avoidance of accessing the database, limited user access to the table is made perfect. The coding is designed such that the consumer can view only his complaints.

OUTPUT DESIGN

Output Forms are, 

  • Intruder Details Display Form.
  • Adaptive Modal Display Form.
  • IP Request Form.
  • Port Scanning Form.
  • Ping Machine Form.
  • TCP Sniffing Form.
  • UDP Sniffing Form.
  • All Packet Sniffing Form.
  • Packet Detection Form.
  • Data Mining Form.
  • Active Machine Form.
  • Instance Management Form.
  • Instant Message Form.
  • Report Form.

SYSTEM DEVELOPMENTS 

The important modules of the system are:

  • Admin
  • Detection
  • Monitor
  • Remote Control
  • Utility
  • Recovery Service

Admin

In this module administrator registers the intruder’s known IP addresses and the harmful data. The full control for the system is in admin and in this module administrator can update the IP as well as the modal data of the intruder.

Detection

This module detects the packets and it schedules the packets as TCP and UDP packets. Then it checks the data packets and the IP address. If any intruder or harmful data is there the system detects it.

Monitor

It lists all the processes and the error that is occurring and stores it in the database. Pinging is done and shortest path is found.

Remote Control

In this module, Administrator can find out all the active machines in the network. Administrator can then perform remote control activities such as shut down, Restart and log off according to the need.

Utility

Administrator can do the utilities like change password, lock the application in server system, and sending messages to the network.

Recovery service

Administrator can take backups of data, which are running in the client machine. Whenever the data is needed the data can be recovered and also can schedule the time.

CONCLUSION 

The Remote Monitoring System project can be thus found to be useful in various applications in both home use as well as office use to detect unnoticed malpractices in our system. Thus it makes the user to be careful about the improper usage of his system thus enabling him to take appropriate actions to stop them. Hence he can have a control over his system even in his absence. Hence it provides a level of security to the administrator’s PC. Remote Monitoring System is a powerful monitoring and surveillance tool that is useful on all platforms. This project helps us in a networking environment to monitor and spy all the system in the network connection without knowing the user.

Examination Information System (EIS) in VB

IDENTIFICATION OF NEED:

PROCESS IN EXAMINATION BEFORE THE EVOLUTION OF THE EIS SYSTEM:

The whole process starts from registration of the candidate for the exam. Registration contains information related to students like

  • Registration number
  • Name
  • Branch
  • Year
  • Exam Fee details…

After the registration is completed a list of students who have registered will be issued application forms. Filled up applications are sent to the university by the college exam cell incharges. Then after some time basing on those applications, STUDENTS details year-wise, branch-wise, regular/supply, subject-wise, are stored in the system. Students get the hall-tickets along with the details of exams they are appearing and the concerned dates.

Level 2 Class Diagram

Details of conduct of examination:

The university in Net displays the timetable of examinations and by that the students are allowed to attend the examinations basing on the schedule.  STUDENT’s details date-of-exam-wise should be taken.

Seating order-Arrangement:

Seating arrangement depends on the number of students appearing for a particular exam and the capacities of the examination halls.

Based on date of exam, Branch, Subjects, Years, Regular/Supp/Transfer

=> Number of students of each exam are sorted in order.

Sorting Order:

Based on date of exam, Branch, Subjects, Years, Regular/Supp/Transfer

=> Number of students of each exam are retrieved.

Then they are sorted as explained below:

  • Students attending regular exam are followed with supplementary students (if any) attending the same exam.
  • Supplementary students are further sorted in increasing order based on their current year of study.
  • Each batch of students (reg/supp) are in turn sorted as below :

Regular students followed by lateral entry students (if any) and

transfer candidates (if any).

In this seating arrangement we have to consider various hall capacities like

  • 24
  • 36
  • 74
  • 48 (with combination in 24)

and in this seating arrangement process students can be arranged with or without combination.

Combination of students can be made in a hall only when the subjects to which they are appearing are different.

Depending on sets allotment we have to check for seating conditions like:

No two members of same year and same set and same branch should sit adjacent (side by side or across) to each other.

Sets Allotment:

Question paper set allotment will be done for the sorted  students with the starting set number mentioned by the JNTU.

Manually the set numbers are represented corresponding to their register number in the seating arrangement form. All the above data is fed into Excel sheet.

Nominals and Additional Sheet Forms:

After the seating arrangement nominal rolls and additional sheet forms will be generated for the respective exam halls from seating arrangement database .

In nominal form we have the columns:

  • Register number with corresponding register number
  • Set number
  • Signature

In additional sheet form we have the columns:

  • Register Number
  • Main sheet no. of student
  • Number of additional sheets taken
  • Signature

These nominal rolls and additional sheet forms provide further fields

like : number of students in that hall, number of students present and number of students absent.

The filled-up information in Nominal rolls will be manually verified by the invigilators and the chief superintend. Finally this information is again updated in absentees statements which is a D-FORM.

D-Form:

In D-form students list of a particular branch/exam are grouped according to set allotment done and this list is further sorted in order as per seating arrangement.

The absentees for that exam in that list are obtained from nominal rolls and corresponding register numbers are manually rounded.

Total number of students registered, number of students present in each set are further details provided by D-Form.

RISKS INVOLVED IN EXISTING SYSTEM:

Present system is time consuming and involves lot of paper work.

The risks involved in present system are due to its manual effort of collecting required data and summarizing them for report generartion.

Some of the risks involved in present system are:

  • Student can register only when he/she is eligible for that.

Ex: If the student has attendance less than required percentage then he is

not eligible to register.

Many conditions like these are being checked manually before

registration, which is time consuming and error prone.

  • In allotting sets, if a mistake is done at a point, then this becomes cumulative and this may result in adverse consequences.
  • By mistake, in D-Form if a student present is marked as absent, confusion occurs in evaluation process.
  • If there is any need to retrieve any details, it may seem to be difficult to search manually.

There are many other risks involved that can be easily tackled by computerizing present system.

PRELIMINARY INVESTIGATION: 

PROPOSED SYSTEM

Examination Information System [EIS] is the computerized system. Which will automate all the process that is going on in the present system. The main aims for going to computerized system is

  • Fast processing
  • Less paper work
  • Robust
  • Adaptable
  • Intuitive
  • Easy retrieval

 Registration:

This process starts from Registration process and in this registration we fill the details of the candidate like:

  • Name of the student
  • Register number
  • B-tech or M.C.A
  • Year of study
  • Regular / supplement

Just before getting registered the student is checked against enrollment database, attendance database, debar list,1f4 and many other databases.

Thus only the eligible students can register.

Based on the entered criteria, fees gets automatically calculated and fees slip gets generated. If there are any changes made in fee structure by JNTU, due to the flexibility provided they can be easily reflected back in fee calculation.

The fee structure will be different for regular and supplementary.   As per present fee structure, if regular he/she should pay the total amount of Rs.815 and if it is supplement he/she should pay the amount of Rs.200 for every subject  and this should be verified against previous marks database.

 Sets Allotment:

We allot sets for the students with the starting set number mentioned by the JNTU people and programatically the sets will be allocated to the sorted students and forms will be generated accordingly.

Seating Arrangement:

After completion of set allotment we get into seating arrangement. The seating arrangement consists of with/without combination of students we have to check for conditions like no two members of same year and branch should sit side by side.

There are varieties of seating arrangements:

  • 24
  • 36
  • 74
  • 48 (WITH COMBINATION)

By mistake, if the user chooses the same subject students for combination in the same hall, then the process restricts the user by giving a meaningful message.

Depending on number of students we categorize them in that particular room selected and we will store the placing of the students in base database that will be useful for automatically generating two forms namely,

  • Nominal Rolls
  • Additional sheet forms

 D-Form:

D-form gives the whole details or status of the class, and the absentees will be marked with red color automatically by checking register numbers against absentees database.

Total students are grouped automatically based on set allotment database

and then the calculations like no. of students present, absent per set are done and reflected back in report.

This D-form will be sent to JNTU examination cell to inform status of the student.

FORMS

Examination Information System

Student Information Subject Codes Branch Codes

REPORTS:

Day Wise Statement Seating Arrangement Supplementary Registration

CONCLUSION:

The Student Enrollment System is aimed to automate examination system of a college. The total system, which was planned and designed to develop is vast in nature and functionality. The system is user friendly and intuitive and can be used even by novice users.

Though there was much that can be developed apart from what has been attempted, there were number of occasions on which new thoughts about various aspects of the project have been projected by the observers of the project, the duration of the project was considered to be a limiting factor for curtailing further previews and implementations.

The hope is that the project will be a major commercial product when the gaps leftover in the development are filled and a full-fledged project is built from the analysis and design that has been done during the project.