A5Theory Learn Tech. Build Digital. Grow Together.
Get a Quote Mock Tests
Get Free Quote Mock Tests
Anurag

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: 760
  • Comments: 72

What is super key in DBMS?

superkey-feature-img

Super key(What is a super key in DBMS) is the combination of one or more attributes to uniquely identify a tuple. For example, we have a student table with attributes (stu_rollno, stu_name, stu_add, stu_branch, stu_Aadharno). Within this blog(What is the…

What is Key in DBMS?

key-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…

3NF – What is the 3NF example?

3NF-third-normal-form

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…

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…

1NF – What is 1NF example?

1NF-first-normal-form

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…

What is normalization with an example?

normalization-and-its-need

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…