COMPUTER SCIENCE AND ENGINEERING LABORATORIES

COMPUTER NETWORKS AND NETWORK SECURITY LAB

 Name of the Lab:COMPUTER  NETWORKS AND NETWORK SECURITY LAB

 Lab In charge:  V.Gayatri

 Programmer:     U.V.Rajesh

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 1TB

 MONITOR : DELL  19.5” inch

 Description of the Lab: The aim of this course is to learn implementation of error detection and correction methods, routing protocols, cryptographic algorithms, and
configuration of S/MIME, NMAP for email communication and ports monitoring.

Objectives :  students will try to learn

  1. Implementation of various error detection and correction methods
  2. Implementation of various routing protocols.
  3. Detailed description of network simulator.
  4. Implementation of various cryptographic algorithms.
  5. Configuration of NMAP
  6. Configuration of S/MIME

     Outcomes:- students will be able to

  1. Implement error detection and correction techniques.
  2. Implement routing protocols.
  3. Explain working of network simulator.
  4. Implement cryptographic algorithms.
  5. Configure NMAP for ports monitoring
  6. Configure S/MIME for email communication

List of Experiments:

    1. submit a report on the computer network facility available in the college including the devices used,
      topology used, specification of all the equipment used
    2. submit a report on the Internet facility available in the college including the specification of the
      devices used and logical configuration
    3. Implement the algorithm for parity method for error control
    4. Implement the algorithm on hamming method for error correction (both single and block errors)
    5. Implement the algorithm for check sum computation
    6. Implement the distance vector routing algorithm
    7. Implement the link state routing algorithm
    8. Study any simulator available in the market and submit a report containing executive summary of it
      and detail description of the features.
    9. Working with Sniffers for monitoring network communication (Ethereal)
    10. Understanding of cryptographic algorithms and implementation of the same in C or C++
    11. Using openssl for web server – browser communication
    12. Using GNU PGP
    13. Performance evaluation of various cryptographic algorithms
    14. Using IPTABLES on Linux and setting the filtering rules
    15. Configuring S/MIME for e-mail communication
    16. Understanding the buffer overflow and format string attacks
    17. Using NMAP for ports monitoring
    18. Implementation of proxy based security protocols in C or C++ with features like confidentiality,
      integrity and authentication

ADDITIONAL EXPERIMENTS

1)Implement an algorithm for Cyclic Redundancy Check(CRC)

2)Implement  an algorithm for Data Encryption Standard(DES)

JAVA PROGRAMMING LAB

Name Of The Lab:JAVA PROGRAMMING LAB

Lab Inchrage:Mrs V.Bharathi

Programmer Name:Ms K.Navya

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 500TB

 MONITOR : DELL  19.5” inch

Description Of the Lab:

Objectives:

·         Learn to use object orientation to solve problems and use java language to implement them.

·         To experiment with the syntax and semantics of java language and gain experience with java programming

Outcomes:

  • Ability to write portable programs which work in all environments
  • Ability to create user friendly interfaces
  • Ability to solve the problem using object oriented approach and design solutions which are robust

List Of Experiments:

  • Preparing and practice – Installation of Java software, study of any Integrated development environment, sample programs on operator precedence and associativity, class and package concept, scope concept, control structures, constructors and destructors. Learn to compile, debug and execute java programs.
  • Write Java program(s) on use of inheritance, preventing inheritance using final, abstract classes.
  • Write Java program(s) on dynamic binding, differentiating method overloading and overriding.
  • Write Java program(s) on ways of implementing interface.
  • Write a program for the following
  • Develop an applet that displays a simple message.
  • Develop an applet for waving a Flag using Applets and Threads.
  • Write Java program(s) which uses the exception handling features of the language, creates exceptions and handles them properly, uses the predefined exceptions, and create own exceptions
  • Write java program that inputs 5 numbers, each between 10 and 100 inclusive. As each number is read display it only if it’s not a duplicate of any number already read. Display the complete set of unique values input after the user enters each new value.
  • Write Java program(s) on creating multiple threads, assigning priority to threads, synchronizing threads, suspend and resume threads

10) Write a java program to split a given text file into n parts. Name each part as the name of the original file followed by .part<n> where n is the sequence number of the part file.

11) Write a java program to create a super class called Figure that receives the dimensions of two dimensional objects. It also defines a method called area that computes the area of an object. The program derives two subclasses from Figure. The first is Rectangle and second is Triangle. Each of the sub classes override area() so that it returns the area of a rectangle and  triangle respectively.

