Hardware

Software

4 GB RAM

Notepad

256 GB SSD / 500 GB HDD

Vs Code

​

Net Beans

​

Xampp

​

Dev C++

​

SQL / PostgreSQL/ Oracle

​

​

Name of Subject:

MCAP103: PHP (Sem-I)

LAB COURSE OUTCOME

CO1

Understand basic PHP syntax for variable use and standard language constructs, such as conditionals and loops.

CO2

Understand the syntax and working with concept different concepts of functions.

CO3

Understand the paradigm for dealing with form-based data, both from the syntax of HTML forms, and how they

are accessed inside a PHP-based script.

CO4

Understand to deal with Error handling, file type processing and state management as well as processing images.

CO5

Developing and understanding the working MYSQL and Database Connectivity.

Sr. No.

Experiments List (PHP)

1

Write a program using Conditional Structure.

2

Write a program using array which accepts five values and print the values.

3

Write a program using Looping Structure with concept of Functions

4

Write a program in PHP for type casting of a variable

5

Write a program in PHP to display Multiplication Table using nested for loop

6

Write a program In PHP to Sort an array using Bubble Sort function

7

Design the personal information form, submit and retrieve the form data using php

$_POST, $_GET, $ REQUEST variable

8

Study of Cookies and Session In PHP

9

Study Of Mysql DDL, DML, DCL Commands

10

Design Login Form and Validate that form using PHP Code

Sr. No.

Experiments List - Content Beyond the Syllabus (PHP)

1

Write a PHP code to create database & table in Mysql

2

Write a PHP code to insert, delete, select the data from database

3

Design a from which upload & Display image in PHP

4

Write a PHP Code to make database connection, Create Data Base, Create Table In Mysql

5

Write a PHP code Insert, Delete, Update, Select the Data From Data Base

Name of Subject:

MCAP105: OOPs Using JAVA (Sem-I)

LAB COURSE OUTCOME

CO1

Understand the programming entities like Variables, Operators, Inheritance, Packages and Tokens.

CO2

Implement exception handling and Thread Programming.

CO3

Develop application using AWT components and apply Event handling.

CO4

Implement JDBC-ODBC, TCP/IP, RMI.

CO5

Implement Servlet and JSP.

Sr. No.

Experiments List (JAVA)

1

Write a program in Java to create a class for employee record with two constructor, first default constructor to initialize all variables, second constructor to accept the employee details and a method to display employee details.

2

Write a program in Java that has Boolean function returning a string to display whether it is a leap year or not.

3

Write a program in Java that creates an abstract class called Shape. Create subclasses that calculate and displays area of rectangle and triangle.

4

Write a program in Java to accept values for multithread.

5

Write a Program to demonstrate multiple inheritance through interface.

6

Write a Program to illustrate exception using multiple catch statement.

7

Write a Java Program to create Lamp using applet.

8

Write a Program to create an application which shows the menu.

9

Write a Java Program for creation of input dialog box.

10

Create an application to retrieve information(author id, name, address, city) about the author who living in the city where the city name begins with the letter “n”.

Sr. No.

Experiments List - Content Beyond Syllabus (JAVA)

1

Write a Program to Delete Record from Employee Table Whose Salary is greater than 20000.

2

Write a program to reading servlet parameter.

3

Write a program in java to insert product information in product table using html and jsp. Following is Product.html :

​

register reset+

​

4

Write a program to creating a application using JavaBeans.

Name of Subject:

MCAP202: C#.NET (Sem-II)

LAB COURSE OUTCOME

CO1

Describe the purpose of C#, and explain how to use Microsoft Visual C# and Visual Studio to build .NET Framework applications.

CO2

Describe the syntax of basic C# programming constructs.

CO3

Describe how to create and call methods, and explain Struct, Enum, Arrays and String

CO4

Describe how to catch, handle, and throw exceptions

CO5

Describe how to perform basic file I/O operations in a Visual C# application C

Sr. No.

Experiments List (C#.NET)

1

Write a program in Console application and windows application in c# to check whether the number is prime or not

2

Write a program in Console application and windows application in c#to find whether the number is Armstrong or not

3

Write a program in Console application in c# to demonstrate the difference between prefix and postfix forms of ++.

4

Write a program in Console application in c# to draw the structure

*

* *

* * *

* * * *

* * * * *

5

Write a program in Console application in c# to demonstrate passing structure to function

i) Pass by value ii)Pass by reference

6

Write a program in Console application in c# to calculate volume of cube, cylinder and square box by using concept of method function overloading

Sr. No.

