Sure, here is a PL/pgSQL block that simulates an ATM transaction system based on the requirements you provided: ```sql DO $$ DECLARE withdrawal_amount NUMERIC; account_balance NUMERIC := 100000; -- Assume initial balance transaction_fee NUMERIC; BEGIN withdrawal_amount := 50000; -- Set your withdrawal amount here IF withdrawal_amount account_balance THEN RAISE NOTICE 'Insufficient funds'; ELSIF withdrawal_amount

Question

Sure, here is a PL/pgSQL block that simulates an ATM transaction system based on the requirements you provided:

```sql
DO $$
DECLARE 
    withdrawal_amount NUMERIC;
    account_balance NUMERIC := 100000; -- Assume initial balance
    transaction_fee NUMERIC;
BEGIN
    withdrawal_amount := 50000; -- Set your withdrawal amount here

IF withdrawal_amount <= 0 THEN
        RAISE NOTICE 'Invalid withdrawal amount';
    ELSIF withdrawal_amount > account_balance THEN
        RAISE NOTICE 'Insufficient funds';
    ELSIF withdrawal_amount <= 20000 THEN
        account_balance := account_balance - withdrawal_amount;
        RAISE NOTICE 'Transaction successful. Current balance is Rs. %', account_balance;
    ELSIF withdrawal_amount <= 40000 THEN
        transaction_fee := withdrawal_amount * 0.05;
        account_balance := account_balance - withdrawal_amount - transaction_fee;
        RAISE NOTICE 'Transaction successful with 5%% fee. Current balance is Rs. %', account_balance;
    ELSE
        transaction_fee := withdrawal_amount * 0.18;
        account_balance := account_balance - withdrawal_amount - transaction_fee;
        RAISE NOTICE 'Transaction successful with 18%% fee. Current balance is Rs. %', account_balance;
    END IF;
END $$;
```

This block first declares the variables `withdrawal_amount`, `account_balance`, and `transaction_fee`. It then checks the conditions you specified using IF-ELSIF statements. Depending on the condition that is met, it performs the appropriate actions and raises a notice with the current account balance.

Knowee AI · Accepted Answer

Sure, here is a PL/pgSQL block that simulates an ATM transaction system based on the requirements you provided:

```sql
DO $$
DECLARE 
    withdrawal_amount NUMERIC;
    account_balance NUMERIC := 100000; -- Assume initial balance
    transaction_fee NUMERIC;
BEGIN
    withdrawal_amount := 50000; -- Set your withdrawal amount here

IF withdrawal_amount <= 0 THEN
        RAISE NOTICE 'Invalid withdrawal amount';
    ELSIF withdrawal_amount > account_balance THEN
        RAISE NOTICE 'Insufficient funds';
    ELSIF withdrawal_amount <= 20000 THEN
        account_balance := account_balance - withdrawal_amount;
        RAISE NOTICE 'Transaction successful. Current balance is Rs. %', account_balance;
    ELSIF withdrawal_amount <= 40000 THEN
        transaction_fee := withdrawal_amount * 0.05;
        account_balance := account_balance - withdrawal_amount - transaction_fee;
        RAISE NOTICE 'Transaction successful with 5%% fee. Current balance is Rs. %', account_balance;
    ELSE
        transaction_fee := withdrawal_amount * 0.18;
        account_balance := account_balance - withdrawal_amount - transaction_fee;
        RAISE NOTICE 'Transaction successful with 18%% fee. Current balance is Rs. %', account_balance;
    END IF;
END $$;
```

This block first declares the variables `withdrawal_amount`, `account_balance`, and `transaction_fee`. It then checks the conditions you specified using IF-ELSIF statements. Depending on the condition that is met, it performs the appropriate actions and raises a notice with the current account balance.

Question

Solution

Similar Questions

Upgrade your grade with Knowee