DBMS Tutorial .What is Data ? Data is a raw fact and figure such as name of person,age, location where is based, or any collection of a distinct small unit of information.
In this article you will explore the list the most commonly asked DBMS interview questions to help you ace your interview! Q1. What are the differences between a DBMS and…
The functional dependency is a relationship that exists between two attributes. It typically exists between the primary key and non-key attribute within a table. Introduced by E. F. Codd, it…
Normalization is the process of organizing the data in the database. It is used to reduce redundancy from a relation or set of relations. It is also used to eliminate…
Boyce–Codd normal form is a normal form used in database normalization. It is a slightly stronger version of the third normal form. BCNF was developed in 1974 by Raymond F.…
A realtion(table) is said to be in Third Normal form (3NF), if it satifies the following condition: Table must be in 2NF Transitive functional dependency of non-prime attribute on any super…
A realtion(table) is said to be in 2NF if it satifies the following condition: Table is in 1NF (First normal form) In the second normal form, all non-key attributes are…
SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data. SQL can perform various tasks…
Data types tells about the nature of the data that can be stored in the database table. SQL data types can be broadly divided into following categories. Numeric data types…
SQL (Structured Query Language) is used to perform operations on the records stored in the database such as updating records, deleting records, creating and modifying tables, views, etc. What is SQL…
The ER model defines the conceptual view of a database. It works around real-world entities and theassociations among them. At the view level, the ER model is considered a good…