computer science projects

Development of an Online Course Portal for a Campus

This project aims at creating a Courses portal for a campus/organization. This allows registered users of the system to join a course available in the site and access the materials published for the course. People can register themselves as students of a course or Faculty for a course.

When a person registers himself as a Faculty, an approval mechanism should be triggered which sends an email to the Administrator for approving the person as a Faculty.

There will be an admin approval page where admin can approve the faculty members for the course.

The course home page should contain the title of the course and a brief description. There will be a discussion board for each course where students can interact, an announcement section, which contains the latest announcements, and a course content section which gives the links for the material available for the course.

For faculty members there will be an extra link for uploading the course content in a zip file format. The course content should be html pages, which should be uploaded in the zip file format.

There should be a mechanism for the faculty members to create a test for the course specifying the test title and a set of multiple-choice questions and duration of time of the test.

Keywords

Databases Web Server, Programming

Generic Technlogy keywords

Specific Technology keywords

Oracle/MS-SQL server, Tomcat servlet Engine., java/jsp/servlets

Analysis, Design, Implementation, Testing, User Interface

Project type keywords

Functional components of the project

There will be a Course Portal home page where there will be a registration link as well as a login screen is available.

There are three types of users in the system

Administrator

Faculty

Student (for a course)

The administrator should be able to do the following:-

Create a Course, by providing the course title and description.

Approve Faculty members for a Course

Delete the members of a Course

Publish announcements

A page to view all the feedbacks received. 

Orkut Java

We plan to develop a live chatting module based on the group http://www.orkut.com .We studied the working of orkut in detail..and tried to extract important features in our project.

Basically our project works on LAN while the real orkut works on internet. But the basic idea behind it is the same..that is to provide the user with a enjoyable and good-to-look means of communication.

The real orkut provide the users with lot of options such as add as a friend ,write scraps, add to crush list ,write testimonials, joining communities etc..but we plan to include only the basic options in our project which deal with communication purpose or rather the chatting purpose .

Hence our project will contain basic functions like add as friend, write scraps and uploading photo. Like in real orkut ,user will create his own account containing a unique username and password ,which he only can access .If the user is a new one then he has to fill application form containing his personal information. Then only the user can log on to the system.

The user can write scrap to any member of (our project) orkut at any point of time. He is also eligible to upload the photo of his choice, which can be viewed by all the members of (our project) orkut .The album feature which is present in real orkut is not taken in our project as there is as such no need of it.

Also users are allowed to upload only one photo of his choice, which will be displayed on his homepage .The user, on finding his friend as member of(our project) orkut can send a friend's request to him. Now it depends on user's friend whether to accept him as a friend or to reject him..this is totally in hands of the user's friend!!!

All the user's friends will be displayed on rightmost top of our screen.so that he can know who are online and who are not?.The user on finding a person to be online can write scraps to him.(Even if user's friend is offline, user can write scraps to him.these scraps will be viewed by user's friend when he will access his account).

Scraps can be written by visiting the profile of his friend and writing scraps in his scrapbook..Similarly a person can view scraps written to him in his own scrapbook.User is eligible to delete the scraps written to him and the scraps written by him. Other's scraps can't be deleted!!!!!!!

If the user is currently online, then he has to refresh the page constantly so as to view the new changes made to his account(not his personal info)for eg :if new scrap is written by his friend, then the user has to refresh his scrapbook page so as to view this new scrap.thus chatting can be done on orkut.

The user ,at any point of time, can change his personal information or his photo!!!

To implement this project, sufficient knowledge of JAVA is needed. Along with that, knowledge of socket programming and JDBC is must. Lets see how they are implemented.

• Socket programming is needed to connect PC's together and exchange information between them.

• The code of the project has to be done in JAVA hence knowledge of JAVA is must!!!!

• Also all the information is to be stored in database, hence to connect the database with our source code, knowledge of JDBC is needed.

SUDOKU

The main aim of the project is providing security to the PC. The project develops a system, which prompts the user to enter a password during the booting process itself. The user in cannot skip this process anyway once the software is installed.

Only by entering the correct password we can enter to the next screen or else the system reboots. This prevents any illegal entries into the system.

Any changes in the system can be brought only when the correct password is entered. Then we can go to the setup and change the password and encryption key if we require.

Thus the system which have Windows98 as it's operating system is completely protected by the user by a password which he has entered during the setup of the software and no user of the system can skip this password checking.

This confirms that the system is not being hacked and this is the main objective of the software.

The project "SUDOKU" game on student based PC provide flexibility and also to have abroader outlook a guest mode is to be implemented for infrequent or temporary accessories of the host's computer Since it is a student based version only a limited number access the PC.So we limit the number of users .

The project consists sample numbers in the correct position and the player have to fill the remaining numbers in the correct order to win the game.The other features mentioned in sample,about statements.

So the "SUDOKU" game is more easy as the ultimate aim should be developed. The project is object oriented one.So the primary requirement is the use of store and manipulate the numbers.

