DBMS Query
(1) CREATE TABLES INSERT VALUES IN ALL 5 TABLES Query:- CREATE TABLE CofRajkot_detail( Name varchar(50), Age int, PartyName varchar(50), SLocation varchar(50), ) insert into dbo.CofRajkot_detail(Name,[Age],PartyName,SLocation) values('Denish Akbari',25,'BJP','Rajkot'); insert into dbo.CofRajkot_detail(Name,[Age],PartyName,SLocation) values('Bansal Vaishnav',27,'Congress','Rajkot'); insert into dbo.CofRajkot_detail(Name,[Age],PartyName,SLocation) values('Siddharth Dhameliya',24,'AAP','Rajkot'); insert into dbo.CofRajkot_detail(Name,[Age],PartyName,SLocation) values('Kaushal Doshi',30,'SAPA','Rajkot'); insert into dbo.CofRajkot_detail(Name,[Age],PartyName,SLocation) values('Nipun Parekh',32,'other','Rajkot'); (2) WRITE ONE QUERY FOR PRIMARY KEY WRITE TWO QUERIES FOR ALTER, ONE WITH