SK.K.M.BASHA, M.Tech

SGPA Calculator SGPA Calculator Add Subject Clear All Subject Grade Grade Points Credits Calculate SGPA Enter Subject Details Save Cancel

  MATERIALS UNIT-I   Download UNIT-II Download UNIT-III   Download UNIT-IV   Download UNIT-V   Download B+ TREES   Download INDEXING   Download IMPORTANT QUESTIONS FROM UNIT-3,4,5 1. Define Normalization. Explain 3NF, 4NF with examples. 2. Consider the relation R (A,B,C,D,E,F) and FDs A → BC, F → A, C → A, D → E, E → D. A→D is the decomposition of R into R1 (A,C,D), R2(B,C,D) and R3(E,F,D) lossless? Explain the requirement of Lossless decomposition.   3. Define Decomposition. Explain different types of Decompositions with examples. 4. What is concurrency control? Explain the two phase locking protocol with an example. 5. Construct a B+−tree for set of key values: (2, 3, 5, 7, 11, 17, 19, 23, 29, 31). Assume that the tree is initially empty and values are added in ascending order. Construct B+tree for the cases where the number of pointers that will fit in one node is 4, 6 and 8. 6.    Discuss about Triggers and active Dat...

  SYLLABUS R20-ECE-DBMS SYLLABUS  Download MATERIALS UNIT-1 PDF  Download UNIT-2( 1 of 2 ) PDF  Download UNIT-2( 2 of 2 ) PDF  Download UNIT-3 PDF  Download UNIT-4 PDF  Download UNIT-5 PDF  Download ASSIGNMENT-I 1. Define DBMS and Explain the Characteristics of Database Approach? 2.  Categorize the Users in DBMS. 3. What are the Advantages & Disadvantages of Database System? 4. Explain Centralized & Client-Server Architectures for the database. 5. Analyze Database system environment with neat diagram. ASSIGNMENT-II 1.  Explain briefly about different types of JOINS. 2. Explain about Integrity Constraints in SQL. 3. Explain about Relational set operations. 4. Define Redundancy? What are the problems caused by redundancy? 5. What is Decomposition? What are the problems related to Decomposition.

MATERIALS   UNIT-1 PDF   Download UNIT-2 PDF  Download UNIT-3 PDF  Download UNIT-4 PDF   Download UNIT-5 PDF   Download UNIT-6 PDF  Download UNIT-1 IMPORTANT QUESTIONS 1. Explain the Goals of Software Testing? 2. Discuss about Design Bugs and System Bugs? 3. Explain why complete testing is not possible? 4. Illustrate different states of bugs attained in its life cycle? 5. Illustrate the model for software testing? 6. Discuss in detail about Evolution of Software Testing? 7. Differentiate between Effective and Exhaustive Software Testing? 8. Discuss about Myths related to Software Testing and its Facts? 9. Explain about Life Cycle of Bug? 10. Draw Software Testing Life Cycle (STLC) and explain? ASSIGNMENT TEST-1 QUESTIONS 1. Discover the Goals of Software Testing? 2. Construct the model for Software Testing? 3. Explain in detail about Evolution of Software Testing? 4. Distinguish between Effective and Exhaustive Testing? 5. Discuss about Myths related t...