Database Management

Database Management (Paperback, A. A. Puntambekar)

Share

Database Management  (Paperback, A. A. Puntambekar)

इस प्रोडक्ट पर राय देने वाले पहले व्यक्ति बने
₹424
430
1% off
i
उपलब्ध ऑफ़र
  • Bank Offer5% cashback on Flipkart Axis Bank Credit Card upto ₹4,000 per statement quarter
    T&C
  • Bank Offer5% cashback on Axis Bank Flipkart Debit Card up to ₹750
    T&C
  • Bank OfferFlat ₹10 Instant Cashback on Paytm UPI Trxns. Min Order Value ₹500. Valid once per Paytm account
    T&C
  • Delivery
    Check
    Enter pincode
      डिलीवरी31 जुलाई, गुरुवार
      ?
    जानकारी देखें
    लेखक
    Read More
    Highlights
    • Binding: Paperback
    • Publisher: TECHNICAL PUBLICATIONS
    • ISBN: 9789391567866
    • Edition: THIRD, 2023
    • Pages: 456
    सर्विस
    • कैश ऑन डिलीवरी उपलब्ध
      ?
    Seller
    TechnicalPublications
    3.9
    • 7 Days Replacement Policy
      ?
  • अन्य विक्रेता देखें
  • जानकारी
    Unit I Introduction to DBMS Introduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, Data Abstraction and Database System Structure. Relational Model : Structure of relational databases, Domains, Relations, Relational algebra - fundamental operators and syntax, relational algebra queries, tuple relational calculus. Entity-Relationship model : Basic Concepts, Entity Set, Relationship Sets and Weak Entity Sets, Mapping Cardinalities, Keys, E-R diagrams, Design Issues, Extended E-R Features, Converting E-R & EER diagram into tables. (Chapter - 1) Unit II Relational Database Design Basic concepts, CODD's Rules, Relational Integrity : Domain, Referential Integrities, Enterprise Constraints, Database Design : Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, Algorithms for Decomposition, 2NF, 3NF, 4NF and BCNF. (Chapter - 2) Unit III Basics of SQL DDL, DML, DCL, Structure : Creation, Alteration, Defining constraints - Primary key, Foreign key, Unique key, Not null, Check, IN operator, Functions - Aggregate Functions, Built-in Functions - Numeric, Date, String Functions, Set operations, sub-queries, correlated subqueries, Use of group by, having, order by, join and its types, Exist, Any, All, view and its types. Transaction control commands : Commit, Rollback, Save-point PL/SQL Concepts : Cursors, Stored Procedures, Stored Function, Database Triggers. (Chapter - 3) Unit IV Database Transactions Management Basic concepts of a Transaction, Transaction Management, Properties of Transactions, Concept of Schedule, Serial Schedule, Serializability : Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control : Need, Locking Methods, Deadlock handling and Time-stamp based Protocols. (Chapter - 4) Unit V Parallel Databases Unit VI Distributed Databases
    Read More
    Specifications
    Book Details
    Publication Year
    • 2023
    Book Type
    • TEXT BOOK
    Number of Pages
    • 456
    University Books Details
    Degree/Diploma
    • DEGREE
    Additional Features
    Age Group
    • 18 TO 60 YEARS
    Safe and Secure Payments.Easy returns.100% Authentic products.
    आप यह भी खरीदना चाहेंगे
    मेडिकल और नर्सिंग की किताबें
    कम से कम 50% की छूट
    Shop Now
    लोकप्रिय मनोविज्ञान की किताबें
    कम से कम 50% की छूट
    Shop Now
    जीवनियां और आत्मकथाएं
    कम से कम 50% की छूट
    Shop Now
    भाषा और अनुवाद की किताबें
    कम से कम 50% की छूट
    Shop Now
    Back to top