Introduction to DBMS, Question Paper of BBA 4th Semester, Download Previous Years Question Paper 1

Roll No....

Total No. of Questions : 07

Paper ID [C0223]

BBA (Sem. – 4th)

INTRODUCTION TO DATABASE

MANAGEMBNT SYSTEMS (BB . 406)

Time : 03 Hours Maximum Marks : 60

Instruction to Candidates:

1) Section - A is Compulsory.

2) Attempt any Four questions from Section - B.

Section - A

Q1)

a) What do you mean by foreign key?

b) What do you mean by database file?

c) What is a tuple?

d) Define the term entity?

e) What do you mean by range?

0 What do you mean by cell pointer?

g) Differentiate between data and information?

h) What do you mean by field?

t) What do you mean by dyna set?

j) What do you mean by data redundancy?

Section - B

Q2) Discuss in detail and differentiate between network model and Hierarchal model.

Q3) What do you mean by normalization? Explain 2nd normal form of a database?

Q4) Explain in detail how forms are created in MS ACCESS?

Q5) Explain the steps for creating relations between different tables in MS ACCESS with the help of suitable example.

Q6) Differentiate between DBMS and RDBMS with the help of suitable examples?

Q7) Explain the working of following commands with the help of suitable examples:

. COUNT ( )

. MAX( )

. SUM( )

. String functions