Saurastra University 2006 B.Sc Mathematics Business Data Processing - Question Paper

SP-1945] one [Contd..
*SP-1945*
SP-1945 Seat No.__________
B. Sc. (IT) (Sem. II) exam
April / May – 2006
Business Data Processing
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.
4 Attempt any 4 : 20
(a) Write a program to take input of any number and obtain
sum of digits.
(b) Write a program to take a string and counts how many
times ‘a’ is occurred.
(c) Write a program to enter a number and check whether
the 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, menu
and pad.
5 (a) Write commands for subsequent queries Employee.dbf 5
has subsequent fields :
Code N three 0
Name C 15
Dept. Code C one [‘C’, ‘S’, ‘P’]
Des Code C one [‘M’, ‘E’, ‘A’]
Pay N eight 2
(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 and
descode ‘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. 5
______________
SP-1945] two [ 300 / 7-9 ]

Earning:   Approval pending.