12)  Write a Java program that creates three threads. First thread displays “Good Morning” every one second, the second thread displays “Hello” every two seconds and the third thread displays “Welcome” every three seconds

13) Design a simple calculator which performs all arithmetic operations. The interface should look like the calculator application of the operating system. Handle the exceptions if any.

14) Write a java program to handle mouse events

15) Write a java program to handle keyboard events

16) Write a java program that allows conduction of object type examination containing multiple choice questions, and true/false questions. At the end of the examination when the user clicks a button the total marks have to be displayed in the form of the message.

17) Write a java program that creates menu which appears similar to the menu of notepad application of the Microsoft windows or any editor of your choice.

18) Write a java program that creates dialog box which is similar to the save dialog box of the Microsoft windows or any word processor of your choice.

19) Write a Java program that correctly implements producer consumer problem using the concept of inter thread communication

20) Write a java program to find and replace pattern in a given file.

21) Use inheritance to create an exception super class called ExceptionA and exception sub classes ExceptionB and ExceptionC, where ExceptionB inherits from ExceptionA and ExceptionC inherits from ExceptionB. Write a java program to demonstrate that the catch block for type ExceptionA catches exception of type ExceptionB and ExceptionC.

22) Write a Java program which opens a connection to standard port on well known server, sends the data using socket and prints the returned data.

23) Write a Java program to create a URLConnection and use it to examine the documents properties and content.

24) Write a Java program which uses TCP/IP and Datagrams to communicate client and server.

25) Create an interface for stack with push and pop operations. Implement the stack in two ways: fixed size stack and Dynamic stack (stack size is increased when stack is full).

26) Create multiple threads to access the contents of a stack. Synchronize thread to prevent simultaneous access to push and pop operations.

OBJECT ORIENTED ANALYSIS AND DESIGN & SOFTWARE TESTING LABORATORY

Name of the Lab: OBJECT ORIENTED ANALYSIS AND DESIGN & SOFTWARE TESTING LABORATORY

Lab In-charge:Mr. Sk Asiff

Programmer: Mr.B.Ramakrishna

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 500TB

MONITOR : DELL 19.5” inch

Description of the Lab

Objectives:

  • Practice the notation for representing various UML diagrams
  • Analyze and design the problem by representing using UML diagrams
  • Become familiar with all phases of OOAD

Outcomes:

  • Find solutions to the problems using object oriented approach
  • Represent using UML notation and interact with the customer to refine the UML diagrams

List of Experiments:

Part A: OOAD Lab

UML diagrams to be developed are:

  1. Use Case Diagram.
  2. Class Diagram.
  3. Sequence Diagram.
  4. Collaboration Diagram.
  5. State Diagram
  6. Activity Diagram.
  7. Component Diagram
  8. Deployment Diagram.
  9. Object Diagram.

Problems that may be considered are

  1. College information system
  2. Hostel management
  3. ATM system

Part B : Software Testing Lab

  1. Write programs in C‘ Language to demonstrate the working of the following constructs:i) do…while
    ii) while….do
    iii) if…else
    iv) switch
    v) for
  2. A program written in C‘ language for Matrix Multiplication fails‖ Introspect the causes for its failure and write down the possible reasons for its failure.
  3. Take any system (e.g. ATM system) and study its system specifications and report the various bugs.
  4. Write the test cases for any known application (e.g. banking application)
  5. Create a test plan document for any application (e.g. Library Management System)
  6. Study of Win Runner Testing Tool and its implementation.

OPERATING SYSTEM LABORATORY

Name of the LAB: OPERATING SYSTEM LABORATORY

Lab Incharge: Dr.M.Mathan Kumar

Programmer: Ms.P.Chaitanya

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 1TB

MONITOR : DEL 19.5” inch

Description of the Lab: This lab complements the operating systems course. Students will gain practical experience with designing and implementing concepts of operating systems such as system calls, CPU scheduling, process management, memory management, file systems and deadlock handling using C language.

Course Objectives:

      • To understand the design aspects of operating system
      • To solve various synchronization problems

Course outcomes:

      • Ensure the development of applied skills in operating systems related areas.
      • Able to write software routines modules or implementing various concepts of operating system.

