BCA || DBMS(Database Management System) 2025 (Supplementary) Paper || MDSU Exam Paper

Part-A

Q.1 What is a Data base management system?

Q.2 What is normalization in a DBMS?

Q.3 Explain foreign key in DBMS.

Q.4 What is purpose of indexing in a database?

Q.5 Explain an entity and entity set.

Q.6 What is specialization in DBMS?

Q.7 What are the objects of MS-Access?

Q.8 What is forms in MS-Access?

Q.9 Define schema in DBMS.

Q.10 How can relationship between tables be created in MS-Access?

Part-B

Q.11 Explain filter and its types in MS-Access.

Q.12 What is difference between 3NF and BCNF

Q.13 What is Attribute? Explain types of attribute in ER-model.

Q.14 What are different report views?

Q.15 Explain difference between generalization and aggregation in ER-Model?

Part-C

Q.16 What is DBA? Explain role of DBA in details?

OR

Explain various types of database models?

Q.17 What is normalization in DBMS? Explain all types of normal forms

OR

What is functional dependency in DBMS? How many types of functional dependencies avail-able in DBMS, Explain them.

Q.18 What is purpose of the Query object in MS-Access Explain the different types of Queries available 6

OR

Create a database company and perform the following tasks

(a) Create table named "Employee" with attribute Eid, Ename, City, Salary, department and role.

(b) Insert at least 5 records

(c) Create a report of all the fields of above table