Punjab Technical University 2007 B.B.A ( 2sem)- DATABASE SYSTEMS ( - 205) - Question Paper

BBA (Semester - 2nd)

DATABASE SYSTEMS (BBA - 205)

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 x two = 30)
a) define database in your own words.
b) What is a key field?
c) elaborate the limitations of hierarchical database models?
d) describe terms :-
(i) Degree of a relation (ii) Cardinality of a relation.
e) Why we sort database? Write a command for sorting data in FOXPRO?
f) provide 2 uses of APPEND FROM command.
g) Write the rules that apply to field names.
h) How can you limit the number of fields browsed?
i) What is the purpose of DO.. WHILE?
j) What is the likeness ranging from INSERT and APPEND?
k) What do you mean by packing of records?
l) What is the maximum length of character field type?
m) How do you create the structure of database?
n) provide commands for deleting records from a file.
o) describe terms :
(i) RECORD (ii) FIELD

part - B
(9 x five = 45)
Q2) explain the advantages and disadvantages of database management system.
Q3) define network data model with an example.
Q4) Compare relational data model with hierarchical data model.
Q5) elaborate 3 uses of BROWSE command? discuss with examples.
Q6) define various kinds of data fields in FOXPRO.
Q7) How is report printed? What is the purpose of CREATE and replace
REPORT commands?
Q8) What is the purpose of a DO WHILE loop? Draw a diagram of DO WHILE
statement with an embedded IF statement.
Q9) What is the difference ranging from obtain and SEEK? What must be done to a
database before you can use the obtain or SEEK command?
Q10) define the purpose of PICTURE clause.
Q11) What do you mean by indexing of data? elaborate the advantages of
indexing? Differentiate ranging from single and compound indexes.
Q12) elaborate macros? explain the advantages of using macros?
Q13) Write 6 forms for the DISPLAY command and discuss every.

Earning:   Approval pending.