MCA or Master of Computer Applications is a master degree in the computer applications. The paper of DBMS is a much needed subject for the software engineers. The subject differentiates between traditional file system and DBMS. The course will be in demand as IT sector is booming.

Paper Pattern:

The paper of Introduction to DBMS is a pure theoretical paper. The paper should be solved within the time limits. Total questions in the paper are 14. The questions are divided into 2 sections; Section A is of 7 questions and 4 are to be attempted from it, each question is of equal marks, these questions are of short answer type. Section B is of 7 questions and 4 are to be attempted from it, each question is of equal marks, and these questions are of long answer type.

Frequently asked questions:

The paper of Introduction to DBMS is a purely theoretical paper; questions asked are generally needed to be answered to the point and accurate. The paper contains questions such as three-schema architecture of a DBMS, cardinality ratio, index sequential file organization,  need for normalization, Comparison between contrast file systems with database systems, Ternary relationship, knowledge base management system, join operation in relational algebra  etc.

Total marks and time allotted:

A maximum of 60 marks can be obtained in this paper and time allotted to the paper is 3 hours only. The Section A is of 20 marks and each question is of 5 marks. Section B is of 40 marks and each question in this section is of 10 marks each.

Recommended Books:

• Database Management System by Ramakrishnan and Gehrke
• An introduction to database systems by C.J.Date