List Of Experiments:

      1. Simulate the following CPU scheduling algorithms
      2. a) Round Robin b) SJF c) FCFS d) Priority
      3. Simulate all file allocation strategies
      4. a) Sequential b) Indexed c) Linked
      5. Simulate MVT and MFT
      6. Simulate all File Organization Techniques
      7. a) Single level directory b) Two level c) Hierarchical d) DAG
      8. Simulate Bankers Algorithm for Dead Lock Avoidance
      9. Simulate Bankers Algorithm for Dead Lock Prevention
      10. Simulate all page replacement algorithms
      11. a) FIFO b) LRU c) LFU Etc. …
      12. Simulate Paging Technique of memory management
      13. Control the number of ports opened by the operating system with
      14. a) Semaphore b) monitors
      15. Simulate how parent and child processes use shared memory and address space
      16. Simulate sleeping barber problem
      17. Simulate dining philosopher‘s problem
      18. Simulate producer and consumer problem using threads (use java)
      19. Simulate little‘s formula to predict next burst time of a process for SJF Scheduling algorithm.

WEB TECHNOLOGIES & MOBILE APPLICATION DEVELOPMENT LAB

Name of the lab: WEB TECHNOLOGIES & MOBILE APPLICATION DEVELOPMENT LAB

Lab incharge : Mr Y.Venkata Ramesh

Programmer : Mrs P.Anusha

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 1TB

MONITOR : DELL 19.5” inch

 Mobile Application development Lab 

Description of the lab:

In this lab, a student is expected to design, implement, document and present a mobile client/server system using standard Java and Java 2 Micro Edition (J2ME) platform.Specifically it is required to design and implement a system that consists mainly of a mobile client (MC) and a Proxy Server (PS).MC will be written in J2ME, MIDP 2.0, while PS will be written in standard Java. It is necessary to use a mobile phone emulator to develop and demonstrate the experimentsIt may be necessary to use other components or existing resources (servers) as needed. For instance a database local to PS or a web service available on the Internet that can be invoked by the PS.

Course Objective:

      • In this lab, a student is expected to design, implement, document and present a mobile client/server system using standard Java and Java 2 Micro Edition (J2ME) platform.
      • Specifically it is required to design and implement a system that consists mainly of a mobile client (MC) and a Proxy Server (PS).
      • MC will be written in J2ME, MIDP 2.0, while PS will be written in standard Java. It is necessary to use a mobile phone emulator to develop and demonstrate the experiments
      • It may be necessary to use other components or existing resources (servers) as needed. For instance a database local to PS or a web service available on the Internet that can be invoked by the PS

 Course Outcomes

      • Demonstrate J2ME 2.5.2 Wireless Toolkit/Android studio and Layout Managers
      • Design Graphical primitives in J2ME 2.5.2 Wireless Toolkit/Android studio
      • Deploy applications to hand-held devices

List of experiments:

 Using Wireless Markup language develop the APP using Android OS

      1. Design and develop an Mobile App for smart phones The Easy Unit Converter using Android. This application should have approximately 20 categories to be used in your daily life. It includes following units: Acceleration, Angle, Area, Circle, Capacitor, Cooking, Data Size, Density, Data Transfer rate, Electric Current, Energy, Flow Rate, and Force.
      2. Design and develop an Mobile App for smart phones Currency Converter. .This applications should synchronize online as you run it and sends you back the latest and most reliable exchange rates possible.

This application should support following conversions:

EUR->Euro

GBP->British Pound

USD->United States Dollar

AUD->Australian Dollar

CAD->Canadian Dollar

CHF->Swiss Franc

CNY->Chinese Yuan

HKD->Hong Kong Dollar

IDR->Indonesian Rupiah

INR->Indian Rupee

JPY->Japanese Yen

THB->Thai Bah

      1. Design and develop an Mobile App game for smart phones The Tic Tac Toe using Android.
      2. Design and develop an Mobile App for smart phones ,The Health Monitoring System using Android. This App should record Biochemistry Lab Parameters and if abnormal shold send an SMS to doctor for Medications.
      3. Design and develop an Mobile App for smart phones The Expense Manager using Android. This is an application for managing your expenses and incomes: Tracking expenses and incomes by week, month and year as well as by categories, Multiple accounts in multiple currencies, Schedule the payments and recurring payments, Take a picture of receipt, Payment alerts, Budget by day, week, month and year, Search and reports, Import and export account activities in CSV for desktop software, Customize expense categories, payer/payer, payment methods, date format, white or black background, button style etc, Account transfer, Convenient tools such calculator, currency converter, tip calculator, sales and tax calculator and credit card calculator.

Web and Internet Technologies Laboratory 

