09-02-2013, 04:19 PM
Project Report on College automation System
1College automation .doc (Size: 256.5 KB / Downloads: 46)
Introduction
The system that we have designed has been fully developed using object oriented paradigm. System is completely developed on java platform using the concepts of JDBC (java data base Connectivity), AWT (Abstract window toolkit), Event Handling. The College automation System contains an interactive GUI with the functionalities that can be explored on just a single button click. In this project we use original data. In this project we can see the College Automation system. By this we can add a new Student, we can delete a Delete, also we can modify a existing Student status.
Database Design
A database is a collection of integrated data stored with minimum redundancy to serve many users quickly and efficiently, it is organized so that various files can be accessed through a simple reference based on the relationship among records in the file rather than physical location. The database of our project exists in java. Certain objectives were kept in mind while designing the databases which are as follows:
Reduced Redundancy: redundant data occupies space and therefore is wasteful. Therefore database is designed in manner that it stores the data only once.
Windows XP:
Windows XP is a family of 32-bit and 64-bit operating systems produced by Microsoft for use on personal computers, including home and business desktops, notebook computers, and media centers. The name "XP" stands for eXPerience. Windows XP is the successor to both Windows 2000 Professional and Windows Me, and is the first consumer-oriented operating system produced by Microsoft to be built on the Windows NT kernel (version 5.1) and architecture.
The most common editions of the operating system are Windows XP Home Edition, which is targeted at home users, and Windows XP Professional, which offers additional features such as support for Windows Server domains and two physical processors, and is targeted at power users, business and enterprise clients. Windows XP Media Center Edition has additional multimedia features enhancing the ability to record and watch TV shows, view DVD movies, and listen to music. Windows XP Tablet PC Edition is designed to run ink-aware applications built using the Tablet PC platform. Two separate 64-bit versions of Windows XP were also released, Windows XP 64-bit Edition for IA-64 (Itanium) processors and Windows XP Professional x64 Edition for x86-64. There is also Windows XP Embedded, a componentized version of the Windows XP Professional, and editions for specific markets such as Windows XP Starter Edition.
History
Java started as a project called “Oak” (The name came from an oak tree that stood outside the Sun Microsystems office) by James Gosling in June 1991 for use in a set top box project. Gosling’s goals were to implement a virtual machine and a language that had a familiar C/C++ style of notation. The first public implementation was Java in 1995. It promised “Write Once, Run anywhere” (WORA), providing no-cost
runtimes on popular platforms. It was fairly secure and its security was configurable allowing network and file access to be restricted. Major web browsers soon incorporated the ability to run secure Java “applets” within web pages. Java became popular quickly. With the advent of “Java 2”, new versions had multiple configurations built for different types of platforms. For example, J2EE was for enterprise applications and the greatly stripped down version J2ME was for mobile applications. J2SE was the designation for the Standard Edition. In 2006, for marketing purposes, new “J2”versions were renamed Java EE, Java SE, respectively
JAVA DATABASE CONNECTIVITY
You use databases to store data. In addition to storing data in a structured manner, databases help in easy retrieval and processing of data. However, the maintenance of databases can be arduous for some people. Imagine that a store owner has to maintain data about a large department store on an SQL server. In order to update or query the database, he will need to learn about SQL statements. This can be a tedious task for the store owner. The solution is to build applications that will act as an interface between the store owner and the database. The applications will accept values from the store owner by using user-friendly GUIs, and the application will update or query the database. The Java environment provides you the JDBC API necessary to create Java applications that are capable of interacting with a database.
JDBC provides a database programming API for java programs. Since the ODBC API is written in ‘C’ language and make use of pointers and other constructs that java does not support, a java program cannot directly communicate with ODBC driver.
CONCLUSION
FINDING:
During creation of this project we have find so many logic and learn about how to plan about project and how manage this project. In project creation division for system study, Analysis, Designing, Coding and testing is very important. We find most important things on project creation is ‘TIME DIVISION’.This project helped us to gain valuable experience of developing large application. This gave me a fell of modular approach of software development.
We learned about developing different project modules in JAVA and then integrating them. It was really wonderful and learning experience