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

More Books related to same category

Engineering Mechanics

Rs. 270

Mechtronics

Rs. 250

Power System Analysis

Rs. 135

Database Management Systems

By Suresh Fatehpuria

4 Ratings | 1 Reviews

Rs. 225

×
×
×
×
×

Specifications of Database Management Systems

Book Details

  • 978-93-82247-07-4
  • English
  • 2012, 2013, 2014
  • Paper Back
  • 384

Contents

  • 1. Introduction to Database Management Systems
    Objectives, Introduction, File System vs DBMS, History of DBMS, Describing and Storing Data in a DBMS, Data Abstraction (View of Data), Data Independence, Data Model, Database System Architecture, Users and Database Administrator, Query Processor, Storage Manager, Disk Storage, Queries in DBMS, Applications of DBMS, Review Questions.
     
    2. Entity Relationship Model
    Objectives, Entity Relationship Model, Structure of Relational Database, Database Schema and Instances, Concept of Keys, The Entity Relationship Model Components, Entity, Attributes, Values, Entity Sets, Relationship Sets, Participation, Role, Degree of a Relationship Set, Attributes Revisited, Constraints, Entity Relationship Diagram, E-R notations, Weak Entity Sets, Design Issues, Use of Entity Sets versus Attributes, Use of Entity Sets versus Relationship Sets, Binary versus n-ary Relationship Sets, Extended ER Features, Specialization, Generalization, Constraints on Generalization, Aggregation, Case-Study of an Engineering College, Review Question, Gate Questions, Answer Key.
     
    3. Relational Algebra & Relational Calculus
    Objectives, Introduction, Fundamental Operations of Relational Algebra, The Select Operation, The Project Operation, The Union Operation, The Set difference Operation, The Cartesian or Cross Product, The Rename Operation, Additional Relational Algebra Operations, The Set-intersection Operation, The Natural-join Operation, The Division Operation, The Assignment Operation, Extended Relational Algebra Operation, Generalized Projection, Aggregate Function, Outer Join, Modifications in the Database, The Deletion Operation, The Insertion Operation, The Updation Operation, Relational Calculus, Background Definitions, Tuple Relational Calculus, Domain Relational Calculus (DRC), Differences between TRC and DRC, Relational Algebra vs Relational Calculus, Review Questions, Gate Questions, Answer Key.
     
    4. Query Languages-SQL
    Objectives, Introduction, The SQL Data Types, An Example Schema, DDL Commands in SQL, Integrity Constraints, Data Retrieval and Manipulation Commands in SQL (DML Commands), SQL Clauses, Basic Select Statement, Arithmetic Expressions, Row Selection, Comparison Operators, Logical Operators, Sorting of Results: (Using ORDER BY Clause), Set Operations, Aggregate Functions, Single Row Functions, Multirow Functions, Data Retrieval and Manipulation in Multiple Tables: Concept of Foreign Key, Nested Queries, Database Modification, Data Control Language (DCL Statements), Embedded SQL (Static SQL), Concepts for Embedding the SQL Statements, Embedded SQL Program Development, An Embedded SQL Example in C, Error Handling with SQL Code, Dynamic SQL, Dynamic SQL Concepts, Dynamic Statement Execution (Execute Immediate), Views, Cursors, Assertions, JDBC and ODBC, Active Databases, Null Values, Review Questions, Gate Questions, Answer Key.
     
    5. Schema Refinement and Normal Forms
    Objectives, Introduction, Insertion Anomalies, Deletion Anomalies, Updation Anomalies, Functional Dependency (FD), Concept of Full Functional Dependency and Partial Functional Dependency, Closure, Armstrong Axioms, Minimal Cover, Normalization, The First Normal Form (1NF), The Second Normal Form, The Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF) or 3.5 NF, Multivalued Dependencies (MVD), The Fourth Normal Form (4NF), Join Dependencies and The Fifth Normal Form (5NF) (Project-join Normal form or PJNF), Join Dependency (JD), Attribute Preservation, Definition (5NF), Denormalization, Triggers, Review Questions, Gate Questions, Answer Key.
     
    P. Paper

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 >