security-in-dbms

How to achieve Security in DBMS?

Hello Friends, In this blog post, I am going to explain about security in DBMS. Security has been always a primary concern whether it is security in networks and security in DBMS. DBMS has the collection of large data which can be of either category. There is some data in DBMS which is highly confidential

What is ACID properties in DBMS?

Hello Friends in this blog post I am going to let you know about the ACID properties in DBMS system. ACID properties are associated with consistency, atomicity, durability, and isolation. These acid properties of dbms are used to make our database consistent and authentic. Now I will explain all these four properties below one by

null-in-database

What is the null value in DBMS & problems with null? 2019

A null is basically used to represent the unknown and missing values. But it does not mean that the null value is equivalent to zero or a blank text string. See the example below for the same. Table: Client Client ID First Name Middle initial Last Name City Country 1 John B corner Allenspark Null

superkey-feature-img

What is super key in DBMS?

Super key is the combination one and more attribute to uniquely identify a tuple. For example, we have a student table with attribute (stu_rollno., stu_name, stu_add, stu_branch, stu_Aadharno.) Here we can have several sets of a superkey as given below. stu_rollno. + stu_namestu_rollno. + stu_name + stu_branchstu_Aadharno. + stu_namestu_rollno. + Stu_Aadharstu_Aadharno. + stu_name + stu_branchstu_rollno.

2NF – Second Normal Form

A relation is in 2NF if all the non-prime attributes are fully functionally dependent on the primary key. The non-prime attribute is those which are not a primary key. A database is said in 2NF if every relation of it is in 2NF. Steps for transformation the relation from 1NF to 2NF: Identify the set

1NF-first-normal-form

What is1NF(First Normal Form)? Problems with 1NF?

A relation is in 1NF 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 the corresponding attribute. A database is in first normal form if every relation includes in a database is in 1NF. First normal

normalization-and-its-need

What is Normalization? Why is it needed?

Very first Normalization removes the multivalued attribute, That means there will be single tuple value for one attribute. In simple language, one column will have one value. for example, if we store the phone number in an employee table then each employee will have only one phone number in one single record. Normalization is a

dbms_architecture

DBMS ARCHITECTURE

A database system is divided into a module which takes care of overall responsibility of the full system. As per database architecture database system functioning it is divided into two part. Storage Manager Query processor components Query Processor: Query Processor is further classified into several components with individual functioning which is explained below. DDL Interpreter:

difference-dbms-vs-rdbms

DBMS vs RDBMS: Differences 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 and when you were just supposed to go inside the viva room. You occupied your place and prepared for a bullet shot in the form of a question.

dbmsfucntionfeatureimg

DBMS-Functions of DBMS

    What is the DBMS and functions of DBMS? A database management system is a collection of interrelated data and the set program to access that data. DBMS is basically designed to store a large body of information in a structured form. DBMS involves both defining structures for storage of information and mechanism for

database-constraints

Database Constraints

Hello Friends, In this blog post, I am going to explain about the database constraints which are most excessively used while designing the database. Which are the useful database constraints ? These database constraints are a primary key, unique key, and foreign key. when we start to design the project whether it is small or