Experiments List (C#.NET)

7

Write a program in Console application in c# to sort the list of numbers using an array.

8

Write a program in Console application in c# to illustrate the concept of method Overriding

9

Write a program in Console application in c# to use multiple implementation of an interface.

10

Write a program in Console application in c# to demonstrate jagged array.

Sr. No.

Experiments List- Content Beyond Syllabus (C#.NET)

1

Write a program in Console application in c# for boxing an unboxing.

2

Write a program in Console application in c# how to implement delegates.

3

Design a windows form in c# to calculate addition, subtraction, multiplication, division of two numbers

4

Design a windows form in c# to create an employee registration form, insert a record, delete a record, and update a record with using a connection string using SQL Server.

5

Design a windows form in c# to implement date picker to accept date of birth and display the current age.

Name of Subject:

MCAP203: ORACLE and PL/SQL (Sem-II)

LAB COURSE OUTCOME

CO1

 Understanding basic database security and object privileges.

CO2

Using the powerful set of built-in SQL functions.

CO3

Protecting the database and extending the basic data model using declarative constraints.

CO4

Performing advanced SQL queries such as grouping and Join, Sub queries, PL/SQL Blocks, functions.

CO5

Use the PL/SQL code constructs of IF-THEN-ELSE and LOOP types as well as

syntax and command functions.

Sr. No.

Experiments List (ORACLE and PL/SQL)

1

Create a table called Employee with the following structure.

Name Type

Empno Number

Ename Varchar2(20)

Job Varchar2(20)

Mgr Number

Sal Number

Add a column commission with domain to the Employee table.

Insert any five records into the table.

Update the column details of job

Rename the column of Employ table using alter command.

Delete the employee whose empno is 19.

Sr. No.

Experiments List (ORACLE and PL/SQL)

2

Create department table with the following structure.

Name Type

Deptno Number

Deptname Varchar2(20)

location Varchar2(20)

Add column designation to the department table.

Insert values into the table.

List the records of emp table grouped by deptno.

Update the record where deptno is 9.

Delete any column data from the table

Sr. No.

Experiments List (ORACLE and PL/SQL)

3

Create a table called Customer table

​

​

​

​

​

Insert records into the table.

Add salary column to the table.

Alter the table column domain.

Drop salary column of the customer table.

Delete the rows of customer table whose cust_city is “hyd‟.

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

4

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

5

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

6

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

7

QUERIES USING DDL AND DML

1. Create a user and grant all permissions to the user.
2. Insert the any three records in the employee table and use rollback. Check the result.
3. Add primary key constraint and not null constraint to the employee table.
4. Insert null values to the employee table and verify the result.
5. Insert null values to the employee table and verify the result.

​

​

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

8

1. Create a user and grant all permissions to the user.
2. Insert values in the department table and use commit.
3. Add constraints like unique and not null to the department table.
4. Insert repeated values and null values into the table.

9

a. Create a user and grant all permissions to the user.

b. Insert values into the table and use commit.

c. Delete any three records in the department table and use rollback.

d. Add constraint primary key and foreign key to the table

​

10

a. Create a user and grant all permissions to the user.

b. Insert records in the sailor table and use commit.

c. Add save point after insertion of records and verify save point.

d. Add constraints not null and primary key to the sailor table.

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

11

1. Create a user and grant all permissions to the user.
2. Use revoke command to remove user permissions.
3. Change password of the user created.
4. Add constraint foreign key and not null.

12

1. Create a user and grant all permissions to the user.
2. Update the table reserves and use save point and rollback.
3. Add constraint primary key , foreign key and not null to the reserves table
4. Delete constraint not null to the table column.

​

Sr. No.

Experiments List (ORACLE and PL/SQL)

13

QUERIES USING AGGREGATE FUNCTIONS

​

1. By using the group by clause, display the enames who belongs to deptno 10 along with average salary
2. Display lowest paid employee details under each department.
3. Display number of employees working in each department and their department number.
4. Using built in functions, display number of employees working in each department and their department name from dept table. Insert deptname to dept table and insert deptname for each row, do the required thing specified above.
5. List all employees which start with either B or C.
6. Display only these ename of employees where the maximum salary is greater than or equal to 5000.

Sr. No.

Experiments List (ORACLE and PL/SQL)

14

1. Calculate the average salary for each different job.
2. Show the average salary of each job excluding manager.
3. Show the average salary for all departments employing more than three people.
4. Display employees who earn more than the lowest salary in department 30
5. Show that value returned by sign (n) function.
6. How many days between day of birth to current date.

15

1. Show that two substring as single string.
2. List all employee names, salary and 15% rise in salary.
3. Display lowest paid emp details under each manager
4. Display the average monthly salary bill for each deptno.
5. Show the average salary for all departments employing more than two people.
6. By using the group by clause, display the eid who belongs to deptno 05 along with average salary.

Sr. No.

Experiments List- Content Beyond the Syllabus (ORACLE and PL/SQL)

1

a. Count the number of employees in department 20

b. Find the minimum salary earned by clerk.

c. Find minimum, maximum, average salary of all employees.

d. List the minimum and maximum salaries for each job type.

e. List the employee names in descending order.

f. List the employee id, names in ascending order by empid.

2

a. Find the sids ,names of sailors who have reserved all boats called “INTERLAKE

b. Find the age of youngest sailor who is eligible to vote for each rating level with at least two such sailors.

c. Find the sname , bid and reservation date for each reservation.

d. Find the ages of sailors whose name begin and end with B and has at least 3 characters.

e. List in alphabetic order all sailors who have reserved red boat.

f. Find the age of youngest sailor for each rating level

3

1. List the Vendors who have delivered products within 6 months from order date.
2. Display the Vendor details who have supplied both Assembled and Sub parts.
3. Display the Sub parts by grouping the Vendor type (Local or Non-Local).
4. Display the Vendor details in ascending order.
5. Display the Sub part which costs more than any of the Assembled parts.
6. Display the second maximum cost Assembled part.

​

Sr. No.

Experiments List – Content Beyond the Syllabus (ORACLE and PL/SQL)

4

PROGRAMS ON PL/SQL

1. Write a PL/SQL program to swap two numbers.
2. Write a PL/SQL program to find the largest of three numbers.
3. Write a PL/SQL program to find the total and average of 6 subjects and display the grade.
4. Write a PL/SQL program to find the sum of digits in a given number.
5. Write a PL/SQL program to display the number in reverse order.
6. Write a PL / SQL program to check whether the given number is prime or not.
7. Write a PL/SQL program to find the factorial of a given number.
8. Write a PL/SQL code block to calculate the area of a circle for a value of radius varying from 3 to 7. Store the radius and the corresponding values of calculated area in an empty table named areas, consisting of two columns radius and area.
9. Write a PL/SQL program to accept a string and remove the vowels from the string. (When „hello‟ passed to the program it should display „Hll‟ removing e and o from the world Hello).

Name of Subject:

MCAP303: Python Programming (Sem-III)

LAB COURSE OUTCOME

CO1

 Understanding Examine Python syntax and semantics and be fluent in the use of Python flow control and functions.

CO2

Demonstrate proficiency in handling Strings and File Systems

CO3

Create, run and manipulate Python Programs using core data structures like Lists, Dictionaries and use Regular Expressions

CO4

Interpret the concepts of Object-Oriented Programming as used in Python

CO5

Implement exemplary applications related to Network Programming, Web Services and Databases in Python

Sr. No.

Experiments List (Python Programming)

1

Create a list and perform the following methods

2

Write a python program to add two numbers.

3

Write a program to create a menu with the following options 1. TO PERFORM ADDITITON 2.TOPERFORM SUBTRACTION 3. TO PERFORM MULTIPICATION 4. TO PERFORM DIVISION Accepts users input and perform the operation accordingly. Use functions with arguments.

4

Write a program to double a given number and add two numbers using lambda()?

5

Demonstrate a python code to implement abnormal termination?

6

Write a python program to get python version

7

Write a python program to print date, time for today and now.

8

Write a python Program to display welcome to MRCET by using classes and objects

9

Using a numpy module create an array and check the following: 1. Type of array 2. Axes of array 3. Shape of array 4. Type of elements in array

10

Write a python program to concatenate the dataframes with two different objects.

Sr. No.

Experiments List- Content Beyond Syllabus (Python Programming)

1

Write a python code to set background color and pic and draw a circle using turtle module

2

Write a Python program to find first n prime numbers.

3

Write a Python program to multiply matrices

4

Write a Python program to find the exponentiation of a number.

5

Using a for loop, write a program that prints out the decimal equivalents of ½+1/3+1/4+. . . , 1/10

Name of Subject:

MCAP309: Big Data With R (Sem-III)

LAB COURSE OUTCOME

CO1

 Understand the basic principles of Big Data Analysis, its technologies and challenges.

CO2

Demonstrate the Big Data technology foundation and how to store data in data ware houses.

CO3

Understanding analytical approaches and tools to analyze data and develop Big Data Solutions using R

CO4

Identify the processing of data in R and how to work with functions and packages in R and Graphical Analysis in R.

CO5

Study how data visualization techniques works and about Mobile Analytics tools and challenges

Sr. No.

Experiments List (Big Data With R)

1

Write an R-Program to demonstrate working with Arithmetic operators

2

Write an R Program to Find the Factorial of a Number

3

Write an R Program to Make a Simple Calculator

4

Write an R Program to create a Matrix and access rows and columns using functions colnames() and rownames() .

5

Write an R Program to create a Matrix using cbind() and rbind() functions.

6

Write an R Program to create a Matrix from a Vector using dim() function.

7

Write an R Program to create a List and modify its components.

8

Write an R Program to create a Data Frame.

Sr. No.

Experiments List – Content Beyond Syllabus (Big Data With R)

1

Write an R Program to access a Data Frame like a List.

2

Write an R Program to access a Data Frame like a Matrix.

​

​

​

​