Skip to main content
Home
  • Home
  • Learn
    • Courses
      • Programming in C
      • Operating Systems
      • Mathematics
      • Digital Logic Design
      • Database Management System
      • Data Structures
      • Computer Organisation
      • Computer Networks
      • Compiler design
      • Algorithms
      • Theory of Computation
  • Practise
    • Doubts
    • Solved Examples
    • Virtual GATE
  • Quiz
  • Class Rooms
  • Blog
  • More
    • Reach to us
      • Contact Us
      • Request a Topic
      • Join us
      • Internship
      • Teach with Techtud
      • GATE 2018 Feedback
    • Your Interview
      • Professor's Interview
      • Research Scholar's Interview
      • Exam topper's interview
    • About
      • About Techtud
      • The Team
      • User Levels and Credentials
      • Benefits
      • Earn Techtud Tee
Database Management System
  • Introduction
    • Database & DBMS
    • Database Vs File System
    • Data Model
    • Schema, Instance & Metadata
    • View of Data
    • Data Independence
    • Database Abstraction
    • Database Language
    • Database Users
    • Database Architecture
  • ER Model
    • Database Design Process
    • ER Diagram
    • Entity, Entity Type, Entity Set
    • Attributes, Domain
      • Simple & Composite
      • Single Valued Vs Multivalued
      • Stored Vs Derived
      • Null Values
      • Complex Attr.
    • Relationship
    • Key Attribute
    • Notation for ER Diagram
    • Relationship Constraints
      • Cardinality Ratio
      • Participation Constraints
    • Weak Entity
    • Relationship Attribute
    • Specialization
    • Generalization
    • Aggregation
    • ER Model to Relational Table
  • Database Design
    • Introduction
    • Functional Dependency (basic)
    • Key Attribute
      • Super Key, Candidate Key and Primary Key
      • Relation Between SK, CK and PK
      • Finding Candidate Key
      • Foreign Key
    • Referential Integrity Constraint
    • Database Design Goals
    • Functional Dependency
    • X - Closure
    • Inference Rule
    • F - Closure
    • Cover of set of FDs
    • Canonical Cover
    • Fully, Partial, Transitive & Trivial FD
    • Prime & Nonprime Attribute
    • Normalization
      • First Normal Form (1NF)
      • Second Normal Form (2NF)
      • Third Normal Form (3NF)
      • Boyce Codd Normal Form (BCNF)
      • Fourth Normal Form (4NF)
      • Fifth Normal Form (5NF)
      • A Comparative Study
    • Dependency Preserving Decomposition
    • Lossless Join Decomposition
  • Query Language
    • Relation Algebra
      • Select Operation
      • Project Operation
      • Union Compatibility & Union
      • Intersection
      • Cross Product
      • Rename
      • Division
      • Join Operation
        • Inner Join
        • Outer Join
      • The Complete Set of Operation
    • Relational Calculus
      • Tuple Relational Calculus
        • Using Quantifiers
        • Well Known Transformation Formula
        • Transforming Quantification and Safe Expression
      • Domain Relational Calculus
    • SQL
      • Data Types
      • CREATE and DROP Database
      • CREATE Table
      • ALTER and DROP Table
      • INSERT
      • SELECT
      • DISTINCT
      • LIKE (Pattern matching)
      • Subqueries or Nested Queries
      • ORDER BY
      • Set Comparison Operator
      • Aggregate Function
      • GROUP BY
      • HAVING Clause
      • Correlated Nested Query
      • EXIST Function
      • UNIQUE Function
      • JOIN
        • INNER JOIN
        • OUTER JOIN
      • Natural JOIN
      • Views
      • NULL Values in SQL
  • Transaction Management
    • ACID Property
    • States of a Transaction
    • Problem with concurrent execution
    • Failure and Recovery
    • Schedule and Classification
      • Recoverable and Nonrecoverable Schedule
      • Cascadeless Schedule
      • Strict
    • Result Equivalence
    • Conflict Equivalence
    • Serializability
      • Conflict Serializability
      • View Serializability
    • Isolation Level
  • Concurrency Control
    • Introduction
    • Simple Locking Protocol
    • 2-Phase Locking Protocol
      • Basic 2-Phase Locking
      • Conservative 2-Phase Locking
      • Strict 2-Phase Locking
      • Rigorous 2-Phase Locking
    • Graph-Based Protocol
    • Multiple Granularity
    • Timestamp-Based Protocols
      • Basic Timestamp-Ordering Protocol
      • Thomas’ Write Rule
  • File Structure
  • Index Structure for File
  • Notes
  • Video
  • Example
  • Resource
  • Doubts
  • Quiz
Previous
Next
  • Which of the expression is safe -VirtualGATE-17
    • Virtual GATE
    • 3 years 3 months ago

Quick Links

  • Doubts

About

  • The Team
  • User Levels & Credentials

Reach to Us

  • Contact Us
  • Join Us
  • Request a Topic

Media Coverage

TOI
YS
BS

Subscribe

Proudly supported by OpenSense Labs