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

Roll No. ...........

Total No. of Questions : 07

BBA (Sem. - 4th)

INTRODUCTION TO DATABASE 

MANAGEMENT SYSTEMS

SUBJECT CODE : BB - 406

      Paper ID [C0223]    

 

Time : 03 Hours

Instruction to Candidates:

1) Section - A is Compulsory,.

2) Attempt any Four questions from Section - B.

Section - A

l.

 (a) Define database schema.

(b) What do you mean by database instance?

(c) What is data independence? Explain it.

(d) Explain candidate key in detail.

(e) Differentiate primary key and foreign key.

(f) What do you mean by virtual records?

(g) What is DBA? Write his responsibilities.

(h) Explain the various parts of MS-Access Window.

(i) What do you mean by DDL and DML statements?

(j) Write the process of saving databases in MS-Access.

SECTION-B

2. Explain the first and second normal forms of databases with examples.

3. What are the advantages and disadvantages of using database approach as compared to traditional file processing system?

4. Discuss the three level architecture of DBMS. How mapping is done between the different levels?

5. What do you mean by concurrency control? How it can be maintained?

6. Discuss in detail the ER model. How ER diagrams are converted to tables? Explain it by giving examples.

7. Write the process in detail for creating new tables in MS-Access.