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....
Database(DBMS)
78 posts
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 tha...
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 ...
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 ...
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 c...
What is the main difference between DBMS and RDBMS?
If you are in college then it’s fine else remember your old college days when you were preparing for DBMS viva. That was a very interesting time...
Functions of DBMS / What are the functions of DBA in DBMS?
Within this blog post(Functions of DBMS), we are going to discuss the What are functions of DBA in DBMS. What are the DBMS and goals of DBMS? What is ...
Database Constraints: Key constraints in DBMS
Hello Friends, In this blog post(Key constraints in DBMS), I am going to explain the database constraints that are most excessively used while designi...