All Materials regarding to B.tech R-20 in Computer Science in AI & ML Engineering 1st Year 2nd Semester with unit wise for Every Subjects are available.
👇👇Scroll Down for Important Questions and Topics Unit Wise 👇👇
| CSM 2-1 DBMS | ||
|---|---|---|
| Chapters / Units | Download Link | |
| 1 | Unit 1 | Download |
| 2 | Unit 2 | Download |
| 3 | Unit 3 | Download |
| 4 | Unit 4 | Download |
| 5 | Unit 5 | Download |
CSM 2-1 DBMS important Topics and Questions
UNIT I
Introduction: Database system, Characteristics (Database Vs File System), Database Users(Actors on Scene,
Workers behind the scene), Advantages of Database systems, Database applications. Brief introduction of
different Data Models; Concepts of Schema, Instance and data independence; Three tier schema
architecture for data independence; Database system structure, environment, Centralized and Client Server
architecture for the database.
UNIT II
Relational Model: Introduction to relational model, concepts of domain, attribute, tuple, relation, importance
of null values, constraints (Domain, Key constraints, integrity constraints) and their importance BASIC
SQL: Simple Database schema, data types, table definitions (create, alter), different DML operations (insert,
delete, update), basic SQL querying (select and project) using where clause, arithmetic & logical operations,
SQL functions (Date and Time, Numeric, String conversion).
UNIT III
Entity Relationship Model: Introduction, Representation of entities, attributes, entity set, relationship,
relationship set, constraints, sub classes, super class, inheritance, specialization, generalization using ER
Diagrams. SQL: Creating tables with relationship, implementation of key and integrity constraints, nested
queries, sub queries, grouping, aggregation, ordering, implementation of different types of joins,
view(updatable and non-updatable), relational set operations.
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), Fifth Normal Form (5NF).
UNIT V
Transaction Concept: Transaction State, Implementation of Atomicity and Durability, Concurrent
Executions, Serializability, Recoverability, Implementation of Isolation, Testing for Serializability, Failure
Classification, Storage, Recovery and Atomicity, Recovery algorithm.
Indexing Techniques: B+ Trees: Search, Insert, Delete algorithms, File Organization and Indexing, Cluster
Indexes, Primary and Secondary Indexes , Index data Structures, Hash Based Indexing: Tree base Indexing
,Comparison of File Organizations, Indexes and Performance Tuning
Disclaimer :
We are not responsible for any loss of data /or any other information by visiting this website. We just providing previous papers to help the students who need previous papers to prepare themselves. This downloaded from internet source just to education purpose only.
Thank you.
Feel free to contact us, if you want any other courses or Tutorials or any other information .
We'll always try to helps you better learn something