Account Name in Account 1. Write a CREATE TABLE statements for the all tables with the following specifications: Cascade only updates from Clerk to Account Cascade only deletions from Account to Client. Don't cascade updates nor deletions from Account to withdrawal. The default value of ClerkphoneNb in Clerk 0096200000". 2. Write an UPDATE statement to modify the Clerk of Account given the Clerk name and Account name. 3. Write an ALTER statement to add the column, ClerkEmail in to Clerk. Assume that is, ClerkEmail required 4. Create a stored procedure named TransactionPro that updates the table Withdrawal" which store the transactions of accounts, and also update the table "Account with the new balance. 5. State whether the above database has deletions anomalies. if yes solve it. 6. Is the above data in the BCNF, justify your answers? 7. The customers must enter their security credential (password or (Iris-Recognition) before they make any transactions, Write SQL statements to alter existing tables and create new tables, and insert records such that the above feature could be implemented. A 400 ENG 3:30 PM son Not yelwered Madu 20.00 Flag question Given The Implementation of the Bank database study it carefully and answer the following Tasks: Clerk (ClerkID. ClerkName, ClerkphoneNb) Account (Account Number, Account Name, balance, ClerkID) Client (ClientID. ClientName, Address, Account Number) Withdrawal (TransactionID. Account Number. Amount Transaction' Time) The Bank database has the following referential integrity constraints: ClerkID in Account must exist in ClerkID in Clerk Account Number in Client must exist in AccountNumber in Account Account Number in Withdrawal must exist in AccountNumber in Account The School database has the following unique constraints: ClerkName in Clerk ClientNam in Client Account Name in Account . 1. Write a CREATE TABLE statements for the all tables with the following specifications Cascade only updates from Clerk to Account Cascade only deletions from Account to Client A0001 ING 30PM 5