Book Details

 Data Base Management Systems(DBMS)

Data Base Management Systems(DBMS)

Published by uLektz

Course Code:BECS2208

Author:uLektz

University: Biju Patnaik University of Technology (BPUT)

Regulation:2010

Categories:Computer Science

Format : ico_bookePUB3 (DRM Protected)

Type :eBook

Rs.413 Rs.223 Rs.46% off

Preview Buy Now

Description :BECS2208 Data Base Management Systems(DBMS) Data Base Management Systems(DBMS) of BECS2208 for Biju Patnaik University of Technology (BPUT), 2010 Author: uLektz, Published by uLektz. It is an eBook of ePUB (DRM Protected). No physical or print copy will be shipped. This eBook can accessed via uLektz Platform.

Note : No printed book. Only ebook. Access eBook using uLektz apps for Android, iOS and Windows Desktop PC.

Topics
MODULE I : DATABASE SYSTEM ARCHITECTURE AND DATA MODELS

1.1 Database System Architecture - Data Abstraction, Data Independence, Data Definitions and Data Manipulation Languages

1.2 Data models - Entity Relationship(ER), Mapping ER Model to Relational Model, Network

1.3 Relational and Object Oriented Data Models, Integrity Constraints and Data Manipulation Operations

MODULE II : RELATION QUERY LANGUAGES AND RELATIONAL DATABASE DESIGN

2.1 Relation Query Languages, Relational Algebra and Relational Calculus, SQL

2.2 Relational Database Design: Domain and Data dependency, Armstrong's Axioms, Normal Forms, Dependency Preservation, Lossless design

2.3 Query Processing Strategy

MODULE III: TRANSACTION PROCESSING AND DATABASE RECOVERY SYSTEM

3.1 Transaction processing: Recovery and Concurrency Control. Locking and Timestamp based Schedulers

3.2 Database Recovery System: Types of Data Base failure & Types of Database Recovery, Recovery techniques

loading