Skip to content
  • Home
  • About
  • Contact
  • Write For Us
  • Search

TECH tunnel

Learn and Grow

  • Machine Learning
  • C#
    • MVC Technology
    • Web Development
  • DBMS
    • Normalization & Normal Forms
      • Types of Functional Dependencies in Normalization
      • Super Key, Candidate Key and Primary Key
      • How to find attribute closure using Functional Dependency
      • Procedure to determine Candidate key using attribute closure
      • Prime and Non Prime Attributes
      • What are different Normal Forms in DBMS
      • BCNF Decomposition | A step by step approach
    • Relational Model
      • Relational Algebra – Degree, Cardinality, Domain, Union Compatibility and Operators
      • Cartesian Product
      • Join Operators in DBMS
      • Join Types – inner, left outer, right outer and outer join
      • Join Conditions – Natural Join, On Condition, Using Attribute
    • Transactions and Concurrency control
      • What is Transaction and ACID Properties
      • What is Atomicity in DBMS?
      • Transaction Consistency in detail
      • Transaction Isolation in detail
      • Transaction Durability in detail
      • Precedence Graph to check Conflict Serializable Schedule

DBMS

DBMS Notes for GATE 2019

Date: November 19, 2017Author: Ashutosh Tripathi 0 Comments
  • Relational Model
    • Relational Algebra – Degree, Cardinality, Domain, Union Compatibility and Operators
    • Cartesian Product
    • Join Operators in DBMS
    • Join Conditions – Natural Join, On Condition, Using Attribute
    • Join Types – inner, left outer, right outer and outer join
  • Normalization & Normal Forms
    • Types of Functional Dependencies in Normalization
    • Super Key, Candidate Key and Primary Key
    • How to find attribute closure using Functional Dependency
    • Procedure to determine Candidate key using attribute closure
    • Prime and Non Prime Attributes
    • Normal Forms
    • Procedure to decompose a given relation in BCNF – BCNF Algorithm
  • Transactions and Concurrency control
    • What is Transaction and ACID Properties
    • Atomicity in detail
    • Transaction Consistency in detail
    • Transaction Isolation in detail
    • Transaction Durability in detail
    • How to check Conflict Serializability using Precedence Graph Algorithm

Share this:

  • Twitter
  • Facebook
  • Google
  • Print
  • Email
  • LinkedIn
  • Reddit
  • WhatsApp

Like this:

Like Loading...

Related

ACID PropertiesDBMSJoin TypesNormal FormsTransaction Management

Published by Ashutosh Tripathi

View all posts by Ashutosh Tripathi

Post navigation

Previous Previous post: Types of Functional Dependencies in Normalization
Next Next post: Convert local path to UNC (Universal) File Path using Java Script ActiveXObject

Leave a Reply Cancel reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Popular Posts

  • Covariance and Correlation
  • What is Linear Regression? Part:2
  • Serial Schedules, Concurrent Schedules and Conflict Operations
  • Types of Functional Dependencies in Normalization
  • What is Linear Regression? Part:1
  • Prime and Non Prime Attributes
  • Difference between DBMS and RDBMS
  • Relational Algebra - Degree, Cardinality, Domain, Union Compatibility and Operators
  • How to find attribute closure using Functional Dependency
  • DBMS

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 414 other followers

Follow me on Twitter

My Tweets

Category Cloud

.Net Framework 4.7.1 C# Conflict Serializability Data Analysis DBMS Java Script Linear Regression Machine Learning MVC Technology Normal Forms Precedence Graph Serializability Transaction Managemenet Web Development

© 2019 TECH tunnel

Create a website or blog at WordPress.com

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: