For getting solved assignments contact us at
Service charges as Rs. 150 per assignment.
PROGRAM B. SC IT
SEMESTER FIRST
SUBJECT CODE & NAME BT0062- Fundamentals of IT
1 What is Operating system? Explain the importance of operating
system.
3+7 10
2 Perform the following binary arithmetic operations:
1. 101001+1001
2. 101101-100111
3. 101*101
4. 0110*1101
5. 10011/110
5*2 10
3 Explain all the options of start menu. 10 10
4 Explain the steps to insert the special symbols in MS word. Also
explain the steps to insert the word art in MS word.
5+5 10
5 Can Database be created in MS – Excel? Explain any four options
supported by MS Excel to handle databases in MS Excel.
2+8 10
6 What is search engine and what is the importance of it? 5+5 10
For getting solved assignments contact us at
Service charges as Rs. 150 per assignment.
[SPRING, 2014] ASSIGNMENT
PROGRAM BSC IT
SEMESTER I
SUBJECT CODE &
NAME
BT0063, MATHEMATICS FOR IT
1. (i) Let A = {1, 2, 3, 4, 5, 6} and B = {2, 4, 6, 8}. Find A – B and
B – A.
(ii) In a group of 50 people, 35 speak Hindi, 25 speak both English
and Hindi and all the people speak at least one of the two languages.
How many people speak only English and not Hindi ? How many
people speak English?
2+8 10
2 (i) Express 792 in radians and (7/12)c in degrees
(ii) Prove that
cos
sin 1
sin 1
cos
1 sec tan
1 sec tan
2+8 10
3 (i) Define continuity of a point
(ii) Test the continuity of the function f where f is defined by
2 7
2
| 2 |
2
x if
x if
x
x
x f
2+8
10
4
Solve
4 x y
2 x y
dx
dy
10 10
5 A bag contains two red balls, three blue balls and five green balls.
Three balls are drawn at random. Find the probability that
a) the three balls are of different colours
b) two balls are of the same colour
c) all the three are of the same colour.
3+4+3 10
6
Solve: 2x + 3y + 4z = 20, x + y + 2z = 9, 3x + 2y + z = 10
10 10
For getting solved assignments contact us at
Service charges as Rs. 150 per assignment.
SPRING 2014, ASSIGNMENT
PROGRAM BSC ITSEMESTER I
SUBJECT CODE &
NAME
BT0064, LOGIC DESIGN
1 Convert each of the following hexadecimal numbers to binary,
octal, and decimal formats.
i) (4FB2)16
ii) (DC4)16
5+5 10
2 Construct the following gates using NAND
a)AND b) NOR c) XOR d)XNOR
4x 2 ½ 10
3 Expand the following Boolean functions into their canonical form:
i. f(X,Y,Z)=XY+YZ+XZ+X Y
ii. f(X,Y,Z)=XY+X Y+XYZ
5+5 10
4 Simplify the following Boolean function:
F = A’C + A’B + AB’C + BC, using K-map?
10 10
5 What are sequential circuits? Explain differences between
sequential circuits and combinational circuits.
4+6 10
6 What are shift registers? Explain serial in serial out shift register. 4+6 10
For getting solved assignments contact us at
Service charges as Rs. 150 per assignment.
[ SPRING 2014 ] ASSIGNMENT
PROGRAM BSc ITSEMESTER FIRST
SUBJECT CODE &
NAME
BT0065, C Programming and Data Structures
1 Explain the structure of the C program. 10 10
2 What is recursion? Differentiate between recursion and iteration. 2+4+4 10
3 Define array and explain its need. Write a program to calculate
sum and average of the elements stored in an array.
5+5 10
4 Explain Union. Differentiate between structure and union 5+5 10
5
What is data structure? Explain abstract data type in brief.
Differentiate between linear and nonlinear data structure.
2 ½
+2 ½
+5
10
6 What is linked list? Explain the advantages of linked lists over
array.
2+8 10
For getting solved assignments contact us at
Service charges as Rs. 150 per assignment.
[ SPRING 2014 ] ASSIGNMENT
PROGRAM BSc IT
SEMESTER FIRST
SUBJECT CODE &
NAME
BT0066, Database Management Systems
1 Explain the concept of data independence and explain why it is
required?
7+3 10
2 Why relational data model is important? Explain the terms relation
and tuple. 4+3+3 10
3 Perform the following DML operations on the table:
1. Insert values for the table CUSTOMERS with fields – ID,
name, age, address and salary and insert records in the
table given below:
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
2. Based on the customer table given above update the
salary to 20000 whose salary is less than that.
Based on the customer table given above Fetch ID,
3. Name and Salary fields from the CUSTOMERS table for
a customer with name Hardik.
4
3
3
10
4 Consider the relations
EMPLOYEE(emp#, name)
5+5 10
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and
comp345 project numbers.
(ii)Find the employee number of employee who do not work on
project comp678
5 What do you mean by anamoly in database system? Why it is
required? Explain the types of anamolies in database system.
2+2+6 10
6 Differentiate between Relational Database Management System
And Object Oriented Database Management System.
10 10
No comments:
Post a Comment