Description of the lab:

      • To introduce client side scripting with Javascript and DHTML To introduce server side programming with Java servlets, JSP and PHP.To learn the basic web concepts and Internet protocols

  Course Objectives: 

      • To introduce client side scripting with Javascript and DHTML
      • To introduce server side programming with Java servlets, JSP and PHP.
      • To learn the basic web concepts and Internet protocols

  Course Outcomes:

      • Ability to create dynamic and interactive web sites.
      • Gain knowledge of client side scripting using java sript and DHTML.
      • Demonstrate understanding of what is XML and how to parse and use XML data
      • Able to do server side programming with Java Servelets, JSP and PHP.

List of experiments:

      1. To create a simple student bio-data form using html5. it should contain the following name (text box), address (multiline text box),gender (radio button male, female),skill sets  known (check boxes – c,c++,java,C#etc), extra curricular activities (text box), nationality (combobox) ,submit and reset button.
      2. To create an html page with different types of frames such as floating frame, navigation frame & mixed frame.
      3. Design the webpage by applying the different styles using inline, external & internal style sheets.
      4. Write a java script program to read .XML file and display data in a neat format.
      5. To write a Javascript program to define a user defined function for sorting the values in an array. Use HTML5 for user interface.
      6. To create an html page to demonstrate exception handling in javascript

Create an html page named as “exception.html” and do the following.

      1. within the script tag write code to handle exception
      2. a) define a method RunTest() to get any string values(str) from the user and callthe method Areletters(str).
      3. b) In Areletters(str) method check whether str contain only alphabets (a-z, A-Z), if not throw exception.
      4. c) Define a exception method Input Exception(str) to handle the exception thrown by the above method.
      5. Within the body tag define a script tag to call Runtest() method define.
      6. Write a jsp servlet program to implement the single text field calculator.
      7. Write a jsp servlet program to demonstrate  session handling using

– url rewriting

–hidden formfield

–cookies

–sessions

      1. To create a php program to demonstrate the different predefined function in array, Math, Data & Regular Expression.

Procedure:

      • Create php file named as php
      • for demonstrating the method for handling various strings with regular expression php
      • for demonstrating the methods for handling the array values Math_function.php
      • to demonstrate the predefined in math objects. Date_time.php to demonstrate the predefined function in date subject
      1. Write a program in PHP for a simple email processing with attachment using forms
      2. Write a program for PHP for a login script; create a login database and store username and password
      3. Write a program in PHP to add, update and delete using student database
      4. Create a DTD to describe a library. Library has one or more books, members and staffs.
      • Each book has BookID(Attribute), Title, one or more Authors, Publisher Year of Publication, ISBN and Price.
      • Each Member has MemeberID(Attribute), Name, Address, Phone number.
      • Each Staff has StaffID(Attribute), Name, Address, Phone number.
      • Each Author has AuthorID(Attribute), Name, Address, Phone number.
      • Each Publisher has PublisherID(Attribute), Name, Address, Phone number.
      • Use it in a XML document.
      1. Create a DTD to describe a Computer. A computer has following details,
        • Type of computer (this is an attribute), Which can be Desktop PC, Laptop, Palm Top, Server, Minicomputer or mainframe)
      • A Monitor with Serial Number (Attribute), Make, Model, Year of manufacture, Size, Type (which is either colour or monochrome)
      • A keyboard with Serial Number (Attribute), Make, Model, Year of manufacture, No of keys, Type( which is either Standard or Enhanced or Multimedia)
      • A mouse with Serial Number (Attribute), Make, Model, Year of manufacture, No of buttons, Scroll wheel (which is yes or no), Type (Which is Ball or Optical)
      • A Mother board with Serial Number (Attribute), Make, Model, Year of manufacture, No of USB ports, No of IDE slots, No of SATA hubs, No of PCI slots, Display Type(Which is VGA or  HDMI), Number of Processor slots, Type of Processors supported (must be a list), Type of RAM supported (Which is either SD or DDR1 or DDR2 or RD), Maximum Capacity of RAM, Form Factor (which is either AT or Baby AT), On Board sound card (Which is yes or no)
      • A Microprocessor with Serial Number (Attribute), Make, Model, Year of manufacture, speed (in GHz), No of Cores (Single, Dual, Quad)
      • A power supply with Serial Number (Attribute), Make, Model, Year of manufacture, Type (AT, ATX), Wattage
      • One or more hard disks, each Hard disk must have Serial Number (Attribute), Make, Model, Year of manufacture, capacity and type (Which is IDE or SATAI or SATAII, SCSI)
      • One or more RAM SIMM, with Serial Number (Attribute), Make, Model, Year of manufacture, Type (which must be SD, DDRI, DDRII, RD), capacity, operating frequency.

