Punjab Technical University 2007 B.B.A DATABASE SYSTEMS - Question Paper

Roll No...........................
Total No. of ques. : 13] [Total No. of Pages : 02
Paper ID [B0111]
(Please fill this Paper ID in OMR Sheet)
BBA (205) (S05/Old) (Sem. - 2nd)

DATABASE SYSTEMS
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) part - A is Compulsory.
2) Attempt any 9 ques. from part - B.

part - A
Q1) (15 × two = 30)
a) describe database management system.
b) elaborate limitations of network data model?
c) Write down commands for deleting records in FOXPRO?
d) What is compound Index?
e) Why we sort database? How it is various from indexing?
f) describe terms:-
(i) record (ii) field
g) Write down applications of database management system?
h) How data can be converted from 1 kind to another?
i) describe degree of a relation.
j) What is the purpose of the DO command?
k) What is the difference ranging from LIST and DISPLAY?
l) define the use of REPORT FORM COMMAND.
m) Differentiate ranging from @ row, col SAY and @ row, col GET?
n) List 3 uses of BROWSE command.
o) What key sequence can you use to delete a field?
J-8012[S-9700429] P.T.O.
J-8012 [S-9700429] 2

part - B
(9 × five = 45)
Q2) Differentiate ranging from hierarchical and network data model.
Q3) elaborate advantages of database management system over conventional
file processing system?
Q4) elaborate various data kinds allowed in FOXPRO?
Q5) With the help of example differentiate ranging from LOCATE and SEEK
commands.
Q6) define Relational Data Model?
Q7) elaborate macros? What is the use of macros and how they are created in
FOXPRO?
Q8) define different FOXPRO statements for displaying text and accepting
data from keyboard.
Q9) What is procedure command in FOXPRO? discuss with an example.
Q10) List the steps you use to create a menu system.
Q11) Write a working example of the @ row, col SAY command.
Q12) What is an Index? Why we use Indexes? Differentiate ranging from single and
compound indexes?
Q13) How can you add new records to a database?
??????

Earning:   Approval pending.