dbms-notes-2023

DBMS IMPORTANT

Unit 1 -

4 Marks

1. Advantages of data base management  system
2. Data abstract
3. Data independence
4. Views of data

12M Marks

1. Sql commands, architecture, database users, data independence
2. Compare file processing vs dbms, abstraction, views of data applications of dbms
3. Database Languages
4. Database Architecture - Use PPT

Unit 2 -

4M Marks

1. Conversion of ER Diagrams to Tables
2. Database Design
3. Design Process
4. Keys , Attributes and Constraints - Use PPT

12M marks

1. ER Model
2. ER Diagram
3. Query Processing in DBMS
4. Mapping Cardinality
5. Data Models

Unit 3 -

4M Marks

1. Basics of SQL - DDL, DML, DCL, TCL
2. SQL Constraints
3. Aggregate Functions
4. Scalar Functions
5. Trigger
6. Transaction Control Language Commands - Commit, Rollback, Savepoint

12M Marks

1. Basics of SQL (Detailed and Explained)
2. Sub Queries, correlated sub queries
3. Nested Queries, views and it's types
4. Functions
5. PL/SQL Concepts - Cursors

Unit 4 -

4 Marks

1. Dependencies
2. Relational Algebra

12 Marks

1. Normalisation - 1NF, 2NF, 3NF and BCNF

Unit 5 -

4 Marks

1. ACID
2. Locking and Two phase locking protocol
3. Transaction control

12 Marks

1. Concurrency
2. Serializability
3. Deadlock