Skip to content

Category Archives: Computer Subject

Functional Dependency A functional dependency A->B in a relation holds if two tuples having same value of attribute A also have same value for attribute… Read More
The Union Clause is used to combine two separate select statements and produce the result set as a union of both the select statements. NOTE:… Read More
SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins… Read More
Prerequisite:  SQL | WHERE Clause In the above mentioned article WHERE Clause is discussed in which LIKE operator is also explained, where you must have… Read More
Aliases are the temporary names given to table or column for the purpose of a particular SQL query. It is used when name of column… Read More
The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns.  By… Read More
SELECT TOP clause is used to fetch limited number of rows from a database. This clause is very useful while dealing with large databases. Basic… Read More
The UPDATE statement in SQL is used to update the data of an existing table in database. We can update single columns as well as… Read More
The DELETE Statement in SQL is used to delete existing records from a table. We can delete a single record or multiple records depending on… Read More
The INSERT INTO statement of SQL is used to insert a new row in a table. There are two ways of using INSERT INTO statement… Read More
Prerequisite : Stop and Wait ARQ The Stop and Wait ARQ offers error and flow control, but may cause big performance issues as sender always… Read More
In SQL, the AND & OR operators are used for filtering the data and getting precise results based on conditions. The SQL AND & OR operators… Read More
We strongly recommend to refer below posts as a prerequisite of this. DBMS | Relational Model Introduction and Codd Rules DBMS | Keys in Relational… Read More
  DBMS | Relational Model Introduction and Codd Rules  Different Types of Keys in Relational Model  Candidate Key: The minimal set of attributes that can… Read More
Terminology  Relational Model:  – * It was proposed by Dr. E.F.Codd. *It uses the concept of relations to represent each and every file. *Relations are Two-Dimensional Tables. * It… Read More

Start Your Coding Journey Now!