question

DavidBruk avatar image
0 Votes"
DavidBruk asked Zoehui-MSFT edited

Indian Bank Case Study Ssrs

can anyone help me with this project please

https://www.scribd.com/document/99082144/Indian-Bank-Case-Study-ssrs

thank you

sql-server-transact-sql
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

And on which detail do you have question?

0 Votes 0 ·
DavidBruk avatar image DavidBruk OlafHelper-2800 ·
  1.  No Transactions should be allowed on Accounts marked “Inoperative”
    
  2.  When a Transaction is altered, the difference between the old amount and the new amount cannot be more than 10%, if the transaction has been affected by the teller
    
  3.  More than three Cash Withdrawal transactions in a single account on the same day should not be allowed
    
  4.  Cheque Number and Cheque Date columns should not be ‘NULL’, if the Transaction type is ‘Cheque Deposit’
    
  5.  A product should not be removed, if there are accounts attached to it (Similar checks are required wherever appropriate)
    
  6.  Transaction Amount should not be negative
    
  7.  Transaction Type should only be ‘CW’ or ‘CD’ or ‘CQD’
    
0 Votes 0 ·

0 Answers