Here, we have provided the links containing the study materials, which will help you study and prepare for your B.Tech Database Management System 2020 edition examinations. Referring to the connections we’ve provided below and the links containing the study materials in PDF format, and the list of recommended books that we’ve provided below, you will be able to ace your examinations. We have also provided you with further details that will allow you to do well in your exams and learn more. These study materials help you understand the concepts and everything quickly and creates a better space for you to work on. These study materials give you the best resources to study from.
Download Study Materials
| Database pdf books | Download |
| DBMS Question Paper Pdf | Download |
| DBMS notes for b.tech pdf | Download |
| DBMS full notes | Download |
| DBMS lecture notes ppt | Download |
Reference Books
- Introduction to Database Systems, CJ Date, Pearson
- Database Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA McGraw Hill 3rd Edition
- Introduction to Database Systems, C.J.Date Pearson Education
- The Database Systems – The Complete Book, H G Molina, J D Ullman, J Widom Pearson
- Database Systems design, Implementation, and Management, Peter Rob & Carlos Coronel 7th Edition.
- Fundamentals of Database Systems, Elmasri Navrate Pearson Education
Syllabus
UNIT-I:
An Overview of Database Management, Introduction- What is Database System- What is Database-Why Database- Data Independence- Relation Systems and Others- Summary, Database system architecture, Introduction- The Three Levels of Architecture-The External Level- the Conceptual Level- the Internal Level- Mapping- the Database Administrator-The Database Management Systems- Client/Server Architecture.
UNIT-II:
The E/R Models, The Relational Model, Relational Calculus, Introduction to Database Design, Database Design and Er Diagrams-Entities Attributes, and Entity Sets-Relationship and
Relationship Sets-Conceptual Design With the Er Models, The Relational Model Integrity Constraints Over Relations- Key Constraints –Foreign Key Constraints-General Constraints, Relational Algebra and Calculus, Relational Algebra- Selection and Projection- Set Operation, Renaming – Joins- Division- More Examples of Queries, Relational Calculus, Tuple Relational Calculus- Domain Relational Calculus.
UNIT-III:
Queries, Constraints, Triggers: The Form of Basic SQL Query, Union, Intersect, and Except, Nested Queries, Aggregate Operators, Null Values, Complex Integrity Constraints in SQL, Triggers and Active Database.
UNIT-IV:
Schema Refinement (Normalization) : Purpose of Normalization or schema refinement, concept of functional dependency, normal forms based on functional dependency(1NF, 2NF and 3 NF), concept of surrogate key, Boyce-codd normal form(BCNF), Lossless join and dependency preserving decomposition, Fourth normal form(4NF).
UNIT-V:
Transaction Management and Concurrency Control: Transaction, properties of transactions, transaction log, and transaction management with SQL using commit rollback and savepoint.
Concurrency control for lost updates, uncommitted data, inconsistent retrievals and the Scheduler. Concurrency control with locking methods : lock granularity, lock types, two phase locking for ensuring serializability, deadlocks, Concurrency control with time stamp ordering : Wait/Die and Wound/Wait Schemes, Database Recovery management : Transaction recovery.
UNIT-VI:
Overview of Storages and Indexing, Data on External Storage- File Organization and Indexing – Clustered Indexing – Primary and Secondary Indexes, Index Data Structures, Hash-Based Indexing – Tree-Based Indexing, Comparison of File Organization
Important Questions
- Explain briefly the languages supported by database systems.
- What is Data modeling? Explain the relational model.
- Why are foreign key constraints important? Explain with employee database.
- What is meant by referential integrity? Explain.
- Where do we need the nesting of queries? Give an example.
- Differentiate between updatable views and non-updatable views?
- Is the decomposition in 4NF always dependency preserving and lossless? Explain with an example,
- Consider the following relation R(A,B,C,D,E)and FD’s ABC, CA,DE, FA, ED is the decomposition of R into R1(A, C, D), R2(B, C, D) AND R3(E,F,D) lossless?
- What is timestamp ordering? Explain how it is used for concurrency control?
- Explain view Serializability with an example? How is it different from conflict Serializability?
- Explain Open hashing? Discuss their advantages and disadvantages.
- Compare dynamic hashing with static hashing.