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

Question 8 Consider the below tables Customer CustomerNo (PK) Order Order No CustomerName 110 114 11 Ali AlMansoori 12 Sarah Sulaiman 13 Maha Al Ali OrderDate 10/01/2018 11/01/2018 116 14/01/2018 118 12/01/2018 120 14/01/2018 122 17/01/2018 CustomerAddress Block A, No. 6, Khalifa B Aljazeera Tower, Aprt 180, Corniche Rd Etihad Tower, Aprt 2022, Hamdan ST Order Amount 17000 8000 21000 22000 42500 50100 CustomerNo (FK) 11 12 12 13 11 13 Write a query to display the order number, order amount for all orders made by customer Sarah with amount greater than 8000, displaying orders made later first.
From worksheet Nike, in cell M1, display the year from the date given in the cell L1. Answer: From worksheet Nike, in cell N4, find the median of all sales obtained from Salalah in Sales table. Answer:
Calculate the percentege gain and loss for bearish and bullish stock Markel Eserds. What is the Code fo il to he 9
The following describe the data structure and constraints that exist for a magazine publishing company: a. The company publishes one regional magazine each in Florida (FL), South Carolina (SC), Georgia (GA), and Tennessee (TN). b. The company has 300,000 customers (subscribers) distributed throughout the four states listed in Part 2a. c. On the first of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer’s state of residence (FL, SC, GA, TN). d. The table fields are as below: CUSTOMER (CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE, CUS_ZIP, CUS_SUBSDATE) INVOICE (INV_NUM, INV_REGION, CUS_NUM, INV_DATE, INV_TOTAL) The company is aware of the problems associated with centralized management and has decided that it is time to decentralize the management of the subscriptions in its four regional subsidiaries. Each subscription site will handle its…
Consider the following schema and which of the following DML statements will decrease salaries of professors in the 'CIS' by 0.03. Instructor(id, name, rank, dep, salary) Select one: O update instructor let salary = salary * 1.03 where rank = 'Professor' update instructor set salary = salary + salary* 0.03 where dep = 'CIS' and rank = 'Professor' O update instructor set salary = salary * 0.97 where dep = 'CIS' and rank = 'Professor' update instructor set salary salary * 1.03 where dep = 'CIS' = update instructor let salary = salary * 0.97 where dep = 'CIS' and rank = 'Professor'
9. The table P2.1 shows the number of paid transactions on the website during the period 2012 to 2020. (i) In cell E70, write a formula using RRI function to compute the Compounded Annual Growth Rate (CAGR) for the period 2012 to 2020.
What should the CPU do if it gets a cache request as it sends a block from the write buffer to main memory?
Find the location that has average salary more than 4000 dollars. Usually each location mayhave several departments.A) select loc from dept, emp where dept.deptno = emp.deptno group by loc having avg(sal) > 4000;B) select loc from emp group by loc having avg(sal) > 4000;C) select loc from dept group by loc having avg(sal) > 4000;D) select loc from dept where deptno in (select deptno from emp group by loc having avg(sal) > 4000);E) select loc from dept where deptno in (select deptno from emp group by deptno having avg(sal) > 4000);
Damon Davis was finalising Drano Plumbing's paperwork. He projected a $50,000 net profit. When he added up the columns on the Balance Sheet, he saw that the debit column amounted to $400,000 and the credit column amounted to $300,000. What was the most probable cause of the outcome discrepancy? If this was not the cause of the issue, how should he proceed to ascertain its origin?
Compute the volumes of cut and fill between stations 88+30 to 88+68 using the slope stake notes in the table on the following page. Use the average end area equation except for when the section produces a pyramid. In those situations, use the equation for a pyramid. Assume: Base Widths: cut = 50 ft; fill = 40 ft | Side Slopes: 2:1 | Gradient: -2% SURFACE GRADE STA L CL R ELEV. (ft) ELEV. (ft) C18.1 C10.2 92+00 891.6 874.63 C17.0 61.2 45.4 0 0 0 0 91+52 8575.6 875.59 0.0 25 20 20 25 F6.9 F11.4 91+00 864.5 876.63 F12.1 33.8 42.8 F8.2 F10.1 90+50 867.3 877.63 F10.3 36.4 40.2 F12.8 90+05 875.3 878.53 F3.2 20 45.6 C16.3 F12.2 89+73 879.2 879.17 57.6 44.4 C17.4 F8.3 89+59 885.6 879.45 C6.1 59.8 14 36.6 C10.2 F7.3 89+43 879.8 879.77 45.4 34.6 F16.1 89+08 873.7 880.47 F6.8 20 52.2 C16.8 F12.9 88+68 881.3 881.27 58.6 45.8 C24.0 88+30 890.9 882.03 C8.9 73.0 25
If any of the following choices are applicable, please tick them. According to this statement, constraint names are as follows:a) it may be used by the DBA to quickly identify a constraint b) two constraints can have the same name if they are situated in two distinct tablesC) Each constraint must be referred to by a distinct name.The names of constraints are case-sensitive D
Using the Supplier Checklist from NIST-IR 7622. Could you please provide supplier checklist mentioned in NIST-IR 7622.