Use it in a XML document.

      1. Create a Schema to describe a Computer. Use the previous question’s details and show an instance XML document.
      2. Create a Schema to describe a library. Library has one or more – books, members and staffs.
      • Each book has BookID(Attribute), Title, one or more Authors, Publisher Year of Publication, ISBN and Price.
      • Each Member has MemeberID(Attribute), Name, Address, Phone number.
      • Each Staff has StaffID(Attribute), Name, Address, Phone number.
      • Each Author has AuthorID(Attribute), Name, Address, Phone number.
      • Each Publisher has PublisherID(Attribute), Name, Address, Phone number.

Use the above DTD in a sample XML document.

      1. Create a DTD to describe a bank that has one or more customers, accounts or Employee.
      • Each Customer has a Customer ID, Name and address.
      • Each account has an account ID, BranchID, CustomerID, AccountType and Balance.
      • Each Employee has aEmpID, Name, Designation, DOJ, Salary and Address.

Use this DTD in a XML file.

      1. Create Schema describe a bank that has one or more customers, accounts or depositors. Use the previous questions details. Also show a sample instance XML document.

COMPUTER CENTER

Name of the Lab: COMPUTER CENTER

Lab In-charge: N.SIVA NAGAMANI

Programmer: B.SUDHEER

Lab Configuration:

PROCESSOR : Intel P4

RAM : 1GB

HDD : 160 GB

MONITOR : ViewSonic 17” inch

Part A: Computer Programming

Description of the Lab: Implementation of arrays, control structures, pointers, unions and files and Implementation of Linear and non Liner data structures, searching and sorting techniques

Objectives:

Learn C Programming language

To make the student solve problems, implement algorithms using C language.

List of Experiments:

      1. Practice DOS and LINUX Commands necessary for design of C Programs.
      2. Study of the Editors, Integrated development environments, and Compilers in chosen platform.
      3. Write, Edit, Debug, Compile and Execute Sample C programs to understand the programming environment.
      4. Practice programs: Finding the sum of three numbers, exchange of two numbers, maximum of two numbers, To read and print variable values of all data types of C language, to find the size of all data types, to understand the priority and associativity of operators using expressions, to use different library functions of C language.
      5. Write a program to find the roots of a Quadratic equation.
      6. Write a program to compute the factorial of a given number.
      7. Write a program to check whether the number is prime or not.
      8. Write a program to find the series of prime numbers in the given range.
      9. Write a program to generate Fibonacci numbers in the given range.
      10. Write a program to find the maximum of a set of numbers.
      11. Write a program to reverse the digits of a number.
      12. Write a program to find the sum of the digits of a number.
      13. Write a program to find the sum of positive and negative numbers in a given set of numbers.
      14. Write a program to check for number palindrome.
      15. Write a program to evaluate the sum of the following series up to n terms e x=1+x+x2/2!+x3/3!+x4/4!+-
      16. Write a program to generate Pascal Triangle.
      17. Write a program to read two matrices and print their sum and product in the matrix form.
      18. Write a program to read matrix and perform the following operations.
      19. Find the sum of Diagonal Elements of a matrix.
      20. Print Transpose of a matrix. Print sum of even and odd numbers in a given matrix.
      21. Write a program to accept a line of characters and print the number of Vowels, Consonants, blank spaces, digits and special characters.
      22. Write a program to insert a substring in to a given string and delete few characters from the string. Don‟t use library functions related to strings.
      23. Write a program to perform the operations addition, subtraction, multiplication of complex numbers.
      24. Write a program to split a „file‟ in to two files, say file1 and file2. Read lines into the „file‟ from standard input. File1 should consist of odd numbered lines and file2 should consist of even numbered lines.
      25. Write a program to merge two files.
      26. Write a program to implement numerical methods Lagrange‟s interpolation, Trapezoidal rule.
      27. Write a program to read a set of strings and sort them in alphabetical order.
      28. Write a program to read two strings and perform the following operations without using built-in string Library functions and by using your own implementations of functions.

i.string length determination ii .Compare Two Strings

