import java.util.Scanner;

 

public class BankAccount {   protected double balance;   private int numOfDeposits;   protected int numOfWithdrawals;   private double annualInterestRate;

 

  public BankAccount(double balance, double annualInterestRate) {     this.balance = balance;     this.annualInterestRate = annualInterestRate;   }

 

  public void deposit(double amount) {     balance += amount;     numOfDeposits++;   }

 

  public void withdraw(double amount) {     balance -= amount;     numOfWithdrawals++;   }

 

  public void calcInterest() {     double monthlyInterestRate = (annualInterestRate / 12);     double monthlyInterest = balance * monthlyInterestRate;     balance += monthlyInterest;   }

 

  public void monthlyProcess() {     balance -= (numOfWithdrawals + numOfDeposits);     calcInterest();     numOfWithdrawals = 0;     numOfDeposits = 0;   } }

 

class SavingsAccount extends BankAccount {   private boolean status;

 

  public SavingsAccount(double balance, double annualInterestRate) {     super(balance, annualInterestRate);     status = balance >= 25;   }

 

  public void withdraw(double amount) {     if (!status) {       System.out.println("The savings account is inactive");       return;     }     super.withdraw(amount);     status = balance >= 25;   }

 

  public void deposit(double amount) {     super.deposit(amount);     status = balance >= 25;   }

 

  public void monthlyProcess() {     int withdrawalsOverLimit = numOfWithdrawals - 4;     if (withdrawalsOverLimit > 0) {       balance -= (1 * withdrawalsOverLimit);     }     super.monthlyProcess();     status = balance >= 25;   }

 

  public boolean getStatus() {     return status;   }

 

public Object getBalance() {     return null; }

 

public String getNumDeposits() {     return null; }

 

public String getNumWithdrawals() {     return null; }

 

public Object getServiceCharge() {     return null; }

 

public boolean isActive() {     return false; } }

 

class Test {     private static SavingsAccount account;

 

    public static void main(String[] args) {         Scanner sc = new Scanner(System.in);         double balance, interestRate, monthlyInterest;         int numDeposits = 0, numWithdrawals = 0, serviceCharge = 0;         System.out.print("Please enter your Account Balance: ");         balance = sc.nextDouble();         System.out.print("Please enter the Annual Interest Rate for the account: ");         interestRate = sc.nextDouble();         monthlyInterest = balance * interestRate / 12.0 / 100.0;         balance = balance + monthlyInterest;         System.out.println("The balance after adding the Monthly Interest: " + balance);         System.out.print("Please enter the amount you want to withdraw: ");         double withdraw = sc.nextDouble();         balance = balance - withdraw;         numWithdrawals += 1;         System.out.println("Balance after withdrawal: " + balance);         System.out.print("Do you want to make any more withdrawals? If yes please enter 1 and if no please enter 0: ");         int moreWithdrawals = sc.nextInt();         while (moreWithdrawals == 1) {            System.out.print("Please enter the amount you want to withdraw: ");            withdraw = sc.nextDouble();            balance = balance - withdraw;            numWithdrawals += 1;            System.out.println("Balance after withdrawal: " + balance);            System.out.print("Do you want to make any more withdrawals? If yes please enter 1 and if no please enter 0: ");            moreWithdrawals = sc.nextInt();         }         System.out.print("Please enter the amount you want to deposit: ");         double deposit = sc.nextDouble();         balance = balance + deposit;         numDeposits += 1;         System.out.println("Balance after depositing: " + balance);         System.out.print("Do you want to make any more deposits? If yes please enter 1 and if no please enter 0: ");         int moreDeposits = sc.nextInt();         while (moreDeposits == 1) {            System.out.print("Please enter the amount you want to deposit: ");            deposit = sc.nextDouble();            balance = balance + deposit;            numDeposits += 1;            System.out.println("Balance after depositing: " + balance);            System.out.print("Do you want to make any more deposits? If yes please enter 1 and if no please enter 0: ");            moreDeposits = sc.nextInt();         }         System.out.println("The total number of deposits made: " + numDeposits);         System.out.println("The total number of withdrawals made: " + numWithdrawals);

 

System.out.printf("The total service charge of the month is %.2f\n", account.getServiceCharge()); if (balance >= 0) {     System.out.println("The savings account is currently active");     } else {     System.out.println("The savings account is currently inactive"); System.out.println("The savings account is currently " + (account.isActive() ? "active" : "inactive"));     } } }   document every line in this code ( dont change anything in it ) header comment also included .

