If Second National Bank has more rate-sensitive liabilities than rate-sensitive assets, it can reduce interest-rate risk with a swap which requires Second National to

A central bank sale of _________ to purchase _________ in the foreign exchange market results in an equal decline in its international reserves and the monetary base.

When the exchange rate for the euro changes from $1.20 to $1.00, then, holding everything else constant, the euro has

Referring to Table 1, if interest rates rise by 5 percentage points, then bank profits (measured using gap analysis) will

Consider the following statements. A functional dependency is checked by examining the instance of a relation. The violation of a functional dependency is checked by examining the instance of a relation. If an attribute has occurred on the right-hand side of some functional dependencies but not on the left-hand side of any functional dependency, it must be in the candidate keys. Give reasons for each statement whether it is correct or incorrect. Give the reason even if it is correct.

Given database schema: Faculty (fid, name, tenured, dname, salary, chairID)Department (dname, phoneNumber, numberOfFaculty)Course (fid, dname, semester, cname) Write a trigger (one trigger command) in SQL for the following statement: When a new record is inserted into Faculty, if the department does not exist in the Department table, then insert a record into Department with the same department name and the phone number equal to null. Additionally, when a record is deleted from Faculty, if the faculty member is tenured, then raise an error (use RAISE_APPLICATION_ERROR(-10000, ’error’)).

Exercise 1 (Armstrong Axioms, Functional Dependencies)

Referring to Table 1, if interest rates rise by 5 percentage points, then bank profits (measured using gap analysis) will

Exercise 1 (Armstrong Axioms, Functional Dependencies)

Given database schema: Faculty (fid, name, tenured, dname, salary, chairID)Department (dname, phoneNumber, numberOfFaculty)Course (fid, dname, semester, cname) Write an assertion check in SQL for the following condition: The salary of any faculty member cannot be greater than their chair’s salary.