In order to satisy the infrequent users a guest mode is required with limited but necessary facilities.

The most important requirement is that the software developed should be user friendly and unreachable.

 

Insurance Database

The current authentication and verification process for CTPL COCs uses a centralized database system called COCAS (COC Authentication System). COCAS was developed by SQL Wizard and is owned by the Philippine Insurers and Reinsurers Association (PIRA).

When CTPL insurance is sold to the registrant, the insurance company encodes insurance and vehicle data into COCAS using the Internet. The registrant then passes through a verification step at a station (handled by DTECH Management Inc) located in LTO District Office premises, where the authenticity of the COC is verified.

At this stage, a DTECH representative connects (using the internet or SMS) to COCAS, encodes COC and vehicle information, and affixes a sticker on the COC if verification is received.

The registrant then submits documents to the LTO evaluator, where the evaluator checks whether the COC has indeed been verified by ensuring that a sticker is present, before proceeding with the registration transaction.

The insurance firms eventually declare the number of COCs they have issued to the IC and pay the corresponding taxes to the BIR.

Consider the Insurance database given below. The primary keys are underlined and the data types are specified:

PERSON( driver-id :string,name:string,address:string)

CAR( Regno :string,model:string,year:int)

ACCIDENT( report-number :int,date:date,location:string)

OWNS( driver-id :string,regno:string)

PARTICIPATED( driver-id :string, regno :string, report-number :int,damage-amount:int)

1. create the above tables by properly specifying the primary keys and the foreign keys

2. Enter atleast five tuples for each relation

3. Demonstrate how you

a. update the damage amount for the car with a specific regno in accident with report number 12 to 25000

b. add a new accident to the database

4. Find the total number of people who owned cars that were involved in accidents in 2002.

5. Find the number of accidents in which cars belonging to a specific model were Involved.

6. Generation of suitable reports

7. Create suitable front end for querying and display the results

Security System For DNS Using Cryptography

The mapping or binding of IP addresses to host names became a major problem in the rapidly growing Internet and the higher level binding effort went through different stages of development up to the currently used Domain Name System (DNS).

The DNS Security is designed to provide security by combining the concept of both the Digital Signature and Asymmetric key (Public key) Cryptography. Here the Public key is send instead of Private key.

The DNS security uses Message Digest Algorithm to compress the Message(text file) and PRNG(Pseudo Random Number Generator) Algorithm for generating Public and Private key.

The message combines with the Private key to form a Signature using DSA Algorithm, which is send along with the Public key.

The receiver uses the Public key and DSA Algorithm to form a Signature. If this Signature matches with the Signature of the message received, the message is Decrypted and read else discarded.

SYSTEM REQUIREMENTS

HARDWARE REQUIREMENTS

Processor : Intel Pentium IV

RAM : 512 MB

Hard Disk : 40GB

SOFTWARE REQUIREMENTS

Operating System : Windows 98,2000,xp

Tools : jdk1.5.0

Technologies : J2SE (network,IO,Swings, Util,crypto) 

Pro-net Communication

Intranet exploits the incredibly popular and low cost internet tools to gain strategic advantage over competitors, cut costs and improves operational effectiveness. An Intranet typically has 3 features lacking on the Internet.

• Speed - broad bandwidth

• Security - private internal network ( LAN /WAN),protected from

Internet users by a firewall.

• Control - enterprise network management to ensure reliability.

The Intranet can be viewed as an information utility for the enterprise. It doesn't matter whether we are using the Mac, Windows or a UNIX workstation - we plug into the Intranet and find out what we need, from document to email to data to audio and video.

Corporate and department information is accessed via the standards the Internet: e-mail (SMTP), WWW , File transfer (FTP) and other Internet services.

Intranets overcame many of the organizational and technology barriers that were created in the past.

Web solutions overlay the department LAN systems, with their own security and domains, and make information available to everyone in the corporation - without changing the LAN security structures. That provides a huge benefit.

Software Specification:

Operating System : Windows 2000 Professional/XP.

Programming Package : CORE JAVA.

Hardware Specification:

Processor : Pentium III or Higher

Network Interface Card : 32 BIT Ethernet Hub

Ram : 128 MB or higher Ram

Hard disk : 20 GB or more

Existing System:

• Large amount of data cannot be attached

• There would be some delay in sending offline messages

Proposed System:

1. Sending off-line messages and large amounts of data through attachments.

2. Reduction of delay in transfer of data and Group chatting features are accomplished.

Modules :

This application mainly consist two modules:

• Mailing

In this module, we have accomplished the task of sending off-line messages and large amounts of data through attachments.

• Chatting

In this module direct information transfer, reduction of delay in transfer of data and Group chatting features are accomplished.

One will come across the following forms during the implementation of this project:

• Login frame

• New user frame

• Forgot password frame

• Start frame

• Mail list frame