Download PTU BCA 2020 March 4th Sem BSBC 404 Database Management Systems Question Paper

Roll No. ____________________ Total No. of Pages : 02

Total No. of Questions : 07

BCA (2014 to 2018) (Sem.-4)

--- Content provided by‍ FirstRanker.com ---

DATABASE MANAGEMENT SYSTEMS

Subject Code : BSBC-404

M.Code: 10069

Time: 3 Hrs. Max. Marks : 60

INSTRUCTION TO CANDIDATES :

--- Content provided by​ FirstRanker.com ---

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
2. SECTION-B contains SIX questions carrying TEN marks each and a student has to attempt any FOUR questions.

SECTION-A

1. Answer briefly :

   1. What do you mean by single-valued and multi-valued attributes?

   --- Content provided by⁠ FirstRanker.com ---

   2. What do you mean by Data Base instance and Data Base schema?
   3. What is the difference between Unique constraint and Primary key constraint?
   4. Define Entity and Attribute.
   5. What do you mean by Multivalued Dependency?
   6. What is a Tuple?

   --- Content provided by⁠ FirstRanker.com ---

   7. What is the difference between the strong entity set and weak entity set?
   8. What is meant by domain of an attribute?
   9. What is concurrency?
   10. What is data fragmentation?

--- Content provided by⁠ FirstRanker.com ---

SECTION-B

2. What is ER Diagram? What are the symbols used in it? Design and Draw an ER diagram for a banking system.
3. What do you mean by Normalization? Explain the first three normal forms along with BCNF and the anomalies that exist in these normal forms with the help of suitable examples.
4. 1. List various advantages of Data Base approach over Traditional File system approach.
   2. Explain the difference between Physical and Logical Data Independence.

   --- Content provided by‍ FirstRanker.com ---

5. Define Relational Algebra. Explain the various Relational Algebra operations with the help of examples.
6. What do you mean by Database Recovery? Explain different Recovery Techniques for non-catastrophic transaction failures.
7. What are Integrity Constraints? Explain different Integrity constraints in detail.

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

--- Content provided by⁠ FirstRanker.com ---

FirstRanker.com