Monday, 1 July 2013

DEFINE TRIGGERS | WHAT IS MEANT BY TRIGGER IN DBMS

Triggers:

A Trigger defines an action that the database should take when some database related event occurs.The execution of triggers is transparent to the users.A trigger may cause another trigger to be invoked.A mutating trigger is a trigger that triggers itself.

Types Of Triggers:

The triggers types are defined by the type of triggering transactions and by the level at which the trigger is executed.
  • Row-level triggers
  • Statement-level triggers
  • Before and after triggers
Row-level triggers:
Row-level triggers,trigger once for each row in a transaction.This trigger can be created by using the for each row clause trigger comment.
Statement-level triggers:
Statement-level triggers execute once in a transaction.It can be created by using create trigger comment.It is one of the default type of triggers.
Before and after triggers:
Since the events that executes triggers are database transactions,triggers can be executed immediatly before or after INSERT,UPDATE and DELETE comments.

Purpose of Triggers:
  • To generate data automatically
  • To enforce complex integrity constrains
  • To customize complex security authorizations
  • To maintain replicate tables
  • To audit data modifications

Saturday, 29 June 2013

Anna university Mathematics I Notes Important Question Papers syllabus Question banks and all study materials

Thia page contain Anna university  MA2111 Engineering Mathematics-1 previous year question papers, Syllabus, Notes, Question Bank, Formula Materials and all study materials for first semester maths-1

Anna university MA2111 Mathematics I Question Bank :

Click the units one by one to Download the Anna university Engineering Maths-1 subject wise question Bank

Anna university MA2111 Mathematics I Syllabus :
Anna university MA2111 Mathematics I Notes :
Anna university MA2111 Mathematics I Formulas :
Anna university MA2111 Mathematics I Model Question paper :
Anna university MA2111 Mathematics I Important Questions
Anna university MA2111 Maths-I previous year Question papers :

  1. Regulation 08 - May/June 2012 DownloadMA2111 Question Paper
  2. Regulation 10 - Nov/Dec 2011 DownloadMA2111 Question Paper
  3. Regulation 08 - January 2009 DownloadMA2111 Question Paper
  4. Regulation 08 - January 2010 DownloadMA2111 Question Paper
  5. Regulation 08 - Nov/Dec 2010 DownloadMA2111 Question Paper

Related tags:
Anna university maths 1 important questions-Anna univ maths 1 previous year question papers-Anna university Sem-1 important questions-Anna university first year maths 1 important questions-Mathematics-1 syllabus free download-Engineering maths 1 imp ques-Maths 1 syllabus download-Question paper download for maths 1 anna university first semester-Anna university first year maths 1 important questions download-how to get pass mark in maths 1- MA2111 maths important questions MA2111 Question Paper download

Thursday, 27 June 2013

SQL CREATE TABLE AND INSERT INTO TABLE STATEMENTS | DBMS

How to create a table in Data Base using sql queries or statements

The create Table statements are used to create tables in the database

Syntax for creating table in database

SQL > CREATE TABLE SYNTAX


create table table-name(column_name 1 data_type,column_name 2 data_type,column_name 3 data_type);


Example for Table Creation in Database using sql statements


SQL > CREATE TABLE EXAMPLE


create table person(name varchar(10), address varchar(10),age int);


Thus the table named as person is created.In the below section we are going to see "How to insert data's into the table "using sql statements.




How to Insert data's into the table in Data Base using sql statements or comments


The Insert into Table sql statements are used to insert data's in the tables which is in the database.


Syntax for inserting data's in the created tables.


SQL > INSERT INTO STATEMENT SYNTAX


insert into table-name values(value int,value int,'value char');


Example for inserting data's in the created tables.


SQL > INSERT INTO STATEMENT EXAMPLE


insert into person values('Eshin','marthandam',20);
insert into person values('Jozer','nagercoil',20);

Thus the data's are inserted in the table named person.




Note:

char data-types must be enclosed by single quotes.
int data-types must be inserted without any quotes.


Wednesday, 26 June 2013

ANNA UNIVERSITY MAY/JUNE SECOND FOURTH SIXTH EIGHTH SEMESTER 2013 RESULTS

Anna university may/June/July second semester results 2013- Anna university may/June/July Fourth semester results 2013- Anna university may/June/July sixth semester results 2013- Anna university may/June/July Even semester results 2013- Anna university may/June/July results 2013- Anna university may/June/July affiliated colleges results 2013-  Anna university may/June/July second semester results announcing date 2013- Anna university may/June/July result publishing tentative date results 2013


Anna University Even semester results will be published in the StudentsBlog100 website when the Anna university 2013 April/May/June/July results in the Anna university official website www.annauniv.edu.When the results announced just open google search in your browser and type Anna university may/June/July  2013 StudentsBlog100 results.You will get your results.If not just enter StudentsBlog100.You will get our websites homepage.In the top of our site we will provide result link.In this way also you can get you Anna university may/June/July 2013 results in our StudentsBlog100 Website

Anna university 2nd, 4th, 6th, 8th semester may/June/July 2013 results

Anna University May/June/July Even Semester Results --> Click Here To View

Like us on Facebook to get the just out result updates in your Facebook.

Related Tags:
Anna university may/june 4th semester results 2013- Anna university may/june 2nd semester results 2013- Anna university may/june 6th semester results 2013- Anna university may/june 8th semester arrear students  results 2013- Anna university may/june 4th 6th 8th and 2nd semester results 2013-Anna university even sem result may/june 2013-Anna University semester exam results-Anna university ECE department results-Anna university result announcing official date-8th sem results for the students who have arrears in lower semesters-When will the Anna university 8th semester results will be published-8th semester arrear results announcing date-Anna univ BE/B.Tech results 2013.