Open system: A system which is connected to the network and is ready for communication. Closed system: A system which is not connected to the network and can’
We’ve been studying a lot about the Wired Network. Ethernet is the most common example. Wired networks differ from wireless which uses radio waves rather than
Combinatorics is the branch of Mathematics dealing with the study of finite or countable discrete structures. It includes the enumeration or counting of objects
A graph is a data structure that is defined by two components : A node or a vertex. An edge E or ordered pair is a connection between two nodes u,v that is iden
Prerequisite – Graph Theory Basics – Set 1 A graph is a structure amounting to a set of objects in which some pairs of the objects are in some sense “rela
Augmented Reality or A.R is a way by which technology can change how we perceive the world around us.it’s also very useful in various fields, but first we nee
Digital Image Processing means processing digital image by means of a digital computer. We can also say that it is a use of computer algorithms, in order to get
So far the operations using C program are done on a prompt / terminal which is not stored anywhere. But in the software industry, most of the programs are writt
What is HTML Canvas? The HTML “canvas” element is used to draw graphics via JavaScript.The “canvas” element is only a container for graphics.One must us
What is SVG? SVG stands for Scalable Vector Graphics. It basically defines vector-based graphics in XML format. SVG graphics do NOT lose any quality if they are
In this article, we will go through all the basic stuff of HTML coding. There are various tags that we must consider and include while starting to code in HTML.
There are two CREATE statements available in SQL: CREATE DATABASE CREATE TABLE CREATE DATABASE A Database is defined as a structured set of data. So, in SQL the
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 or table is used other than t
Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the type of data that can be stored in a partic
Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below. 1. Binary Datatypes : T
As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet. Comments can be written
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand. A sequence is a user de
What are Transactions? Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks
In this article, we will see how to create, delete and uses of the INDEX in the database. An index is a schema object. It is used by the server to speed up the
SQL | ALL and ANY SOME operator evaluates the condition between the outer and inner tables and evaluates to true if the final result returns any one row. If not
Sometimes we may require tuples from the database which match certain patterns. For example, we may wish to retrieve all columns where the tuples start with the
The EXISTS condition in SQL is used to check whether the result of a correlated nested query is empty (contains no tuples) or not. The result of EXISTS is a boo
PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. A stored procedure in PL/SQL is nothing bu
SQL(Structured Query Language) SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Stand
