Database Management Systems book by Seema Kedar
Name of the Book: Database Management System by Seema Kedar
Author(s) Name: Seema Kedar
Name of the Publisher: Technical Publications
Book Format: PDF
Book Language: English
Database Management System by seema kedar is one of the most important and useful book for Anna University Semester III Computer Science Engineering (CSE)/ Information Technology (IT) Students. This Textbook is also useful to Students who were prepared for Competitive Exams.
Table of Contents of Database Management System by Seema Kedar
DBMS : Basic concepts, Advantages of a DBMS over file-processing systems, Data abstraction, Database languages, Data models and Data independence, Components of a DBMS and overall structure of a DBMS, Multi-User DBMS architecture, System catalogs.
Data Modeling : Basic concepts, Entity, Attributes, Relationships, Constraints, Keys, E-R and EER diagrams: Components of E-R model, Conventions, Converting E-R diagram into tables, EER model components, Converting EER diagram into tables
Relational Model : Basic concepts, Attributes and Domains, Codd s rules, Relational integrity: Nulls, Entity, Referential integrities, Enterprise constraints, Views, Schema diagram.
Relational Query Languages : Relational algebra and Relational calculus: Tuple relational and Domain relational calculus.
Introduction to SQL : Characteristics and Advantages, SQL data types and Literals, DDL, DML, SQL Operators,
Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updation using views, Indexes, Nulls.SQL DML
Queries : SELECT Query and Clauses, Set operations, Predicates and Joins, Set membership, Tuple variables, Set comparison, Ordering of tuples, Aggregate functions, Nested queries, Database modification using SQL insert, Update and Delete queries, Concept of stored procedures and triggers,
Introduction to QBE and QUEL programmatic SQL: Embedded SQL, Dynamic SQL, ODBC.Database Analysis and Design Techniques : Information systems lifecycle, Application lifecycle, Planning, System definition, Requirement analysis, Design, DBMS selection,
Application design: Transaction and User-interface design, Prototyping, Implementation, Data conversion and loading, Testing, Data and Database administration, Fact-Finding techniques.
Relational Database Design : Purpose of normalization, Data redundancy and Update anomalies, Functional dependencies,
The process of normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF and DKNF.Storage and File Systems : Secondary storage, RAID, File organization, Indices, Static and dynamic hashing,
B -trees and Trees Introduction to Query Processing : Overview, Measures of query cost, Selection and Join operations, Evaluation of expressions, Introduction to query optimization, Estimation, Transformation of relational expressions.
Transaction Management : Basic concept of a transaction, Properties of transactions, Database architecture, Concept of schedule, Serial schedule,
Serializability: Conflict and View, Cascaded aborts, Recoverable and Non-recoverable schedules, Concurrency control: Need, Locking methods, Deadlocks, Timestamping methods, Optimistic techniques, Multi-Version concurrency control, Different crash recovery methods such as shadow-paging and log-based recovery: Deferred and Immediate, Checkpoints.
Object-Oriented Databases : Need of OODBMS, Storing objects in relational database, Introduction to OO data models, Persistent programming languages, Pointer swizzling techniques, Persistence, Object management group, Object database standard ODMG.
Database Architectures : Centralized and Client-Server architectures, Introduction to distributed database systems.
Introduction to DBMS SQL and Query Optimization Transaction Processing and Concurrency Control Trends in Database Technology Advanced Topics.
Download Book from Amazon