DBMS Important ------- 1 Introduction Database Concepts --------------- 5 marks 1- File System Vs database system +++++ 2- DBA? its function ++++ 3- DBMS architecture ++ ------ 2 EntityRelationship Data Model -------- 10 marks 4- Features of EER (Generalization, Specialization, Aggregation) ++++++ 5- ER diagram example.(University **, bookstore, bank) +++++ ---- 3 Relational Model and Algebra ----------- 10 marks 6- Operations of relational algebra ++++++ -->select, --> project, -->Set-difference, --> Assignment --> join --> Division -->Cartesian product --> rename ---------- 4 Structured Query Language (SQL)---------- 20 marks 7-Nested and complex Quarries example based on SQL ++++ 8- Keys of SQL +++ 9- SQL languages types with eg. DDL DML TCL DCL ++ ---------- 5 Integrity and Security in Database:---------- 5 marks 10-Trigger ----------6 Relational Database Design -------------------10 marks 11 Steps for ER to Relational Tables eg. + 12 Normalization with eg. ++++ --------- 7 Transactions Management and Concurrency ----- 25 marks 13- Transaction ? Properties ? +++++ 14 - ACID properties +++ 15 -Checkpoint & Log based recovery ++++++ 16 - Shadow paging ++ 17-Deadlock handling ++++++ 18 -serializability ? conflict and view serializability ++ 19 - Validation based protocol ++ 20- views in SQL ++ 21 - 2PL & Time based protocol ++ 22 Cost Based Query Optimization ++++ imp
Posted on: Tue, 04 Nov 2014 13:21:03 +0000
Trending Topics
Recently Viewed Topics
© 2015