MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENTRE, ALWARCOMPUTER ENGINEERINGM.TECH- II SEMADBMS LABSESSION: 2014-15Submitted By:Submitted To:N!"# G"!$% M&. A'()% G"!$%14EMCCES*14 A&&$. P+,-. D.!$. ,- CSELIST OF CONTENTSE/!.+'.#$& N,.P%0. N,.E/!.+'.#$ 1 1Write a program to create SQL statement for customer and insert values into the table. 1E/!.+'.#$ 2 1Write a program to show various SQL!onstraints such as "#T "$LL% &'()$LT and $"*Q$' !onstraints. +E/!.+'.#$ 1 4Write a program to show various SQL!onstraints such as ,-*.)-/ 0'/%(#-'*1" 0'/ and !2'!0 !onstraint. 3E/!.+'.#$ 4 5Write description for atomiticity% consistency% isolation and durability in dbms. 4E/!.+'.#$ 5 *Write description for transaction and concurrency control in data base management system. 5E/!.+'.#$ * 2Write a program to show SQL $"*#"S !L)$S' 6E/!.+'.#$ 2 3Write a program to create% delete SQL *"&'7 8E/!.+'.#$ 3 4Write a program to create% delete SQL 9*'W :E/!.+'.#$ 4 11Write a program to create% delete ,L;SQLTriggers. 11E/!.+'.#$ 10 14Write a program for Triggering a Trigger in ,L;SQL 13E/!.+'.#$ 11 15Write a program for ,L;SQLimplicit and e