CY-405 Database Management System - Jun 2024 Question Paper

Under each question, How to answer lists the points an answer should cover, outlined by CampusPrep from the syllabus. Check the details against your textbook.

1. 7 Marks
   aWhat is DBMS and differentiate between DBMS and traditional file Storage System?
   How to answer

   • Define DBMS as integrated managed collection of data with DBMS software
   • List characteristics of traditional file system
   • Compare on data redundancy, consistency, security, concurrency, independence
2. 7 Marks
   bExplain different types of data models in DBMS?
   How to answer

   • Define data model
   • Explain hierarchical model
   • Explain network, relational and object-oriented/ER models with examples
3. 7 Marks
   aState and Explain various features of E-R models?
   How to answer

   • Define E-R model and its components
   • Explain entity, attributes, relationship, keys
   • Explain features like generalization, specialization, cardinality with diagram
4. 7 Marks
   bWhat are the statements in SQL for destroying and altering tables. Explain with examples?
   How to answer

   • Identify DROP TABLE for destroying and ALTER TABLE for altering
   • Give syntax of DROP and ALTER with ADD, MODIFY, DROP column
   • Give examples of both statements
5. 7 Marks
   aDiscuss about different types of Integrity Constraints?
   How to answer

   • Define integrity constraints
   • Explain domain, key, entity and referential integrity
   • Give example for each constraint
6. 7 Marks
   bWrite Relational Algebra Queries for the following for (Sailor Database). Sailors ($Sid$, $Sname$, $Rating$, $Age$), Boats ($Bid$, $Bname$, $Color$), Reserves ($Sid$, $Bid$, $Day$)

   1. i)Find the following id's with age over 20 and who have not reserved a red boat.
   2. ii)Find the names of Sailors who reserved boat 103.
   How to answer

   • Recall Sailors, Boats, Reserves schemas
   • Use selection, projection, join and set difference for i)
   • Use selection-join-projection for names of sailors reserving boat 103
7. 7 Marks
   aWhat do you understand by a Functional Dependencies. Explain?
   How to answer

   • Define functional dependency X -> Y
   • Explain trivial, non-trivial, full and partial dependencies
   • Give example and need in normalization
8. 7 Marks
   bState and Explain Lossless join decomposition?
   How to answer

   • Define decomposition of relation
   • State lossless-join condition
   • Explain test with common attribute as key and example
9. 7 Marks
   aExplain in detail about Relation Schemas with suitable examples?
   How to answer

   • Define relation schema vs instance
   • Explain attributes, tuples, domain and keys
   • Give example schema e.g. Student or Sailors
10. 7 Marks
    bWhat is a transaction and explain its properties and States?
    How to answer

    • Define transaction as unit of work
    • Explain ACID properties
    • Explain transaction states with diagram
11. 7 Marks
    aWhat is Schedule? Explain about Serial and Non Serial Schedule?
    How to answer

    • Define schedule of transactions
    • Explain serial schedule with example
    • Explain non-serializable vs serializable schedule
12. 7 Marks
    bHow the Lock Manager implements lock and Unlock request? Explain.
    How to answer

    • Define lock and unlock operations
    • Explain lock table and request handling by lock manager
    • Explain granting, waiting queue and release steps
13. 7 Marks
    aExplain extendable hashing techniques for indexing data records. Consider your Class students data records and roll numbers as index attribute and show the Hash directory?
    How to answer

    • Define extendable hashing and directory
    • Explain global and local depth with splitting
    • Show example using roll numbers as index with hash directory
14. 7 Marks
    bExplain Static Hashing? What are the advantages of static hashing in DBMS?
    How to answer

    • Define static hashing
    • Explain hash function and buckets
    • List advantages like simplicity and disadvantages
15. 14 Marks
    Write short notes on any two :

    1. i)Query Processing
    2. ii)Data independence
    3. iii)Union and Intersection
    4. iv)Dependency Preservation
    How to answer

    • Select any two topics from list
    • Give definition and key points for each
    • Add diagram/example and uses where applicable