syllabus third year ( computer engineering ) course 2012 unipune | Programming Laboratory I (PL1)

syllabus third year ( computer engineering ) course 2012 unipune Programming Laboratory I  (PL1)

 

 

                      Assignments Group A (Mandatory)

DBMS using connections(Client-Data sever, two tier) Oracle/MySQL (ODBC/JDBC), SQL prompt to create data base tables insert, update data values, delete table, use table, select
queries with/without where clause. ,demonstrate use of stored procedure / function (create procedure at the data side and make use of it on the client side)

DBMS using connections(Client-application server-Data sever, three tier) Oracle/MySQL (ODBC/JDBC), SQL Joints, prompt.

Design and Develop SQL DDL statements which demonstrate the use of SQL objects such as Table, View , Index using Client-Data sever(two tier)

Write a program in Python/C++ to read display the i-node information for a given text file, image file.

Write an IPC program using pipe. Process A accepts a character string and Process B inverses the string. Pipe is used to establish communication between A and B processes using Python or C++.

Use Python for Socket Programming to connect two or more PCs to share a text file.

                                                  Assignments Group B

Design at least 10 SQL queries for suitable database application using SQL DML statements:
Insert, Select, Update, Delete Clauses using distinct, count, aggregation on Client-Data
sever(three tier)

Implement database with suitable example using MongoDB and implement all basic
operations and administration commands using two tier architecture.


Use MongoDB to process semi structured and unstructured data collections such as Rfid,
images, blogs use python/Java MongoDB interface.


Write an python/Java application using MongoDB to maintain the blog for composing the
blog consists of text columns, images and videos also calculate the hit or users visited by
drawing 2D graphs.

Write a program in Python/C++ to test that computer is booted with Legacy Boot ROMBIOS
or UEFI.

Write a program in C++ to create a RAMDRIVE and associate an acyclic directory structure
to it. Use this RAMDRIVE to store input, out files to run a calculator program.

Write a Python/Java/C+ program to verify the operating system name and version of Mobile
devices.

Write a program using MongoDB to compose a web news-letter consisting of videos,
images, text use python MongoDB interface.

Create a iso boot image using open source tools.

Write a python program for creating virtual file system on Linux environment.

Write a program in C++ to make USB Device Bootable by installing required system files.

Write a program in python for USB Device File Management. Check usefulness of
command e2fsck for different file systems mounted on computer.

Aggregation and indexing with suitable example using Cassendra and RdfID based
employees attendance system.

Aggregation and indexing with suitable example using MongoDB.

Map reduce operation with suitable example using MongoDB.

Indexing and querying with MongoDB using suitable example.

Connectivity with MongoDB using any Java application.

Using MongoDB create a database of employee performance, employee attendance on the workstation. Perform statistical analysis for the results of the products produced by employees rated as passed ok, damaged products ( 5 samples per batch size 1000) and the portion covered in the training and absentee of the employees during training. Use programming language R. (or R-Python/R-Java) or equivalent assignment using R Programming Language for BiGDATA computing.


                                                Assignment Group C

BIG DATA applications using Hadoop

BIG DATA applications using Blogs

Big Data Predictive Machine Learning

Create and test functioning of Windows-8 ReFS (Resilient File System)