PG-TRB - COMPUTER SCIENCE - UNIT - II - DATABASE SYSTEM CONCEPTS AND ARCHITECTURE

PG-TRB - COMPUTER SCIENCE - UNIT - II - DATABASE MANAGEMENT SYSTEM - Database System Concepts and Architecture

Unit II - DATABASE MANAGEMENT SYSTEM
Database System Concepts and Architecture: Data Models, Schemas and
Instances, Three-Schema Architecture and Data Independence, Database
Languages and Interfaces, Centralized and Client/Server Architectures for
DBMS.
Data Modeling: Entity Relationship Diagrams, Relational Model, Constraints,
Languages, Design and Programming, Relational Database Schemas, Relational
Algebra and Relational Calculus, Codd Rules.
SUBJECT : COMPUTER SCIENCE
SYLLABUS
70
Normalization for Relational Databases: Functional Dependencies and
Normalization, Algorithms for Query Processing and Optimization, Transaction
Processing, Concurrency Control Techniques, Database Recovery Techniques,
Object and Object-Relational Databases, Database Security and Authorization.
Constraints and Views: Constraints and its types, Integrity constraints, Check
constraints, Referential constraints, Introduction to views, updates on views,
comparison between tables and views.
Transaction management and Concurrency control: Transaction
management, ACID properties, serializability and concurrency control, Lock
based concurrency control (2PL, Deadlocks), Time stamping methods, optimistic
methods, database recovery management


Click link below:    • NEET / JEE MAINS - FACULTY WANTED - ONLINE...