iii. Concatenate them, if they are not equal         iv. String reversing

      1. Write programs using recursion for finding Factorial of a number, GCD, LCM, and solving Towers of Hanoi problem.
      2. Write a program to exchange two numbers using pointers.
      3. Write a program to read student records into a file. Record consists of rollno, name and marks of a student in six subjects and class. Class field is empty initially. Compute the class of a student. The calculation of the class is as per JNTUA rules. Write the first class, second class, third class and failed students lists separately to another file.
      4. A file consists of information about employee salary with fields employeeid, name, Basic, HRA, DA, IT, other-deductions, Gross and Net salary. Initially only employeeid, name, and basic have valid values. HRA is taken as 10% of the basic, DA is taken as 80% of basic, IT is 20% of the basic, other deductions is user specified. Compute the Gross and Net salary of the employee and update the file.
      5. Write a program to perform Base (decimal, octal, hexadecimal, etc) conversion.
      6. Write a program to find the square root of a number without using built-in library function.
      7. Write a program to convert from string to number.
      8. Write a program to implement pseudo random generator.
      9. Write a program to generate multiplication tables from 11 to 20.
      10. Write a program to express a four digit number in words. For example 1546 should be written as one thousand five hundred and forty six.
      11. Write a program to generate a telephone bill. The contents of it and the rate calculation etc should be as per BSNL rules. Student is expected to gather the required information through the BSNL website.
      12. Write a program to find the execution time of a program.
      13. Design a file format to store a person’s name, address, and other information. Write a program to read this file and produce a set of mailing labels

Part B: DATA STRUCTURES LAB

Course Objectives:

To strengthen the ability to identify and apply the suitable data structure for the given real world problem

Course Outcomes:

Apply problem solving techniques to find solutions to problems

Able to identify the appropriate data structure for a given problem or application.

Improve logical skills

List of Experiments/Tasks

      1. Write a program to sort the elements of an array using sorting by exchange.
      2. Write a program to sort the elements of an array using Selection Sort.
      3. Write a program to implement heap sort.
      4. Write a program to perform Linear Search on the elements of a given array.
      5. Write a program to perform Binary Search on the elements of a given array.
      6. Write a program to convert infix expression to postfix expression and evaluate postfix expression.
      7. Write a program to implement stack, queue, circular queue using arrays and linked lists.
      8. Write a program to perform the operations creation, insertion, deletion, and traversing a singly linked list.
      9. Write a program to perform the operations creation, insertion, deletion, and traversing a Doubly linked list.
      10. Write a program to remove duplicates from ordered and unordered
      11. Write a program to sort numbers using insertion sort.
      12. Write a program to implement quick sort using non-recursive and recursive approaches. Use randomized element as partitioning element.
      13. Write a program to search a word in a given file and display all its positions.
      14. Write a program for tic-tac-toe game.
      15. Write a program to perform operations creation, insertion, deletion and traversing on a binary search tree.
      16. Write a program to implement depth first search and breadth first search on graphs.
      17. Write a program to perform different operations on Red Black trees.
      18. Write a program to implement external sorting.
      19. Write a program to perform different operations of B Tree.

DATA MINING & MAP REDUCE PROGRAMMING LAB

Name of the Lab: DATA MINING & MAP REDUCE PROGRAMMING LAB

Lab Incharge : Mrs. K.Sukeerthi

Programmer : Mr. Ravi

Lab Configuration:

PROCESSOR : Intel Pentium

RAM : 4GB

HDD : 500 GB

MONITOR : Dell 19.5″ inch

MAP REDUCE PROGRAMMING LAB

Description of the Lab:

Objectives:

  1. Getting familiar with Hadoop distributions, configure Hadoop and perform File Management Tasks
  1. To understand Map Reduce in Hadoop works
  2. To implement Map Reduce programs
  3. Understanding Map Reduce support for debugging
  4. Understanding new approaches for building Hadoop Map Reduce programs for real-time applications

Outcomes:

  1. Configure Hadoop and perform File Management Tasks
  2. Applying Map Reduce programs to real time issues like word count, weather dataset and sales of a company
  1. Critically analyze huge data set using hadoop distributed file systems and mapreduce programs

List of Experiments:

  1. Install Apache Hadoop
  2. Write a map reduce program to calculate the frequency of a given word in a given file?
  1. Write a Map Reduce program to find the maximum temperature in each year?
  1. Write a Map Reduce program to find the grades of student’s?
  2. Write a map reduce program to implement Matrix Multiplication?
  3. Write a map reduce to find the maximum electrical consumption in each year given electrical consumption for each month in each year?
  1. Write a map reduce to analyze weather data set and print whether the day is shinny or cool day?
  1. Write a map reduce program to find the number of products sold in each country by considering sales data containing fields like
  1. Write a map reduce program to find the tags associated with each movie by analyzing movielens data?

