Kuvempu University BSC IT (3Rd,4th,5th And 6th SEMESTER Practical Paper )

BSIT 3P

B.Sc.(IT)3^rd Semester

Assignment Questions

Subject :OOPs with C++ And RDBMS

(Answer any 3 of your choice)

Set -1

1.      Using C++ , design and implement a class COMPLEX having the following functionality:

a) allows representation of complex numbers

b) allows addition of two complex numbers

c) has overloading constructors and a copy constructor

d) allows assignment of one complex number to another

2.      A software company has the following information about its clients and the projects given by them:

Clients (client number, client name, address)

Projects(project  number, project name, total investment, no. of people working on the project)

Client project(client number, project number, date of start of project)

Create a database with the tables given above. Give suitable field names, keys and validation  checks. Create  data entry forms and enter at least 10 rows.

Run the following queries on the above database:

a)      List clients who have assigned more than 2 projects to the software company.

b)      List clients in order of decreasing total project investment.

c)      Show the details of the project  with the maximum number of people working on the it.

 

Set -2

1.      An EMPLOYEE class contains the following members:

Data members: employee_number, employee_name, basic pay, allowance, income tax, net salary

Member functions: to read the data, to calculate net salary and to print data members

Write a C++ program to read the data of 5 employees and compute the net salary of each employee given that the allowance is 20% of the basic pay and income tax is 30% of the gross salary (basic pay+allowance)

2.      Design data entry forms for the above tables with suitable validations and enter atleast 10 rows.

      Execute the following queries:

a)         List the names and telephone numbers of  all the customers

b)      List the movie types available in the movie table.

c)      List the information about customers who have been issued movies in the month of   January

d)     Which is the last movie issued to customer id ‘C001’

e)      List of those customers who have not given phone numbers

f)       Count the total number of customers

g)      List the customers who have been issued movie number 12.

h)      Delete the row with invoice number ‘i10’

Set- 3

1. Write a C++ program to create a class called QUEUE with member functions to add an element and to delete an element from the queue.  Display the contents of the queue after every operation.

2.  An insurance database has the tables given below. The data types are also specfified.

Table name : owner_details

Column name	Format
Owner_id	Char(4)
Name	Varchar(25)
Address	Varchar(40)

 

    Table name : car

Column name	Format
Reg_no	Char(10)
Model	Varchar(15)
Year	Number(4)

    Table name : accident

Column name	Format
Report_no	Number(5)
Acc_date	Date
Location	Varchar(20)

Table name : cars_owners

Column name	Format
Owner_id	Char(4)
Reg_no	Char(10)

Table name : cars_in_accident

Column name	Format
Owner_id	Char(4)
Reg_no	Char(10)
Report_no	Number(5)
Cost_of_damage	Number(5)

a)  Create the above table with proper primary and foreign keys.

b) Enter at least 5 tuples for each relation     

c) Update the cost of damage for a particular car involved in an accident with report

    number 25 to 30000.

d) Add a new car to the database

e) Add a new accident to the database

f) List the car owners whose cars were involved in accidents in the year 2006

g) Find the number of accidents in which cars of a particular model were involved

h) generate suitable reports

Set-4

1.      Write a C++ program to create a class called STRING and do the following operations. Show the results after every operation by overloading the operator <<. Use copy constructor.

STRING s1 = “KUVEMPU”

STRING s2 = “UNIVERSITY”

STRING s3 = s1+s2

2.      A book dealer has the following database:

Author(author_id:interger, author_name:string, city:string, country:string)

Publisher(publisher_id:integer,name:string, city:string, country:string)

Catalog(book_id:integer, title:string, author_id:integer, publisher_id:integer,

              year:integer, price:integer)

order_details(order_id:integer, book_id:integer, quantity:integer)

a) Create the tables specified above with suitable primary and foreign keys

b) Create data entry forms and enter at least 5 rows in each table with suitable

     validations

c) Find the author of the book which has the maximum sales

d) List the details of the authors who have two or more books in the catalog

e) List all the books in the catalog that have the word ‘COMPUTER’ in their titles

f) Add a new order to the database.

Set-5

1. Write a C++ program to create a class called DATE. Accept two valid dates in the form dd/mm/yyyy. Implement  the following operations by overloading the operators + and -. After every operation show the results by overloading the operator <<:

a) ndays = d1 – d2; where d1 and d2 are DATE objects, d1>=d2 and ndays is an

   integer.

b) d2 = d1 + ndays; where d1 is a DATE object and ndays is an integer.

2. An order processing database application in a company has the following tables:

Customer(cust_id:integer, cust_name:string, cust_city:string)

Order(order_id:integer, order_date:date, cust_id:integer, order_amount:real)

Items_ordered(order_id:integer, item_no:integer, quantity:integer)

Item(item_no:integer, unit_price:real)

Shipment(order_id:integer, warehouse_no:integer, date_shipped:date)

Warehouse(warehouse_no:integer, city:string)

a) Create the tables given above with proper primary and foreign key specifications

b) Design data entry forms with proper validations and enter at least 5 rows in each

    table

c) List the customer names with their  total number of orders and  the average

    order amount

