PTU B.Tech CSE 5th Semester May 2019 70535 RELATIONAL DATABASE MANAGEMENT SYSTEM I Question Papers

FirstRanker.com

Roll No. EEEEEEEE [ ] Total No. of Pages : 02
Total No. of Questions : 18

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

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

INSTRUCTION TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.

SECTION-A

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

1. What are DML commands in SQL?
2. What is a multi-valued dependency?
3. What is a lock in concurrency control?
4. What are attributes?
5. Explain ‘C’ in ‘ACID’ properties?

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

6. What is the difference between B-Trees and B+ Trees?
7. Define transaction.
8. Differentiate between Grant and Revoke.
9. Define Normalization?
10. What is a Sparse Index?

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

SECTION-B

11. Draw any ER Diagram which demonstrates the following :
    • Entity
    • Attribute
    • Multi-valued attribute
    • Composite attribute

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

    • Derived attribute
12. What is a precedence graph? What is a conflict serializable schedule? Can precedence graph be used to detect a conflict serializable schedule?
13. Consider a relation R with attribute set {A, B, C, D} and functional dependency set F = {A— B, B — C, C— D}. This relation is decomposed into three sub relations {AB, BC, CD}. Check if the decomposition is dependency preserving or not. Discuss.
14. Attempt the following :
    1. Explain Lost-Update Problem?

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

    2. How can Lost-Update problem be solved?
15. What are the properties of decomposition? Explain in detail with the help of examples.

SECTION-C

16. Consider the following relation for published books :
    

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

    BOOK (Book title, Author name, Book type, List price, Author affil, Publisher)
    Author_affil refers to the affiliation of author. Suppose the following dependencies exist :
    Book title — Publisher,
    Book_type — List_price
    Author_name — Author_affil
    1. What normal form is the relation in? Explain your answer.

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

    2. Apply normalization until you cannot decompose the relations further. State the reasons behind each decomposition.
17. Explain the following :
    1. Update Anomaly
    2. Deletion Anomaly
    3. Insertion Anomaly

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

    4. Transitive Dependency
18. Answer the following :
    1. Why is indexing required for a Database?
    2. Explain multi-level indexing. Is it true that all the levels of multi-level index are primary index? Discuss.

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

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.

FirstRanker.com