SQL Query:i am created a bank database

Question

with 2 tables account master and transacion master

 

and i am added i zip file i want

 

requrement as

 

"A Cheque which is more than six months old should not be accepted'' and also all requirements

 

Column Name	Data Type	Remarks
ACID	INTEGER	Primary Key
NAME	VARCHAR(40	NOT NULL
ADDRESS	VARCHAR(50)	NOT NULL
BRID	CHAR(3)	NOT NULL Foreign Key
PID	CHAR(2)	Foreign Key; NOT NULL
DATE OF OPENING	DATETIME	NOT NULL
CLEAR BALANCE	MONEY	NULL ALLOWED
UNCLEAR BALANCE	MONEY	NULL ALLOWED
STATUS	CHAR(1)	'O' for 'OPERATIVE', 'I' for 'INOPERATIVE', 'C' for 'CLOSED'; NOT NULL; DEFAULT value