Login

Home ×
Books Electronics Grocery Fruit and Vegetable

DATABASE MANAGEMENT SYSTEM (Aditya Publication)

150

Hurry, Only 5 left!

10 Days Replacement Policy
Publisher Aditya Publication (2021)
ISBN 9789389271720
Country of Origin India
Format Paper Back
Delivery
Check
Enter pincode for exact delivery dates/charges

Author(s)

PRODUCT DESCRIPTION

SYLLABUS

DATABASE MANAGEMENT SYSTEM

Unit-1: Database System Applications, Database Systems versus File Systems, View of Data, Data Models, Database Languages, Database Users and Administrators, Transaction Management, Database System Structure, Application architectures, History of Database Systems. Entity-Relationship Model, Basic Concepts, Constraints, Keys, Design Issues, Entity-Relationship Diagram, Weak Entity Sets, Extended E-R Features, Design of an E-R Database Schema, Reduction of an E-R Schema to Tables.

Unit-2: Relational Model: Structure of Relational Databases, The Relational Algebra, Extended Relational-Algebra Operations, Modification of the Database, Views, The Tuple Relational Calculus, The Domain Relational Calculus. SQL: Basic Structure, Set Operations, Aggregate Functions, Null Values, Nested Subqueries, Views.

Unit-3: Integrity and Security, Domain Constraints, Referential Integrity, Assertions, Triggers, Security and Authorization, Authorization in SQL, Encryption and Authentication, Relational-Database Design:, First Normal Form, Pitfalls in Relational-Database, Design, Functional Dependencies, Decomposition, BCNF, Third, Fourth and more Normal Forms, Overall Database Design Process.

Unit-4: Query Processing: Overview, Measures of Query Cost, Selection Operation, Sorting, Join Operation, Other Operations, Evaluation of Expressions, Query Optimization: Overview, Estimating Statistics of Expression Results, Transformation of Relational Expressions, Choice of Evaluation Plans, Materialized Views.

Unit-5: Transaction Management: Transaction Concept, Transaction State, Implementation of Atomicity and Durability, Concurrent Execution, Serializability, Recoverability, Implementation of Isolation, Transaction Definition in SQL, Testing for Serializability.

Unit-6: Concurrency Control: Lock-Based Protocols, Timestamp-Based Protocols, Validation-Based Protocols, Multiple Granularity, Multiversion Schemes, Deadlock Handling, Insert and Delete Operations Weak Levels of Consistency, Concurrency in Index Structures. Recovery System, issues & solutions.

Specifications

General

Category Books - Engineering - Computer Science - Semester-VI
Language English
Pages 290
Weight 250 GM
Dimensions 10(l) * 1(w) *10(h) CM