Create the following tables and solve the queries. CREATE TABLE customer ( custid VARCHAR(6), fname VARCHAR(30), mname VARCHAR(30), ltname VARCHAR(30), city VARCHAR(15), mobileno VARCHAR(10), occupation VARCHAR(10), dob DATE, CONSTRAINT customer_custid_pk PRIMARY KEY(custid) ); CREATE TABLE branch ( bid VARCHAR(6), bname VARCHAR(30), bcity VARCHAR(30), CONSTRAINT branch_bid_pk PRIMARY KEY(bid) ); CREATE TABLE account ( acnumber VARCHAR(6), custid VARCHAR(6), bid VARCHAR(6), opening_balance INT(7), aod DATE, atype VARCHAR(10), astatus VARCHAR(10), CONSTRAINT account_acnumber_pk PRIMARY KEY(acnumber), CONSTRAINT account_custid_fk FOREIGN KEY(custid) REFERENCES customer(custid), CONSTRAINT account_bid_fk FOREIGN KEY(bid) REFERENCES branch(bid) ); CREATE TABLE trandetails ( tnumber VARCHAR(6), acnumber VARC