WELCOME TO TECHNICAL PUBLICATIONS
You have no items in your shopping cart.
Close
Filters
Search

DECODE -Database Management System

Prof. Seema V. Kedar ISBN-9789333206488
10% Discount
₹ 140.00
₹ 126.00
+ -

Unit - I
Introduction : An overview of database management system, Database system Vs file system, Database system concept and architecture, Data model schema and instances, Data independence and database language and interfaces, Data definitions language, DML, Overall database structure.
Data Modeling using the Entity Relationship Model : ER model concepts, Notation for ER diagram, Mapping constraints, Keys, Concepts of super key, Candidate key, Primary key, Generalization, Aggregation, Reduction of an ER diagrams to tables, Extended ER model, Relationship of higher degree. (Chapter - 1)
Unit - II
Relational Data Model and Language : Relational data model concepts, Integrity constraints, Entity integrity, Referential integrity, Keys constraints, Domain constraints, Relational algebra, Relational calculus, Tuple and domain calculus.
Introduction on SQL : Characteristics of SQL, Advantage of SQL, SQL data type and literals, Types of SQL commands, SQL operators and their procedure, Tables, Views and indexes, Queries and sub queries. Aggregate functions, Insert, Update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL. (Chapter - 2)
Unit - III
Database Design and Normalization : Functional dependencies, Normal forms, First, Second, Third normal forms, BCNF, Inclusion dependence, Lossless join decompositions, Normalization using FD, MVD and JDs, Alternative approaches to database design. (Chapter - 3)
Unit - IV

Transaction Processing Concept : Transaction system, Testing of serializability, Serializability of schedules, Conflict and view serializable schedule, Recoverability, Recovery from transaction failures, Log based recovery, Checkpoints, Deadlock handling.
Distributed Database : Distributed data storage, Concurrency control, Directory system. (Chapter - 4)
Unit - V
Concurrency Control Techniques : Concurrency control, Locking techniques for concurrency control, Time stamping protocols for concurrency control, Validation based protocol, Multiple granularity, Multiversion schemes, Recovery with concurrent transaction, Case study of Oracle. (Chapter - 5)

 

Unit - I
Introduction : An overview of database management system, Database system Vs file system, Database system concept and architecture, Data model schema and instances, Data independence and database language and interfaces, Data definitions language, DML, Overall database structure.
Data Modeling using the Entity Relationship Model : ER model concepts, Notation for ER diagram, Mapping constraints, Keys, Concepts of super key, Candidate key, Primary key, Generalization, Aggregation, Reduction of an ER diagrams to tables, Extended ER model, Relationship of higher degree. (Chapter - 1)
Unit - II
Relational Data Model and Language : Relational data model concepts, Integrity constraints, Entity integrity, Referential integrity, Keys constraints, Domain constraints, Relational algebra, Relational calculus, Tuple and domain calculus.
Introduction on SQL : Characteristics of SQL, Advantage of SQL, SQL data type and literals, Types of SQL commands, SQL operators and their procedure, Tables, Views and indexes, Queries and sub queries. Aggregate functions, Insert, Update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL. (Chapter - 2)
Unit - III
Database Design and Normalization : Functional dependencies, Normal forms, First, Second, Third normal forms, BCNF, Inclusion dependence, Lossless join decompositions, Normalization using FD, MVD and JDs, Alternative approaches to database design. (Chapter - 3)
Unit - IV

Transaction Processing Concept : Transaction system, Testing of serializability, Serializability of schedules, Conflict and view serializable schedule, Recoverability, Recovery from transaction failures, Log based recovery, Checkpoints, Deadlock handling.
Distributed Database : Distributed data storage, Concurrency control, Directory system. (Chapter - 4)
Unit - V
Concurrency Control Techniques : Concurrency control, Locking techniques for concurrency control, Time stamping protocols for concurrency control, Validation based protocol, Multiple granularity, Multiversion schemes, Recovery with concurrent transaction, Case study of Oracle. (Chapter - 5)

 

Write your own review
  • Only registered users can write reviews
  • Bad
  • Excellent
Customers who bought this item also bought

DECODE-Principles of Programming Languages

A. A. Puntambekar ISBN-9789333219488
10% Discount
₹ 99.00 ₹ 110.00

DECODE-Design & Analysis of Algorithms

DECODE ISBN-9789333206389
10% Discount
₹ 126.00 ₹ 140.00

DECODE-Cyber Security

Vandana Gupta ISBN-9789333206228
10% Discount
₹ 86.00 ₹ 95.00

DECODE- Managerial Economics

V. S. Bagad ISBN-9789333220194
10% Discount
₹ 68.00 ₹ 75.00