Saurastra University 2006 B.Sc Information Technology Business Data Processing - exam paper

B. Sc. (IT) (Sem. II) exam
April / May – 2006
Time : three Hours] [Total Marks : 100

1
Attempt any 4 : 20

(a)
What is DBMS, RDBMS? discuss database file, field
and record.
(b)
discuss Data models in brief.
(c)
discuss Data Types, available in FoxPro
(d)
Explain: delete, recall, pack, zap
(e)
discuss Sum and Total with suitable example.
2
Attempt any 5 : 20

(a)
Differentiate SORT and INDEX.
(b)
Write about SCAN....ENDSCAN with example.
(c)
discuss @....SAY....GET with FUNCTION, VALID clause.
(d)
explain the use of ?..?? and ???
(e)
discuss DO....END CASE with example.
3 (a)
discuss the subsequent functions with example : 10
(any five)

(i)
soundex ( )
(ii)
mod ( )
(iii) val ( )
(iv) floor ( )
(v)
replicate ( )
(vi) sign ( ).
(b)
discuss subsequent SET commands : (any five) 10
(i)
Exact (ii) Talk
(iii)
Default (iv) Alternate
(v)
Carry (vi) Order.
SP-1945]
1
[Contd..


4
Attempt any 4 : 20

(a)
Write a program to take input of any number and findsum of digits.
(b)
Write a program to take a string and counts how manytimes ‘a’ is occurred.
(c)
Write a program to enter a number and check whetherthe number is prime or not.
(d)
Write a program to design popup menu using window
popup.
(e)
Write a program to design a menu using window, menuand pad.
5 (a)
Write commands for subsequent queries Employee.dbf five
has subsequent fields :
Code N3 0
Name C 15
Dept. Code C one [‘C’, ‘S’, ‘P’]
Des Code C one [‘M’, ‘E’, ‘A’]
Pay N82

(i)
How many employees are there in deptcode ‘C’having pay <10000
(ii)
Add city field having C data kind and width 15
(iii)
Create Tags on name and code field.
(iv) Take listing of employees having pay >10000 anddescode ‘M’
(v)
organize in dept. DBF all the employees of descode‘A’.
(b)
Write a program to add and edit a record in learner.DBF(structure: Sno, name, address, city, phno, m1, m2, m3,
Tot, Per)
(c)
Write steps to create a Report. five
SP-1945]
2 [ 300 / 7-9
]

Earning:   Approval pending.