B.C.A. Examination, 2022
fifth Semester
(Introduction to DBMS)

Time : 1:30 Hours I Maximum Marks : 75
Note: Attempt any five questions. All questions carry equal marks. The answer to given questions should not exceed 250 words each. 15×5=75

1. What is functional dependency? Discuss its toes, explain the role or functional
dependency in the process of Normalization.
2. What is E- model? How E-R model different from other data models? What are the main
advantages of the E-R model? 3. What are the various operators used in relational Algebra? Discuss each with an example
4. What do you understand by relational model of database system? Elaborate the
major characteristics of relational database management system.
5. (a) Explain the responsibilities and functions of database Administrator.
(b) Differentiate between physical and logical data independence.
6. Elaborate the three level architecture of database system. 7. What are the problems arising out concurrent data access? What are the
various methods of handling concurrency?
8. Write note on the following :
(a) Normalization
(b) Hashing
(c) Inheritance 9. consider the rollowing relations .
Hotel (hotel No., name, address} Room (room No., hotel No., type, price} Booking (hotel No.,guest No., date From,date to, room No.} Guest {guest No., name, address}
Write the SQL statements for the following:
(a) List the names and addresses of all guest in delhi, aiphabetically ordered by name.
(b) List all family rooms with a price below Rs. 400 per night, in ascending order of price.
(c) How many hotels are there?

year – 2021 paper

(Introduction to DBMS)
Time: Three Hours //Marimum Marks
Note: Attempt any five questions. All questions carry equal marks.
Note :The answers to short answer should not exceed 200 words and the answer to long questions should not exceed 500 words.

1. (a) Explain the responsibilities of a Data-base Administrator 7½×2
(b) Differentiate between physical and logical data independences. 2. What do you mean by the E-R model? Explain with examples the notations used.Illustrate the ER model with a real world example 15
3. What do you understand by Relational model of database system? Elaborate the
major characteristics of relational database management system. 15
4. What is the use of reiational. Algebra in Relational data model, What are the various
operator’s used in Relational Algebra? Discuss each with a suitable example. 15
5.Write short notes on any three: 5+5+5
(i)Serializabilit
(ii)Hashing
(iii) Inheritance
(iv) Specialization
(v) Generalzition 6. Elaborate the three-level architecture of database system. State the significance of each level. 15
7. Consider the following relations: 15
Hotel (hotel No., Name, Address}
Room (room No., hotel No., type, price}
Booking (hotel No., guest No., date from,date to, room No.}
Guest ( quest No., name, address,)
Write the SQL statement for the following:
(a) List the names and address of all guests in delhi, alphabetically ordered by name.
(b) List all familv rooms with a price below Rs. 400 per night, in ascending order of price
(c)How many hotels are there? 8. Write on the following with suitable example 5×3=15
(i)Primarv key
(ii) Candidate key
(ili) Foreign key
9.(a) What are weak entity set’s? How a weak entity set can be converted into strong entity set?
(b)What is the difference between authentication and authorization.

Year – 2020

B.C.A. Examination, 2020
Fifth Semester /First Paper

1. What is DBMS architecture? Write the characteristics or database approach 15
2. what do vou mean ov the Er model? explain with examples the notations used 15 3. Write difference between Constraints and Schema. Give the name of five applications
that are used in database and why? Give reason. 15
4.What is the use of relational constraints and relational algebra in the relational data model?
Explain with example
5. Write 5 queries which are used in SOL with example. What is the use of SQL in RDBMS.
6. What is Normalization? Explain 3NF, 4NF and 5NF. 15
7.What is the role of locking technique and database recovery? Describe with example 8. What is Transaction Processing? Discuss about OLTP and OLAP. 15
9. Write short notes on anv three: 5+5+6
(a) Serializability
(b) Time stamp ordering protocol
(c)commit and Rol back command
(d) Two phase locking

year- 2019

B.C.A. Examination, 2019
Fifth Semester/First Paper

1.(i) What is meant by three level Architecture of database system? Explain therole of conceptual level in detail.5+5=10
(ii) Differentiate between DDL and DML. 2.(i) Discuss the concept of ER model. How it helps in designing relational data bases? 5+5=10
(ii) What is role of Primary key and a Candidate key? Explain by giving suitable example.
3.Define the following with example 5×3=15
(i)Cardinality
(ii)DBA
(iii) Data dictionary
(iv) External schema
(v) Data recovery
4.(i) explain the concept of life processing system. (ii) Define hashing and hashing functions.How can you resolve collisions in hashing? 5. What is meant by selection and projection operator? Discuss their use on SQL
based queries. 10
(ii)Differentiate between commit and Roll&back commands in SQL. Also unit syntax of each of them
6.(i) What is an entity type? What is the difference between a strong entity type and a weak entity type?
(ii) Draw an ER diagram for the functioning of Library of a University. It includes details of Books up. ISBN number title author. Books can he issued to an user of student or faculty. 10
7. Why recovery is needed in a database? Explain the log based recovery techniques. 15
8. illustrate the fact that BCNF is strictly stronger than 3 NF

YEAR – 2018

B.C.A. Examination, 2018
Fifth Semester /First Paper (Introduction to DBMS)

1. What Is DBMS? What are Its advantages and disadvantages?
   Explain. 15
2. What Is data model? Compare and contrast various data models. 15
3. Explain the conventions for displaying an ER schema as an E-R
   diagram. Illustrate with a real-world example. 15
4. Explain how data retrieval, insertion and deletion are done using Btree and B+ tree in-dices in a database. 15
5. (a) What is relational algebra? How it is different from relational
   calculus? Explain its main postulates. 7.5
   (b) Define the Relational model and its main features. 7.5
6. What do you mean by functional dependency? Explain BCNF with
   suitable example. 15
7. What are the different techniques for data-base recovery? Discuss in
   detail. 15
8. Write short notes on any two of the following 15
   (a) Database security
   (b) SQL
   (c) Recovery Techniques

YEAR – 2017

B.C.A. Examination, 2017
Fifth Semester/First Paper (Introduction to DBMS)

1. Discuss the various disadvantages in the file system and explain how it can be overcome by the
   database system. 15
2. Construct an ER diagram for an employee payroll system. 15
3. Explain : 15
   (i) Inheritance
   (ii) Specialization
   (iii) Generalization
4. Explain how data retrieval, insertion and deletion are done using B- tree and B-tree indices. 15
5. Schema defined for Employee Management System is : 5×3=15
   Emp : Emp ID, Name, Add, Dept. Designation, Salary
   Dept : Dept ID, Name Head ID
   Write SQL Queries:
   (i) Retrieve the details of employee who gets the maximum salary.
   (ii) List names of all employee who earn more than Rs. 1,00,000 in a year.
   (iii) Give the name of employee who heads the department where employee with emp ID 3 works.
6. Explain the 3NF and BCNF with example.15
7. What are various threats to data security?
   Explain how you will enforce security standards for the protection of data in a Data base. 15
8. Write short notes on : 5×3 = 15
   (i) Database Recovery
   (ii) Concurrency Control
   (iii) Functional Dependencies