Electronic and Digital systems may use a variety of different number systems, (e.g. Decimal, Hexadecimal, Octal, Binary).
A number N in base or radix b can be written as:
(N)_b = d_n-1 d_n-2 — — — — d₁ d₀ . d_-1 d_-2 — — — — d_-m

Floating Point Representation | Digital Logic

September 11, 2017

CS Study

1. To convert the floating point into decimal, we have 3 elements in a 32-bit floating point representation:
i) Sign
ii) Exponent
iii) Mantissa

Set Operations in SQL

September 08, 2017

CS Study

SQL supports few Set operations to be performed on table data. These are used to get meaningful results from data, under different special conditions.

Union

UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows from its result set. In case of union, number of columns and datatype must be same in both the tables.

Example of UNION

The First table,

ID	Name
1	abhi
2	adam

The Second table,

ID	Name
2	adam
3	Chester

Union SQL query will be,

select * from First
UNION
select * from second

The result table will look like,

ID	NAME
1	abhi
2	adam
3	Chester

Union All

This operation is similar to Union. But it also shows the duplicate rows.

Example of Union All

The First table,

ID	NAME
1	abhi
2	adam

The Second table,

ID	NAME
2	adam
3	Chester

Union All query will be like,

select * from First
UNION ALL
select * from second

The result table will look like,

ID	NAME
1	abhi
2	adam
2	adam
3	Chester

Intersect

Intersect operation is used to combine two SELECT statements, but it only retuns the records which are common from both SELECT statements. In case of Intersect the number of columns and datatype must be same. MySQL does not support INTERSECT operator.

Example of Intersect

The First table,

ID	NAME
1	abhi
2	adam

The Second table,

ID	NAME
2	adam
3	Chester

Intersect query will be,

select * from First
INTERSECT
select * from second

The result table will look like

ID	NAME
2	adam

Minus

Minus operation combines result of two Select statements and return only those result which belongs to first set of result. MySQL does not support INTERSECT operator.

Example of Minus

The First table,

ID	NAME
1	abhi
2	adam

The Second table,

ID	NAME
2	adam
3	Chester

Minus query will be,

select * from First
MINUS
select * from second

The result table will look like,

ID	NAME
1	abhi

Software Engineering : SRS and Waterfall Model

September 08, 2017

CS Study

Software Engineering is an engineering approach for software development.The basic principle of software engineering is to use structured, formal and disciplined methods for building and using systems.The outcome of software engineering is an efficient and reliable software product.

SQL Constraints

September 07, 2017

CS Study

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 particular column in a table using constraints.

The available constraints in SQL are:

Java Variables

September 05, 2017

CS Study

Variable is a placeholder (reserved memory block) to store a value of any type. A variable is defined by its name (identifier), type and initialization is optional.

Syntax for variable declaration:

InFix PreFix and PostFix MCQs

September 04, 2017

CS Study

Question 1. The postfix form of the expression (A+ B)*(C*D- E)*F / G is?
a) AB+ CD*E - FG /**
b) AB + CD* E - F **G /
c) AB + CD* E - *F *G /
d) AB + CDE * - * F *G /

ANSWER: a) AB+ CD*E - FG /**

Infix, Prefix and Postfix Conversions

September 03, 2017

CS Study

Infix: the operator is in between the two operands.

Prefix: operators precede the two operands that they work on.

Postfix: operators come after the corresponding operands.

PL/SQL Examples

September 03, 2017

CS Study

What is PL/SQL?

Procedural Language extension to SQL

It integrates procedural constructs with SQL

Features of Java

September 02, 2017

CS Study

The prime reason behind creation of Java was to bring portability and security feature into a computer language. Beside these two major features, there were many other features that played an important role in molding out the final form of this outstanding language. Those features are :