Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
1
Reply
SQL Query:i am created a bank database
bala krishna
Sep 29 2017 2:04 AM
206
Reply
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
Attachment:
INDIAN_BANK_CASE_STUDY.rar
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to get the employee YearWise and get the other details f
difference between stored procedure and view's