What is Database Management System DBMS

 02 Sep  Admin

DBMS stands for Database Management System. DBMS is a software package designed to define, manipulate, retrieve and manage data in a database. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. It also defines rules to validate and manipulate this data.

Read More

Hierarchical model in DBMS

 02 Sep Admin

In hierarchical database model the data are organized into a tree-like structure where each record is having one parent record and many children.This model structure allows the one-to-one and a one-to-many relationship between two/ various types of data.The main drawback of this model is that, it can have only one to many relationships between nodes.

Hierarchical_Model_Diagram

Read More

Introduction to HTML

02 Sep  Admin

Introduction to HTML blocks 

HTML ??? block level ?? inline 2 ??? ?? tags ???? ??? ?? ?? block level tags webpage ??? show ???? ?? ?? automatically ???? ???? ?? ??? ??? ?? line ?? space ???? ??? ??? common block level tags ?? ???? ??? ???? ???? ?? ??? ???
 

  • div 
  • p
  • h1

????? ????? ?? tags inline tags ???? ??? ?? ?? tags ???? ???? ???? ?? ?? webpage ??? ?? ???? ???? ???? ???? ?? tag ?? line ??? ?? show ?? ???? ??? ??? ?? <br /> tag ???????? ?? ??? ?? ???? ???? ?? ??? ??? ??? space ???? ???? ??? ??? inline tags ???? ??? ?? ??? ???
 

  • span
  • anchor
  • img 
Read More

DBMS (Database Management System)

 02 Sep  Admin

DBMS is a software package designed to define, manipulate, retrieve and manage data in a database. DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. It also defines rules to validate and manipulate this data.

Read More

Python For Loops

 28 Aug   Admin

for <var> in <iterable>:
    <statement(s)>

  is a collection of objects—for example, a list or tuple. The  in the loop body are denoted by indentation, as with all Python control structures, and are executed once for each item in . The loop variable  takes on the value of the next element in  each time through the loop.

Example

 a = ['apple', 'banana', 'mango']
 for i in a:
    print(i)

Output-
apple
banana
mango
In this example, <iterable> is the list a, and <var> is the variable i. 
Each time through the loop, i takes on a successive item in a, 
so print() displays the values 'apple''banana', and 'mango', respectively.
 A for loop like this is the Pythonic way to process the items in an iterable.

Iterables

In Python, iterable means an object can be used in iteration. If an object is iterable, it can be passed to the built-in Python function iter(), which returns something called an iterator. Yes, the terminology gets a bit repetitive. 

Read More

Python While Loops

28 Aug   Admin

while <expr>:
    <statement(s)>

<statement(s)> represents the block to be repeatedly executed, often referred to as the body of the loop. This is denoted with indentation, just as in an if statement.

The controlling expression, <expr>, typically involves one or more variables that are initialized prior to starting the loop and then modified somewhere in the loop body.

When a while loop is encountered, <expr> is first evaluated in Boolean context. If it is true, the loop body is executed. Then <expr> is checked again, and if still true, the body is executed again. This continues until <expr> becomes false, at which point program execution proceeds to the first statement beyond the loop body.

Example

  n = 5
  while n > 0:
     n -= 1
    print(n)

Output-

 4
 3
 2
 1
 0

Here’s what’s happening in this example:

  • n is initially 5. The expression in the while statement header on line 2 is n > 0, which is true, so the loop body executes. Inside the loop body on line 3, n is decremented by 1 to 4, and then printed.
  • When the body of the loop has finished, program execution returns to the top of the loop at line 2, and the expression is evaluated again. It is still true, so the body executes again, and 3 is printed.
  • This continues until n becomes 0. At that point, when the expression is tested, it is false, and the loop terminates. Execution would resume at the first statement following the loop body, but there isn’t one in this case.
Read More

Python If….Else

28 Aug  Admin

Python Conditions and If statements

Python supports the usual logical conditions from mathematics:

  • Equals: a == b
  • Not Equals: a != b
  • Less than: a < b
  • Less than or equal to: a <= b
  • Greater than: a > b
  • Greater than or equal to: a >= b

These conditions can be used in several ways, most commonly in “if statements” and loops.

An “if statement” is written by using the if keyword.

Example

x = 22
y = 160

if y > x:
  print(“y is greater than x”)

Output

y is greater than x

Elif

The elif keyword in pythons is used to check “if the previous conditions were not true, then try this condition”.

Example

a = 12
b = 18
if a == b:
 print(“a and b are equal”)


elif b > a:

print(“b is greater than a”)
  

Output

b is greater than a

Read More

Python Dictionaries

28 Aug  Admin

A dictionary is a collection which is unordered, changeable and indexed. Each key is separated from its value by a colon (:), the items are separated by commas, and the whole thing is enclosed in curly braces. An empty dictionary without any items is written with just two curly braces, like this: {}.

Example

thisdictionarie =    {
  “name”: “rohan”,
  “age”: “23”,
  “year”: 1996
}
print(thisdictonarie)

Output

{‘name’: ‘rohan’, ‘age’: ’23’, ‘year’: 1996}

Read More

Python Sets

 12 Apr  Admin

A set is a collection which is unordered and unindexed. In Python sets are written with curly brackets.

 Sets are unordered, so you cannot be sure in which order the items will appear.

Example

theset = {“bus”, “car”, “aeroplane”}
print(theset)

Output

{‘aeroplane’, ‘bus’, ‘car’}

Read More

Python Lists

28 Aug admin

Python Collections (Arrays)

There are four collection data types in the Python programming language:

  • List is a collection which is ordered and changeable. Allows duplicate members.
  • Tuple is a collection which is ordered and unchangeable. Allows duplicate members.
  • Set is a collection which is unordered and unindexed. No duplicate members.
  • Dictionary is a collection which is unordered, changeable and indexed. No duplicate members.

List

A list is a collection which is ordered and changeable. In Python lists are written with square brackets.

alist = [“america”, “india”, “japan”]
print(alist)
Output- 

['america', 'india', 'japan']

Access Items

You access the list items by referring to the index number:

alist = [“apple”, “banana”, “cherry”]
print(alist[2])

output:-cherry

Read More