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

TECH tunnel

Learn and Grow

  • Machine Learning
  • Data Analytics
  • Web Development
  • Gallery
  • Contact
  • DBMS
    • Normalization & Normal Forms
    • Relational Model
    • Transactions and Concurrency control

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
  • 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

  • Prime and Non Prime Attributes
  • Types of Functional Dependencies in Normalization
  • Serial Schedules, Concurrent Schedules and Conflict Operations
  • Relational Algebra - Degree, Cardinality, Domain, Union Compatibility and Operators
  • Implementation of Atomicity and Durability using Shadow Copy
  • Difference between DBMS and RDBMS
  • Employee Attrition Rate Analysis – Insights from IBM HR Data
  • Concurrent Execution in Transaction | DBMS
  • How to find attribute closure using Functional Dependency
  • Gallery

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

Join 420 other followers

Follow me on Twitter

My Tweets

Category Cloud

.Net Framework 4.7.1 C# Conflict Serializability Data Analysis Data Visualization DBMS Java Script Linear Regression Machine Learning MVC Technology Normal Forms Precedence Graph Regression Serializability Storytelling 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: