T.E Computer PL - 1 Programs Pune University 2012 course

310246 Programming Laboratory I

Assignments Group A (Mandatory)

1. 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)
2. DBMS using connections(Client-application server-Data sever, three tier) Oracle/MySQL (ODBC/JDBC), SQL Joints, prompt.
3. Design and Develop SQL DDL statements which demonstrate the use of SQL objects such as Table, View , Index using Client-Data sever(two tier)
4. Write a program in Python/C++ to read display the i-node information for a given text file, image file.
5. 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++ 
6. Use Python for Socket Programming to connect two or more PCs to share a text file.

Assignments Group B (Any Six Assignments, All assignments to be covered in a Batch) 

1. 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)
2. Implement database with suitable example using MongoDB and implement all basic operations and administration commands using two tier architecture.
3. Use MongoDB to process semi structured and unstructured data collections such as Rfid, images, blogs use python/Java MongoDB interface.
4. 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.
5. Write a program in Python/C++ to test that computer is booted with Legacy Boot ROM BIOS or UEFI.
6. 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.
7. Write a program in C++ to develop a tool using GRUB2 or GRUBx64.rfi select and display a boot partition. (use appropriate overloading)
8. Write a Python/Java/C+ program to verify the operating system name and version of Mobile devices.
9. Write a program using MongoDB to compose a web news-letter consisting of videos, images, text use python MongoDB interface.
10. Create a iso boot image using open source tools.
11. Write a python program for creating virtual file system on Linux environment.
12. Write a program in C++ to make USB Device Bootable by installing required system files.
13. Write a program in python for USB Device File Management. Check usefulness of command e2fsck for different file systems mounted on computer.
14. Aggregation and indexing with suitable example using Cassendra and RdfID based employees attendance system.
15. Aggregation and indexing with suitable example using MongoDB.
16. Map reduce operation with suitable example using MongoDB.
17. Indexing and querying with MongoDB using suitable example.
18. Connectivity with MongoDB using any Java application.
19. 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: Advance Technology Assignments (Any One, all three to be

covered in a Batch)

1. BIG DATA applications using Hadoop
2. BIG DATA applications using Blogs
3. Big Data Predictive Machine Learning
4. Create and test functioning of Windows-8 ReFS (Resilient File System)