Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
SQL Query:i am created a bank database
bala krishna
6 years ago
207
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
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