practise

create table Aven

(

Aid int not null primary key,

Aname varchar(15),

ADOB date,

ADOJ date

)

create table AvenSal(

salid int not null primary key,

Salary money)

alter table AvenSal add constraint pk_vanesal foreign key(salid) references Aven(Aid) 

create table ARelation(

Rid int,

SpouseName varchar(15),

foreign key(Rid) references Aven(Aid))

insert into Aven select 001,'Steve Rogers','1880-02-12','1920-02-29'

insert into Aven select 002,'Tony Stark','1991-02-05','2000-02-09'

insert into Aven select 003,'captain Marvel','1981-02-05','2000-12-12'

insert into Aven select 004,'Thor Odinson','1661-09-25','2005-01-15'

insert into Aven select 005,'Bruce Banner','1985-06-10','2008-03-21'

insert into Aven select 006,'steven strange','1986-02-05','2010-08-26'

insert into Aven select 007,'Natasha Romanof','1988-02-28','2012-12-28'

insert into Aven select 008,'Hawk aye','1988-02-06','2012-12-12'

insert into Aven select 009,'Ant man','1980-06-29','2013-06-10'

insert into Aven select 010,'pepper pots','1991-08-10','2016-07-05'

insert into Aven select 011,'bucky barnes','1981-03-05','2018-04-22'

insert into Aven select 012,'peter parker','1997-02-05','2019-09-18'

alter table ARelation alter Column SpouseName Varchar(15)

insert into ARelation (Rid,SpouseName) values (1,'peggy carter')

insert into ARelation (Rid,SpouseName) values (2,'pepper pots')

insert into ARelation (Rid,SpouseName) values (4,'valkery')

insert into ARelation (Rid,SpouseName) values (5,'natasha romanof')

insert into ARelation (Rid,SpouseName) values (8,'famer gf')

insert into ARelation (Rid,SpouseName) values (9,'pymp ')

insert into ARelation (Rid,SpouseName) values (11,'bucky barnes')

insert into ARelation (Rid,SpouseName) values (12,'mj ')

create table category

(

catid int primary key,

CatName char(1))

insert into category(catid,CatName) values(77,'E')

insert into category(catid,CatName) values(99,'A')