d) List the orders that were shipped from all the warehouses that the company has in a

    particular city

e) Delete item number 15 from the item table and make that column null in the

    items_ordered table.

f) Design suitable reports

  For Solution On this question please Ask Ca.rudra@ymail.com 

 BSIT 4P

B.Sc.(IT)4^th  Semester

Assignment Questions

Subject :UNIX & Shell Programming And JAVA Programming

(Answer any 7 of your choice)

Set -1

1. Use the echo command to display the line

        

            UNIX is fun to learn

Redirect the displayed line to a file. Append the outputs of the commands to show the users logged into your system,  your login account and the current date in the dd-mm-yyyy format to the file.

2.      Write a program to print  “ Welcome to Java Programming”  on the screen

Set -2

1. Assuming you have a directory containing the following files:

      sprite, cola, choco, orange, book, lemon, lotus, apple

     

       use the ls command to list only those files that

       a) consist of four letters

       b) begin with the letter c

       c) end with the letter e

       d) have the second letter o

2.      Write a program to check whether the given two numbers are equal. If not then find the greater of the given two numbers.

Set -3

1.      For a file named myfile in the working directory, do the following:

a) give everyone permission to read myfile. No other privilege is to be changed

b) allow the owner and group members to read and write the file. All privileges are

    to be removed for everyone else.

c) remove write privileges from everyone except the owner

d) allow the owner and group members to execute myfile and give only the owner

    permission to read or write to it.

2.      Using switch and case statements write a program to add, subtract , multiply and divide the two numbers

Set -4

1.      For a directory myfolder in your working directory, do the following:

a) allow everyone to list files in myfolder. No other privileges are to be changed.

b) allow the owner to and group members to list, remove or add files. All privileges

    are to be removed from everyone else.

c) give write privileges to everyone except the owner

d) allow the owner and group members to execute myfolder. Only the owner gets

    read or write permission.

2.      Using for loop write a program to print the table of a given number on the screen.

Set -5

1.      Put a long-running process in the background and check the accuracy of the sleep command.

2. Write a program to find the even sum and the odd sum in the given array

Set -6

1.      The ls command with the –R option lists the files in the specified directory and also subdirectories, if any. Use this with a suitable pip-and-filter arrangement to determine whether a file exists in the account logged in.

2. Write a program to print all the prime numbers between n and m.

Set -7

1.      Write an interactive shell using I/O redirection to accept input from file1, put stdout in file2 and stderr in file3.

2. Write a program to add the two matrices.

Set -8

1.      Write a shell program to extract and sort all the users in the file system. Use the /etc/passwd file as input.

2. Write a class circle which consists of functions getdata() and area(), and also write a main program to create a circle object and to find the area by calling the function area () in circle class and display the result on the screen.

Set -9

1.      Write a shell program to translate the /etc/passwd file into uppercase and translate the “:” delimiter into tab characters.

2. Write a program to demonstrate the method overloading for sum ( ) function.

Set -10

1.      Write a shell program using if-the-else to test whether a variable name is a directory  or a file.

2. Write a program to concatenate two strings

Set -11

1.      Write a shell program in which an infinite loop prompts a user for file names to be removed and remove the files. Use trap to exit when finished.

2. Write a program to find whether a given string is a palindrome or not

Set -12

1.      Write a background command to edit all the files in the directory replacing the word while with until.

2. Write a program to change the case of the given string

Set -13

1.      Write a shell program to test for arguments arg1, arg2 and arg3. If they are not present, prompt the user for them.

2. Write a program to create a thread by extending the thread class

  For Solution On this question please Ask Ca.rudra@ymail.com 

 BSIT 5P

B.Sc.(IT)5^th  Semester

Assignment Questions

Subject : Graphics & Multimedia And Web Programming

(Answer any 7 of your choice)

Set -1

1.    Open a Image. And separate background using selection tool.

2.       Write a JSP page to display the number of hits to this page. (Hint: use application  scope of java bean).

Set -2

1.    Using pencil tool create an image of landscape, and color it with Brush tool.

2.    Create an HTML page containing the following features

1. Create a  login JSP page with username , password and submit button.
2. On submit, display message ‘Thank you for logging in ’ Also create cookies to store username and password.

c.    Open login JSP page on a new browser. If the cookie is present the username and password field  should be automatically populated with the values from the cookie

Set -3

1.    Write a JSP program to display current date and time and suitable welcome message.

§  If time is between 5AM and 12 PM display welcome message as ‘Good Morning’

§  If time is between 12 PM and 5 PM display welcome message as ‘Good Afternoon’

§  After 5PM display message as ‘Good evening’.

2.    Using Rubberstamp tool, create a clone image.

Set -4

1.    Using Gradient tool, create some backgrounds for photos.

2 .Create an HTML page containing the following features

a.    A combo box containing the list of  7 colors: Violet, Indigo, Blue, Green, Yellow, Orange, Red

b.    Depending upon the color selected from the above combo box, the message in the status bar of the window must be reflect the value selected in the combo box (hint: on change event of the combo box).

Set -5

1.    Create an HTML page containing the following features

a.    A combo box containing the list of  7 colors: Violet, Indigo, Blue, Green, Yellow, Orange, Red

b.    An empty 1X1 table with default background color: White

c.    Depending upon the color selected from the above combo box, the background of the table must be changed accordingly. (hint: on change event of the combo box).

2.    Import a  ‘ JPEG’ format image and save it as a ‘PSD’ image, using  layer options

Decrease the opacity of image.

Tips: Ctrl + Shift + S   = ‘save as’ window.

Set -6

1.    Open a PORTRAIT image, convert it into grayscale. Now color the image Using  COLOR BALANCE, LEVELS and CURVES

2.Write a HTML page containing an HTML form to capture the following properties from the user:

a.    Name (text box)

b.    Address (text area)

c.    Phone (text box)

Write javascript functions

§  to validate Name to contain only alphabets and of maximum length should be 25 ; Show appropriate messages on failure

§  to validate Address field to contain maximum length of 200 characters; Show appropriate on failure and focus the ‘Address’ field text area

§  to validate phone number to contain only numeric data; show appropriate messages on failure

Set -7

1.Create two HTML pages

d.    First page with the following features

                                  i.    An image(logo) with a company name as the heading in the top center

                                 ii.    This page containing an HTML form, two text boxes to get First Name, Second Name of the user

                                iii.    A submit button to the submit the data to the next page

e.    The Second page receives the data submitted by the First Page, displays the following message

Welcome <Last Name>, <First Name>

2.    Open a portrait, select the eyeballs using marquee tool, and now change the color of eyes using Hue / saturation.

Tips: Ctrl + U = Hue / saturation

Set -8

1. Open 3 to 4 images in a same layer. Using filter effects create creative backgrounds for book cover page.

2. Create a HTML page to display a list of film songs available in the library. The following are features of the page

f.     The name of the songs must be hyper linked to the songs, so that the users must be able to download songs.

g.    The following is the song database available in the library:

Library Name: Hariharan Music Site

Slno	Song Name	Film	Artiste
1	PATA-PATA	Apthamitra	Udith Narayan
2	Kana Kanade	Apthamitra	Madhubalakrishna
3	Anku Donku	Apthamitra	S P Balasubramanyam
4	Kalavanu Thadeyoru	Apthamitra	Hariharan
5	Bombe	Anayya	Unknown

Set – 9

1.    Create an HTML page to display the following data using <table></table> tags

First Name     Last Name      City                 Phone Number         

Shiva               Rama              Mysore            08212569964

Pratap             S                      Bangalore        08025689754

Sreenivas        G                     Mercara          08965445454

2.    Open a image and adjust a level of image.

Tips: Ctl + L = level

Set -10

1)    Write HTML script to display “Hello World, Welcome to the world of HTML”. Put the title as “World of HTML”

2)    Change a image size 22 cm x 29 cm to 44 cm x 58 cm.  And resolution 72 to 300.

Set -11

1.    Create some geometrical shapes, using shape tool.

Set -12

1.    Type text ‘GRADATION’ and apply gradient tool on text.

      Tips: Before applying gradient you must select text with wand too, and apply gradient on new layer

2.    Create an HTML page to display the following data using <table></table> tags

First Name     Last Name      City                 Phone Number         

Shiva               Rama              Mysore            08212569964

Pratap             S                      Bangalore        08025689754

Sreenivas        G                     Mercara          08965445454

Set -13

1. Write C Program to create Indian Flag.

2. Write C Program to create FISH structure using basic geometric  Functions.

Set -14

1. Write Open GL Program to create a Window and display HELLOW inside

2. Create a simple static web page for a college (assume necessary information )

 For Solution On this question please Ask Ca.rudra@ymail.com 

BSIT 6P

B.Sc.(IT)6th  Semester

Assignment Questions

Subject : Basics of .NET And Internet  Programming

(Answer any 4 of your choice)

       Set -1

1. Write a program for frame sorting technique used in buffers.

2.       Write a program in C# using command line arguments to display a welcome message. The message has to be supplied as input in the command line.

Set -2

1.      Write a program for distance vector algorithm to find suitable path for transmission.

2.       Write a program to demonstrate the usage of threads in C#.

Set -3

1.      Write a program for simple RSA/DES algorithm to encrypt and decrypt the data.

2.      Using Try, Catch and Finally blocks write a program in C# to demonstrate error handling.

Set -4

1.      Write a program for Spanning Tree Algorithm (PRIM) to find loop less path.

2.    Write a program in C# to demonstrate operator overloading.

Set -5

1.    Write a program in C# to sort the students list based on their names. The students list is stored in a string array.

2.    Write a C# Program to demonstrate use of Virtual and override Key words in C#.

Set -6

1.    Write a program in C# , create a class called rectangle which consists of members side_1, side_2 and displayArea(). Write another class square which inherits class rectangle. Take side of square as input and display the area of square on console

2.    Write a program to multiply two matrices.

Set -7

1.    Write a C# program to demonstrate handling of server control programs.

2.    Write a program to display a message “Welcome to ASP.NET” 8 times in increasing order of their font size using ASP.NET.

 For Solution On this question please Ask Ca.rudra@ymail.com ...........