create table users ( uname varchar(10) primary key, password varchar(10) not null, email varchar(50) unique, registeredon date ); insert into users values ('abc','abc','abc@gmail.com',sysdate); insert into users values ('james','j','james@sun.com',sysdate); create sequence expid start with 1 increment by 1 nocache; create table expenditures ( expid number(5) primary key, uname varchar(10) references users(uname), expdate date default sysdate, expdesc varchar2(200), expamount number(10,2), expremarks varchar2(1000) ); create sequence incomeid start with 1 increment by 1 nocache; create table incomes ( incomeid number(5) primary key, uname varchar(10) references users(uname), incomedate date default sysdate, incomedesc varchar2(200), incomeamount number(10,2), incomeremarks varchar2(1000) );