This One Week Series is Written in English Language in Question Answer Series According to syllabus of Rajasthan University.
UNIT-I. Database System Concepts A Architecture Overview of DBMS
UNIT-II Data Modeling: Data modeling using the Entity Relationship Model: BR model concepts, notation for ER diagram, mapping constraints, keys, Concedes of Super Key, candidate key. primary key, Generalization, aggregation Relational Algebra: Fundamental operations of relational algebra & their implementation, interdependence of operations
UNIT-III Database-Design Functional-dependencies, tostess decomposition, 1",2 23 nominal forms, dependency preservation, boyce codd NF. Introduction lo Transactions, transaction states, Security: Access control, backup, recovery. Maintenance and performance.
UNIT-IV Introduction to SQL: Characteristics of SQL, Advantages of SQL, SQL data types and Literals. Types of SOL commands, SQL operators and their procedure, Table, views and indexes. Queries and sub queries, Aggregate functions, insert, update and delete operations, Joins, Unions, Intersection, Minus in SQL
UNIT-V Introduction to Advance DBMS: Object-based Databases: Object-Oriented Databases: Object-oriented data model. Object Oriented Languages, Persistent Programming Languages. Object-Relational Databases Nested Relations, Storage for Object Databases Distributed Databases Distributed Data Storage, Distributed Transactions, Commit protocol, Concurrency Control in Distributed Databases, Availability, Distributed Query Processing
Its also useful for Shekhawati, Matsya, Brij, JNU, MGSU, MDS, Kota, MLSU University Students. Almost All Units are covered according to syllabus.