Transaction date Product Price Payment

Type Name City State Country Account Created

Last Login Latitude Longitude

  1. XYZ.com is an online music website where users listen to various tracks, the data gets collected like shown below.

The data is coming in log files and looks like as shown below.

UserId | TrackId | Shared | Radio |Skip

111115 | 222 | 0 | 1 | 0

111113 | 225 | 1 | 0 | 0

111117 | 223 | 0 | 1 | 1

111115 | 225 | 1 | 0 | 0

Write a map reduce program to get the following

  • Number of unique listeners
  • Number of times the track was shared with others
  • Number of times the track was listened to on the radio
  • Number of times the track was listened to in total
  • Number of times the track was skipped on the radio
  1. Write a map reduce program to find the frequency of books published each year and find in which year maximum number of books were published using the following data?

Title Author Published year Author country Language No of pages

  1. Write a map reduce program to analyze Titanic data and to find The average age of the people (both male and female) who died in the

tragedy How many persons survived – traveling class wise.

The titanic data will be..

Column 1 : PassengerId Column 2 : Survived (survived=0 & died=1)

Column 3 : Pclass Column 4 : Name Column 5 : Sex

Column 6 : Age Column 7 : SibSp Column 8 : Parch

Column 9 : Ticket Column 10 : Fare Column 11 : Cabin

Column 12 : Embarked

  1. Write a map reduce program to analyze Uber data set to find the days on which each basement has more trips using the following dataset . The Uber dataset consists of four columns they are

dispatching_base_number, date, active_vehicles and trips.

DATA WAREHOUSING AND MINING LABORATORY

Description of the Lab:

Course Objectives:

Learn how to build a data warehouse and query it (using open source tools like Pentaho Data Integration and Pentaho Business Analytics), Learn to perform data mining tasks using a data mining toolkit (such as open source WEKA), Understand the data sets and data preprocessing, Demonstrate the working of algorithms for data mining tasks such association rule mining, classification, clustering and regression, Exercise the data mining techniques with varied input values for different parameters.

Course Outcomes:

  • Ability to build Data Warehouse and Explore WEKA
  • Ability to perform data preprocessing tasks and Demonstrate performing
  • association rule mining on data sets
  • Ability to perform classification, clustering and regression on data sets
  • Ability to design data mining algorithms

List of Experiments:

Build Data warehouse

  • Identify source tables and populate sample data
  • Design multi-dimensional data models for sales data
  • Implementing ETL Scripts to perform operations on Data warehouse
  • Implementing various OLAP operations
  • Exploring visualization features for data analysis

WEKA data mining

  • Perform data preprocessing tasks
  • Demonstrate performing classification on data sets
  • Demonstrate performing clustering on data sets
  • Demonstrate performing Regression on data sets

Task 1    Credit Risk Assessment: German credit data

  1. List of categorical attributes and the real-valued attributes
  2. Identify crucial attributes
  3. Train a decision tree
  4. Test on classification of decision tree
  5. Testing on training set
  6. Train a decision tree using cross-validation
  7. Check the accuracy by removal of foreign workers and personal status attributes
  8. Check the accuracy by removal of 2,3,5,7,10,17 attributes
  9. Calculate cost matrix
  10. Comparison of simple and long complex decision trees
  11. Reduced error pruning to train decision trees
  12. Convert decision trees into “if-then-else rules”

Task 2    Design the Hospital Management system data warehouse using all schemas. Give the example     4-D cube with assumption names.

DATABASE MANAGEMENT SYSTEMS LABORATORY

Name of the Lab: DATABASE MANAGEMENT SYSTEMS LABORATORY

Lab In charge : Mr. K.SREENIVAS

Programmer : Mrs. P.CHANDRAKALA

Lab Configuration:

PROCESSOR : Intel Dual Core

RAM : 1GB

HDD : 250GB

MONITOR : Acer 17″ inch

Course Objectives:

  • To create a database and query it using SQL, design forms and generate reports.
  • Understand the significance of integrity constraints, referential integrity

constraints, triggers, assertions.

Course Outcomes:

  • Design databases
  • Retrieve information from data bases
  • Use procedures to program the data access and manipulation
  • Create user interfaces and generate reports

