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
|
Ankit SharmaPosted Sep 29, 2017, 3:22 AM