INTEGRITY CONSTRAINT

(1)

mysql> create database aca;

mysql> use aca;

mysql> create table nonaca(regno int,name varchar(10),nonaca_id int,credit int,co_ordinator varchar(30),mark int);

 (ii)

mysql> create table result(regno int,nonaca_mark int,activity_id int,status varchar(6));

 (2)

mysql> alter table nonaca add primary key(regno);

 (3)

mysql> alter table result add constraint fk1 foreign key(regno)references nonaca(regno);

 (4)

mysql> desc nonaca;

mysql> desc result;

(5)

mysql> insert into nonaca values(101,'bala',10,2,'charan',80);

mysql> insert into nonaca values(102,'naveen',11,3,'karthick',70);

mysql> insert into nonaca values(103,'suri',12,2,'suresh',85);

mysql> insert into nonaca values(104,'harini',13,1,'hari',90);

mysql> insert into nonaca values(105,'priyan',14,2,'ravi',65);

mysql> insert into result values(101,80,1,'pass');

mysql> insert into result values(102,90,2,'pass');

mysql> insert into result values(103,35,3,'fail');

mysql> insert into result values(104,40,4,'fail');

mysql> insert into result values(105,60,5,'pass');

 (6)

mysql> select*from nonaca;

mysql> select*from result;

 (7)

   mysql> alter table nonaca modify name varchar(200);

 (8)

mysql> select * from nonaca where credit > 2 and  credit < 4;

 (9)

mysql> select * from nonaca where credit > 2  or credit < 4;

 (10)

mysql> delete from nonaca where credit>4 and credit<6;

 (11)

 (12)

mysql> alter table result rename coestatement;

 (13)

mysql> alter table coestatement drop column status;

 (14)

mysql> desc coestatement;

 (15)

mysql> alter table nonaca drop primary key;

mysql> desc nonaca;

mysql> alter table coestatement drop primary key;

mysql> desc coestatement;

(16)

mysql> describe nonaca;

mysql> describe coestatement;