FULLY SOLVED BOOK LASY 5 YEARS PAPERS SOLVED PLUS GUESS   

DATABASE MANAGEMENT SYSTEMS
SYLLABUS
UNIT I
Introduction - Data Models - Database languages - Transaction - Storage managementDatabase administrator - Users - overall system structure - Entity - Relationship ModelBasic concepts - Mapping constraints - keys - E-R Diagram - Weak Entity Sets- reduction
of E-R Diagram to tables.
UNIT II
Relational Model - structure - relational algebra - extended operations - Modifications on
a database - views - SQL - basic structure - set operations - aggregate functions -
Nested Sub queries - derived relations, views.
UNIT III
Integrity constraints - Domain constraints - referential integrity - assertions - triggers -
functional dependencies - relational database design - decomposition - normalization
using functional, multi valued, Join dependencies - Domain - Key Normal form - alternative
approaches.
UNIT IV
Object Oriented data Model - Languages - Object Relational databases: Nested RelationsComplex types and object Orientation - Querying with complex types - creation of complex
values and objects - comparison.
UNIT V
Database System Architectures : Centralized Systems, Client server systems, Distributed
systems, Parallel databases - introduction - inter query - intra query, intra-operation -
interoperation parallelism -distributed databases - distributed data storage - network
transparency - Query processing - Transaction model - Commit protocols - coordinator
selection - concurrency control - deadlock handling - multi database systems.