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
|