Anurag

I am a blogger by passion, a software engineer by profession, a singer by consideration and rest of things that I do is for my destination.

Joined: 02/04/2017
Articles: 759
Comments: 72

Blogging, Database(DBMS)

What is a candidate key in DBMS?

Hello Friends, In this blog post(What is a candidate key in DBMS) we are going to discuss what is a candidate key in DBMS. An attribute or a column in a table that can identify a full tuple or row…

Anurag
13/07/2019

Blogging, Database(DBMS)

What is Key in DBMS?

Hello Friends, In this blog post(What is Key in DBMS), I will let you know about one of the most important and interesting topics of a database which is KEY. What is key in DBMS? While reading the same subject…

Anurag
12/07/2019

Blogging, Database(DBMS)

BCNF- What is the BCNF normal form example?

Boyce code normal form, (BCNF- What is BCNF normal form example) was proposed as a simple form of 3NF, but it was found stricter than 3NF because e very relation in BCNF is also in 3NF. however, a relation in…

Anurag
12/07/2019

Blogging, Database(DBMS)

3NF – What is the 3NF example?

A relation is in 3NF(What is the 3NF example) or the third normal form if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key. By the transitive functional dependency, we mean…

Anurag
11/07/2019

Blogging, Database(DBMS)

2NF – What is a 2NF example?

A relation is in 2NF(What is a 2NF example) or second normal form if all the non-prime attributes are fully functionally dependent on the primary key. The non-prime attributes are those that are not a primary key. A database is…

Anurag
10/07/2019

Blogging, Database(DBMS)

1NF – What is 1NF example?

A relation is in 1NF(What is 1nf example) or first normal form if every tuple has exactly one value for each attribute. In other words, we can say that every column should have a unique or atomic value related to…

Anurag
09/07/2019

Blogging, Database(DBMS)

What is normalization with an example?

Very first Normalization(What is normalization with an example) removes the multivalued attribute, Which means there will be a single tuple value for one attribute. In simple language, one column will have one value. for example, if we store the phone…

Anurag
08/07/2019

Blogging, Database(DBMS)

What do you mean by distributed DBMS and what are its types?

A distributed database management system(DDBMS) is a software system that manages a distributed database while making the distribution transparent to the user. In simple meaning, the whole data of the database is not kept in one place instead it is…

Anurag
06/07/2019

Blogging, Email Marketing

Suspended Email Account: The SMTP Account has been suspended.

Hello Friends, In this blog post we will discuss the most common problem with email marketing users that is The SMTP Account has been suspended. Most online business runners or email marketing users are facing a most common and critical…

Anurag
05/07/2019

Blogging, Database(DBMS)

What is DBMS ARCHITECTURE?

Hello Friends, In this blog post(What is DBMS ARCHITECTURE) we will discuss DBMS architecture. A database system is divided into a module that takes care of the overall responsibility of the full system. Within this blog post(What is DBMS ARCHITECTURE),…

Anurag
04/07/2019