BSC IT ALL SEM OlD QUESTIONS NoV 2013 click this link to download
Kuvempu University BSC IT (3Rd,4th,5th And 6th SEMESTER Practical Paper )
ALL SOLUTION OF BSC IT
Subject :OOPs with C++ And RDBMS
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.
Answers
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.
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 Rudra Prasad or click here
BSIT 4P
B.Sc.(IT)4th Semester
Assignment Questions
Subject :UNIX & Shell Programming And JAVA Programming
(Answer any 7 of your choice)
Set -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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Write a program to create a thread by extending the thread class
BSIT 5P
B.Sc.(IT)5th Semester
Assignment Questions
Subject : Graphics & Multimedia And Web Programming
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
- Create a login JSP page with username , password and submit button.
- 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
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
Tips: Ctrl + U = Hue
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
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
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 .Rudra Prasad
BSIT 6P
B.Sc.(IT)6th Semester
Assignment Questions
Subject : Basics of .NET And Internet Programming
(Answer any 4 of your choice)
Set -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 ...........
No comments:
Post a Comment