create table Clients
( CID number(3) constraint Clients_PK primary key,
  FName varchar2(15) not null,
  LName varchar2(20) not null,
  Address varchar2(30) not null
);

create table Checkings
( AccountNO varchar2(25) constraint AccNO_PK primary key,
  Amount number (8,2) default 0 not null,
  UPDDate date default sysdate,
  CID number(3) constraint Check_Cli_FK references Clients(CID)
);

insert into Clients values ('1', 'Steven', 'Seagal', 'USA');
insert into Clients values ('2', 'Bruce', 'Willis', 'USA');
insert into Clients values ('3', 'Angelina', 'Jolie', 'USA');

insert into Checkings values ('10203040-223344-15-23', 1000, sysdate, 1);
insert into Checkings values ('10203040-288900-16-23', 2000, sysdate, 2);
insert into Checkings values ('10203040-117703-20-24', 1200, sysdate, 3);

commit;