T.E Computer PL - 1 Programs Pune University 2012 course
310246 Programming Laboratory I
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 (Any Six Assignments, All assignments to be covered in a Batch)
- 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 ROM BIOS 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 program in C++ to develop a tool using GRUB2 or GRUBx64.rfi select and display a boot partition. (use appropriate overloading)
- 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: Advance Technology Assignments (Any One, all three to be
covered in a Batch)
- 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)
T.E Computer PL - 1 Programs Pune University 2012 course
Reviewed by Hardik Pandya
on
4:14:00 PM
Rating:
No comments: