Lab exercise

= Introduction: =

Open source software (OSS) is a computer software for which the source code and certain other rights normally reserved for copyright holders are provided under a software license that meets the open source definition. This permits users to use, change, and improve the software, and to redistribute it in modified or unmodified forms.

= Aims: =

The aim of this course is to familiarize the students with OSS needs to develop a participatory organizational model that allows many to contribute in different ways to OSS development. ==

Having successfully completed this course, the student will be able to Use open source development environment. Evaluate OSS on the basis of standards. Develop small application using JAVA and database. Analyze and design appropriate open source enterprise solutions. Evaluate and compare different type of open source operating system. Evaluate open source management tools.

Experiments:
1.Study, analysis and compare various open source software according to the open source standards.

2.Download any open source software application written in JAVA with source code and modify the source code to add extra functionality.

3.Develop a small application with the help of database (MySQL and PostGre SQL) for any domain in JAVA technology.

4.Learn the working and installation of the following tools: Open3, Enhydra, Jboss, Zope, Zend.

5.Learn the working and installation process of the following Operating Systems and deliver a presentation: Linux, Fedora, ubuntu, CentOS and Boss.

6.Rapid web application development framework: Ruby on Rail.

7.Learn the working and installation process of the following Open Source Software Management Tools : Taskjuggler and dotProject.net 8.Introduction to MySQL, an exercise on data types in MySQL &amp; Data Definition Language. 9.Exercise on Data Manipulation Language and transaction control commands using MySQL. 10.Exercise on Types of Data Constraints using MySQL. 11.Exercise on Joins (single-table or multi-table) and using normalization using MySQL. 12.Exercise on group-by clause and date arithmetic using MySQL. 13.Exercise on different functions (aggregate, math and string) using MySQL. 14.Introduction to PL/SQL, Control Structures, Procedures and Functions, View using MySQL. 15.Exercise on different types of sub queries using MySQL.