The following questions are based on Figure 7 below: Current Account Balance RM 12,000 20,000 9,000 30,000 1 Names of Customers Fixed Deposit Outcome Balance RM YES/NO Khairie 120,000 100,000 155,000 90,000 Halim Amirul Asrul Figure 7 Required: а. The following independent situations are available: i. Bank Usahawan Malaysia Berhad will approve loan applications to its customer who has a Current Account balance of RM10,000 or more; and a Fixed Deposit Account balance of RM100,000 or more. Determine the formula in cell D3. ii. If the bank changes the policy for the loan approval; where a customer will be Fixed Deposit Account balance of more than RM120,000. Determine the new formula in cell D3. b. Identify the names of customers whose loan applications are NOT approved as in situation (i) and (ii) above. C. Define AND and OR Function. 23456

The following questions are based on Figure 7 below: Current Account Balance RM 12,000 20,000 9,000 30,000 1 Names of Customers Fixed Deposit Outcome Balance RM YES/NO Khairie 120,000 100,000 155,000 90,000 Halim Amirul Asrul Figure 7 Required: а. The following independent situations are available: i. Bank Usahawan Malaysia Berhad will approve loan applications to its customer who has a Current Account balance of RM10,000 or more; and a Fixed Deposit Account balance of RM100,000 or more. Determine the formula in cell D3. ii. If the bank changes the policy for the loan approval; where a customer will be Fixed Deposit Account balance of more than RM120,000. Determine the new formula in cell D3. b. Identify the names of customers whose loan applications are NOT approved as in situation (i) and (ii) above. C. Define AND and OR Function. 23456

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following schedule of transactionsW1(A) W2(A) W1(A) W2(A) W1(A)Which of the following properties are true for the above schedule and justify the reason for your answer with explanation?a) Conflict Serializableb) View Serializablec) Recoverable Please answer these question in detail with full explaination. I need a proper long answer. Thanks :)
Using the following password ABCefg12 and KOJOGiggs12 as examples, discuss the strengths and weaknesses of each password and discuss what could be done to strengthen them, if they are weak password
1. The risk level assigned for a threat with rare likelihood and major consequence rating is __________________. Low Medium Extreme High 2. Both dynamic binary rewriting and interposition techniques do not require recompilation of the application binary. True False 3. It is preferred that Hash algorithm used in password security must be optimized to execute as quickly as possible. True False
To what extent do you feel that the security of data while it is being stored and while it is being transferred should be guaranteed? Which of the following strategies has shown to be the most effective in maintaining the data's integrity while also authenticating users?
Provide an imaginary example of user account administration. Take notice of the several methods that might be used to verify a user's identity. Can we say goodbye to passwords?
A financial company hired a team to develop a new system that will help them improve their business. After a requirements elicitation phase, the following requirements were prioritized.1) The system should allow customers to self-register for an account with the financial institution.2) The system should allow the management of investments by customers.3) The system should be able to guarantee data integrity even in the case of errors during a transaction.4) The system should support 1,000,000 transactions per month.5) The system should be implemented using open-source software.6) The system should allow customers to pay debts from their mobile applications.7) The system should comply with the Open Banking Standard.8) The system should be accessible for people with disabilities (visual, hearing, physical, cognitive, and neurological).9) The system should generate weekly reports about investments.10) The system should allow customers to make part of their savings available to be lent…
For the following schedules of three transactions, tell whether there are any conflicts between them.T1 R(A) W(A) C-------------------------------------------------- --------------------------------T2 W(A) C-------------------------------------------------- --------------------------------T3 R(A) Ca) If yes, describe them and explain how you would solve these conflicts with 2-phase locking.b) Where should we move the T3 confirmation so that there is a RW conflict between T2 and T3?
1. Which of the following statements about ScroogeCoin is INCORRECT? A. A designated entity called Scrooge publishes an append‐only ledger containing the history of all the transactions that have happened. B. Scrooge can build a block chain, which is a series of data blocks, each with one transaction in it. C. ScroogeCoin can address the double spending issue. D. ScroogeCoin can implement coin minting, transaction, and IDs' assignment in a fully decentralized way.
The Password Policy controls password characteristics for local useraccounts. Using suitable examples, explain the following password policy settings.• Maximum password age;• Enforce Password History;• Password must meet complexity requirements.
In your perspective, how critical is it that data be protected both while it is being kept and when it is being transported? Which of the following strategies is the most efficient at preserving the reliability of the data while simultaneously verifying the identity of the user?
Consider a schedule with 4 transactions with 1, 2, 3, and 4 operations respectively. Calculate the possible number ofa) Serial schedulesb) Non serial schedules Please answer these question in detail with full explaination. I need a proper long answer. Thanks :)
In your opinion, how crucial should the protection of data be when it is being stored and transported? Which of the following methods is the most effective in terms of maintaining the data's integrity while also authenticating the user?