List of Experiments:

  1. Practice session: Students should be allowed to choose appropriate DBMS software, install it, configure it and start working on it. Create sample tables, execute some queries, use SQLPLUS features, use PL/SQL features like cursors on sample database. Students should be permitted to practice appropriate User interface creation tool and Report generation tool.
  1. A college consists of number of employees working in different departments. In this context, create two tables employee and department. Employee consists of columns empno, empname, basic, hra, da, deductions, gross, net, date-of-birth. The calculation of hra,da are as per the rules of the college. Initially only empno, empname, basic have valid values. Other values are to be computed and updated later. Department contains deptno, deptname, and description columns. Deptno is the primary key in department table and referential integrity constraint exists between employee and department tables. Perform the following operations on the the database:
  • Create tables department and employee with required constraints.
  • Initially only the few columns (essential) are to be added. Add the remaining columns separately by using appropriate SQL command
  • Basic column should not be null
  • Add constraint that basic should not be less than 5000.
  • Calculate hra,da,gross and net by using PL/SQL program.
  • Whenever salary is updated and its value becomes less than 5000 a trigger has to be raised preventing the operation.
  • The assertions are: hra should not be less than 10% of basic and da should not be less than 50% of basic.
  • The percentage of hra and da are to be stored separately.
  • When the da becomes more than 100%, a message has to be generated and with user permission da has to be merged with basic.
  • Empno should be unique and has to be generated automatically.
  • If the employee is going to retire in a particular month, automatically a message has to be generated.
  • The default value for date-of-birth is 1 jan, 1970.
  • When the employees called daily-wagers are to be added the constraint that salary should be greater than or equal to 5000 should be dropped.
  • Display the information of the employees and departments with description of the fields.
  • Display the average salary of all the departments.
  • Display the average salary department wise.
  • Display the maximum salary of each department and also all departments puttogether.
  • Commit the changes whenever required and rollback if necessary.
  • Use substitution variables to insert values repeatedly.
  • Assume some of the employees have given wrong inf
  • The retirement age is 60 years. Display the retirement day of all the employees.
  • If salary of all the employees is increased by 10% every year, what is the salary of all the employees at retirement time.
  • Find the employees who are born in leap year.
  • Find the employees who are born on feb 29.
  • Find the departments where the salary of atleast one employee is more than20000.
  • Find the departments where the salary of all the employees is less than 20000.
  • On first January of every year a bonus of 10% has to be given to all the employees. The amount has to be deducted equally in the next 5 months.Write procedures for it.
  • As a designer identify the views that may have to be supported and createviews.
  • As a designer identify the PL/SQL procedures necessary and create them using cursors.

Use appropriate Visual programming tools like oracle forms and reports, visual basic etc to create user interface screens and generate reports.

Note: As a designer identify other operations that may be required and add to the above list. The above operations are not in order. Order them appropriately. Use SQL or PL/SQL depending on the

requirement.

  1. Students may be divided into batches and the following experiments may be given to them to better understand the DBMS concepts. Students should gather the required

information, draw ER diagrams, map them to tables, normalize, create tables, triggers, procedures, execute queries, create user interfaces, and generate reports.

  • Student information system
  • APSRTC reservation system
  • Hostel management
  • Library management
  • Indian Railways reservation
  • Super market management
  • Postal system
  • Banking system
  • Courier system
  • Publishing house system

ENGINEERING IT WORKSHOP

Name of the LAB:  I.T. WORKSHOP

Lab Incharge: Mr.K.Venkata Nagendra

Programmer: Mr.D.Ramesh

Description of the Lab:

This lab is used to disassemble and assemble a Personal Computer and prepare the computer ready to use.  The students prepare the Documents using Word processors and Prepare Slide presentations using the presentation tool. It also provides knowledge about accessing internet and Browsing.

Course Objectives:

  • To provide Technical training to the students on Productivity tools like Word processors, Spreadsheets, Presentations
  • To make the students know about the internal parts of a computer, assembling a computer from the parts, preparing a computer for use by installing the operating system
  • To learn about Networking of computers and use Internet facility for Browsing and Searching.

Course Outcomes:

  • Able to learn about the internal and external parts of system
  • Ensure that the sound knowledge about the MS-office for real time use.
  • Able to browse different concepts using internet.

List of Experiments:

Task-1. Learn about Computers.

Task-2. Assembling a Computer.

Task-3. Install Operating system.

Task-4. Operating System features.

Task- 5. Networking

Task-6. Browsing Internet

Task-7. Antivirus

Task-8. Word Processor

Task-9. Spread sheet

Task-10. Presentations

Task-11. Laboratory Equipments