اینم کل کدها
حتی اسمه پایگاه داده رو عوض کردم بازم جواب نداد
لطفا کمک کنید
create Database Bank
use Bank
create Table bank(code int primary key,bname varchar(20) not null,baddr varchar(20))
create Table Branch(brno int primary key,code int foreign key references bank(code) on delete cascade on update cascade, brname varchar(20),brcity varchar(20),brstate varchar(20),braddr varchar(20))
create Table Employee(eid int primary key,efname varchar(10),elname varchar(10),e*** varchar(10),esalary int,estartdate int,ephone int,eaddr varchar(20),esuper int not null,brno int foreign key references Branch(brno) on delete cascade on update cascade)
create Table Loan(loanno int primary key,ltype varchar(20),lamount int,brno int foreign key references Branch(brno) ,eid int foreign key references Employee(eid) )
create Table Account(accno int primary key,balance int not null,acctype varchar(20),accdate int,brno int foreign key references Branch(brno) on delete cascade on update cascade,eid int foreign key references Employee(eid))
create Table Customer(custno int primary key,custfname varchar(10),custlname varchar(10),cust*** varchar(10),custphone int,custapartmentno int,custstreetno int,custcity varchar(10),custstate varchar(10))
create Table lc(loanno int foreign key references Loan(loanno)on delete cascade on update cascade,custno int foreign key references Customer(custno)on delete cascade on update cascade)
create Table ha(accno int foreign key references Account(accno)on delete cascade on update cascade,custno int foreign key references Customer(custno)on delete cascade on update cascade)
create Table Payment(payno int primary key,paydate int,payamount int,loanno int foreign key references Loan(loanno)on delete cascade on update cascade,custno int foreign key references Customer(custno)on delete cascade on update cascade)
create Table Transac(tid int primary key,ttime int,tfee varchar(10),tamount int,ttype varchar(20),custno int foreign key references Customer(custno)on delete cascade on update cascade,accno int foreign key references Account(accno)on delete cascade on update cascade)
create Table Depend(depname varchar(10) primary key,dep*** varchar(10),depbdate int,deprelation varchar(20),eid int foreign key references Employee(eid)on delete cascade on update cascade)
create Table checkk(checkkfee varchar(10),accno int foreign key references Account(accno)on delete cascade on update cascade)
create Table savee(rate int primary key,accno int foreign key references Account(accno)on delete cascade on update cascade)