Databases
Domain Constraints in DBMS
Introduction Constraints in DBMS play a key role in Database Management Systems as they ensure data consistency in the Database. They are a set of rules which ensures that data is stored under certain specific conditions and does not lose its consistency when an authorized user accesses the database to
Char and Varchar in SQL
Char In SQL, it is a kind of data used to hold character strings of a given length. When the PAD_CHAR_TO_FULL_LENGTH_SQL mode is active, if the length of the string is less than the set or fixed length, it is padded with additional blank spaces
Functional Dependency in DBMS with examples
What is Functional Dependency in DBMS In Relational Database Management Systems, the data object represents some Entities that are associated with other Entities via some Relationship. But, Relationship is not limited to Entities, it is also found among the attributes of the Entities. This is called Functional Dependency in DBMS.
File Organization in DBMS
Introduction Have you heard something about file organization in DBMS? Do you know what it is? If not, then don't worry. Board Infinity helps you to clear your doubts. In this article, we will discuss file organization in DBMS. In DBMS, there are many different ways to organize files. We
INDEX in SQL
Introduction The database search engine can use indexes, which are specialised lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book's back matter index quite a bit. For instance, if you want to find
DDL and DML Commands: Explanation and Differences
Introduction Have you heard something like DDL commands? Do you know how we can use DML commands? If not, then don't worry. Board Infinity will help you to clear all these doubts. In this article, we will discuss DDL and DML commands. We will discuss what those commands are and
Structure of DBMS
What is the Structure of a Database Management System? Database Management System is the combination of a Database and all the functionalities to organize and manage the data. It is software that allows us to efficiently interact with data at various levels of abstraction. As Database Management System is a
ORDER BY in SQL
Introduction This article mainly explains the ORDER BY clause present in MySQL. ORDER BY clause is generally used to sort the fetched data from the query in ascending or descending order for one or more columns from the database table. The default order used in the ORDER BY clause is
GROUP BY in SQL
Introduction Finding summary rows, such as "find the number of consumers in each country," is done with the GROUP BY statement, which groups rows with similar values. The COUNT(), MAX(), MIN(), SUM(), and AVG() aggregate functions are frequently used with the GROUP BY statement to group the result set by
Star Schema and Snowflake Schema in Data Warehousing
What are Star Schema and Snowflake Schema in a Data Warehouse? Data Modeling Plays an important role in managing a database as it logically describes the database in terms of various parameters such as how data will be stored, what constraints to follow, and how data objects are related to
