R20 - DATABASE MANAGEMENT SYSTEMS (CSE)

 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 Database in SQL with examples. Write the
differences between constraints and triggers in SQL.

Comments

Post a Comment

Popular posts from this blog

R20-ECE-DBMS

  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.
Read more

SOFTWARE TESTING METHODOLOGY

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...
Read more