Question

write a program using MATLAB

‘A’ contains all account numbers and balances. ‘B’ contains debits/credits for each account.
Write a program that updates ‘A’ based on information in ‘B’. Also create a separate matrix ‘C’ that contains only the new accounts not in A.

A= Acct# Balance

[5 1000
2 5000

82 68
7 10]

B= Acct# Credit/Debit

[5 -100

8 2000

12 3000

14 1
7 -20]

Output

A= Acct# Balance

[5 900

2 5000

8 2002

6 8
7 -10

12 3000

14 1]

C = Acct# Credit/Debit

[12 3000

14 1]

Answer 1

The above problem can be solved in the following steps-

STEP 1- First we will define and intialize the two matrices A and B. A will have the account no and balance as two columns. And matrix B will have the account no and action(credit/debit) as two columns.Use the data given in question to create two matrix A and B

STEP 2- Then we will iterate through matrix A and in inner loop iterate through matrix B.
In the inner loop, check if account no in matrix A matches any account no in matrix B

If yes, then perform credit/debit action on the account balance of the matched account no.

And then in the matrix B, mark this account no as 0, because this account no. exists in A. This will help us in creating matrix C where we will have new account nos which are not present in A right now.

STEP 3- Then we will create matrix C. Iterate through the matrix B. And check which all account nos are not equal to 0.(this is because the account nos which were present in A are marked as 0).

If non zero account no is there, concat the row contents to matrix C. In this way matrix C is constructed.

STEP 4- Now matrix A to be displayed as output has all the account no along with balance(both the old and new account nos). So concat matrix A and C and form a new matrix A and display that matrix.

Also, display the matrix C at the end.

MATLAB CODE-

%create matrix A and store all the given information
% A = Acct# Balance
A= [5 1000
2 5000
8 2
6 8
7 10];
%create marix B and store all the given information
% B = Acct# Credit/Debit
B= [5 -100
8 2000
12 3000
14 1
7 -20];

%iterate through the matrix A
for i=1:length(A)
%and then inner loop iterates through matrix B
for j=1:length(B)
%if account number in A matches account number in B
if(A(i,1) == B(j,1))
%change the account balance in A as instructed in B(2nd column)
A(i,2) = A(i,2) + B(j,2);
%and make that account number in B as 0, that means this
%account number was present in A, so it is changed to 0
%this will help in creating matrix C as shown below
B(j,1) = 0;
end
end
end
%now we will create matrix C such that it contains new account nos in B not
%present in A
C = [];
%iterate through the matrix B
for i=1:length(B)
%if account number in matrix B is not 0, means it was not present in A
%as shown above, so add this row to matrix C
if(B(i,1) ~= 0)
C = cat(1,C,B(i,:)); %concat this row in B to matrix C
end
end
%now matrix will have all account nos and balance from matrix A and B both
A = cat(1,A,C); %so concat A and C matrix
disp('A = Acct# Balance ');
disp(A); %display the matrix A
%and then display the matrix C
disp('C = Acct# Credit/Debit');
disp(C);

IMAGE OF CODE-

create matrix A and store all the given information % A = Acct# Balance A= [5 1000 2 5000 8 2 6 8 7 10]; create marix B and store all the given information B = Acct# Credit/Debit B= [5 -100 8 2000 12 3000 14 1 7 -20]; 14 - - - - - - - Е о со чол во мнооо ч ол е мнооо ч ол то он - - - - M M M M M M M M M M L literate through the matrix A for i=1:length (A) Sand then inner loop iterates through matrix B for j=1:length(B) fif account number in A matches account number in B if (A(i,1) == B(),1)) % change the account balance in A as instructed in B (2nd column) Ali, 2) = A(i, 2) + B (j,2); Sand make that account number in B as 0, that means this Saccount number was present in A, so it is changed to o $this will help in creating matrix C as shown below B(j, 1) = 0; end end 30 - Lend

32 33 - 34 35 - 36 m 38 - Enow we will create matrix C such that it contains new account nos in B not present in A C = []; literate through the matrix B for i=1:length (B) fif account number in matrix Bis not 0, means it was not present in A Pas shown above, so add this row to matrix C if(B(i,1) -= 0) C = cat(1,C,B(i,:)); $concat this row in B to matrix C end end &now matrix will have all account nos and balance from matrix A and B both A = cat(1,A,C); so concat A and C matrix disp('A = Acct# Balance '); disp(A); %display the matrix A and then display the matrix c disp('C = Acct# Credit/Debit'); disp (C); # O # # W N 44 - # # 47 - 48 - 49

OUTPUT-

Acct# Balance 900 5000 2002 -10 3000 C = Acct Credit/Debit 3000 12

If this answer helps, please give an up vote and feel free to comment for any query.