Home / Our Books /  Engineering Books < EE Branch,CS/IT Branch / Database Management Systems
×

More Books related to same category

Fluid Mechanics

Rs. 180

Advance Database Management System

Rs. 180

8085 Microprocessor

Rs. 270

Optical Fiber Communication

Rs. 290

Database Management Systems

By Suresh Fatehpuria

4 Ratings | 1 Reviews

Rs. 300

×
×
×
×
×

Specifications of Database Management Systems

Book Details

  • 978-93-82247-07-4
  • English
  • 2019
  • -
  • -

Contents

  • Unit 1. Introduction: Objective, scope and outcome of the course.
    Unit 2. Introduction to database systems: Overview and History of DBMS. File System v/s DBMS.Advantage of DBMS Describing and Storing Data in a DBMS.Queries in DBMS.Structure of a DBMS. Entity Relationship model: Overview of Data Design Entities, Attributes and Entity Sets, Relationship and Relationship Sets. Features of the ER Model- Key Constraints, Participation Constraints, Weak Entities, Class Hierarchies, Aggregation, Conceptual Data Base, and Design with ER Model- Entity v/s Attribute, Entity vs Relationship Binary vs Ternary Relationship and Aggregation v/s ternary Relationship Conceptual Design for a Large Enterprise.
    Unit 3. Relationship Algebra and Calculus: Relationship Algebra Selection and Projection, Set Operations, Renaming, Joints, Division, Relation Calculus, Expressive Power of Algebra and Calculus. SQL queries programming and Triggers: The Forms of a Basic SQL Query, Union, and Intersection and Except, Nested Queries, Correlated Nested Queries, Set-Comparison Operations, Aggregate Operators, Null Values and Embedded SQL, Dynamic SQL, ODBC and JDBC, Triggers and Active Databases.
    Unit 4. Schema refinement and Normal forms: Introductions to Schema Refinement, Functional Dependencies, Boyce-Codd Normal Forms, Third Normal Form, Normalization-Decomposition into BCNF Decomposition into 3- NF.
    Unit 5. Transaction Processing: Introduction-Transaction State, Transaction properties, Concurrent Executions. Need of Serializability, Conflict vs. View Serializability, Testing for Serializability, Recoverable Schedules, Cascadeless Schedules.
    Unit 6. Concurrency Control: Implementation of Concurrency: Lock-based protocols, Timestamp-based protocols, Validation-based protocols, Deadlock handling, Database Failure and Recovery: Database Failures, Recovery Schemes: Shadow Paging and Log-based Recovery, Recovery with Concurrent transactions.

     

Reviews of Database Management Systems

  • 4
    Average Rating Based on 4 ratings
  • 0
  • 1
  • 0
  • 0
  • 0

seema jangid

04 Sep 2013

stepwise explanation

enhance our knowledge about database concepta as database is essential part of every organisation so concepts of dbms should be clear and it have good diagrams and easy explanation of topic in step wise manner so easy to understand

See All >