PL/SQL language

STATEMENTS :
A Bank is characterized by:
• Bank code: character on 10 positions,
• Company name: character on 10 positions
• Capital: Numeric with 3 positions after the comma,
• Address: character on 10 positions.
It has a set of Agencies. Each Agency is characterized by:
• Agency code: character in 10 positions,
• Label: character in 10 positions,
• Address: character on 10 positions,
• Latitude: character on 10 positions,
• Longitude: character in 10 positions.
An Agency has several clients. A Client is characterized by:
• Customer code: character on 10 positions,
• Name: character in 30 positions,
• Address: character in 30 positions,
• Telephone: character on 10 positions
A Client may have 1 or more Accounts. An Account is characterized by:
• Account number: character on 10 positions,
• Balance: Numerical with 3 positions after the comma,
• Flow rate threshold: Numeric with 3 positions after the decimal point,
• Balance date: Date.

• State: character on 10 positions.

There are two types of Account
• Current account
• Savings account.
An Account can have one or more Cards attached to it. A Card is characterized by:
• Card number: character on 16 positions
• Type of card: character on 10 positions
• Ceiling: Numerical with 3 positions after the decimal point
• Expiration date: Date

QUESTIONS :
1. Give the class diagram.
2. Give the different tables indicating the relationships between the different Tables.
3. Write a Withdraw function in PL/SQL that takes an account number as an argument and a withdrawal amount then performs the withdrawal operation by modifying the balance in the Account table. Note the withdrawal can only be made if balance – amount > threshold. The function returns the new balance after the withdrawal.
4. Write a Payment function in PL/SQL that takes as argument a number of the account and an amount then updates the balance in the Account table. The function returns the new balance after withdrawal.
5. Write a trigger to raise an exception in the event of a decrease in the balance of an account whose status is “blocked”.
6. To archive the history of Account table update operations, create a History table (NumCpt, operation_date, operation_type). Write a trigger allowing, after the execution of each operation on Account, to add a tuple regarding this operation to the History table.
7. Write a Withdrawal_Card function in PL/SQL which takes as argument a card number card and an amount then updates the balance in the Account table. Function returns the new balance after the withdrawal. The withdrawal can only be made if the balance allows him and the ceiling.
8. Write a trigger allowing to raise an exception in the case of an expiration of the date of a card.
9. Write a procedure that allows each Bank to display the branch code, wording of the Agency, name and balance of the Client having the largest balance in this Agency.
10. Write a PL/SQL procedure to display for all Agencies the three first highest Account balances, if there is not only one balance then display for the second and third, the same value as the first; and if he only two different balances exist, so display the same value for the third than the second.

1. Create a Java class named Package that contains the following:
a. Package should have three private instance variables of type double named length, width, and
height.
b. Package should have one private instance variable of the type Scanner named input, initialized
to System.in.
c. No-args (explicit default) public constructor, which initializes all three double instance variables to
1.0.
d. Initial (parameterized) public constructor, which defines three parameters of type double,
named length, width, and height, which are used to initialize the instance variables of same name.
e. Public copy constructor, with a parameter of type Package, used to duplicate an
existing Package object.
f. Three public void methods named inputLength, inputWidth, and inputHeight. Each method
will prompt the user for the appropriate property, and input a double value using
the Scanner object input to initialize the instance variables
g. A public void method named displayDimensions which prints the dimensions as length X width X
height (each value separated by a “ X “).
h. A public method of type double named calcVolume that calculates the volume and returns the
result as a double value.

(b) Consider the following classes: public class House - ي شما هر چند = = private String rooms; public House() String rooms - new String [31; rooms (0) - "living room"; rooms [1] - "kitchen"; rooms (2) - "bedroom"; = public void print RoomList () for (int i-0; i < rooms.length; i++) { System.out.println (rooms[1]); = ہم نوا شهيد - public class Block يا نو public static void main(String[args) له House myblouse - new House(); myHouse.print RoomList(); د ه د The program compiles, but when you run the program, you get the following exception: Exception in thread "main" java.lang.NullPointerException at House.print RoomList (House.java:12) at Block.main (Block.java:6) The point of the method printRoomList is to print all the Strings in the house to the screen. Why does it give the error and write the code to fix the error while successfully printing all the rooms to the screen?