1
Reply

SQL Query:i am created a bank database

bala krishna

bala krishna

Sep 29 2017 2:04 AM
192
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
 

Answers (1)