Primary key: To identify each record in a table, at least there must be one data field, which should be unique. That is corresponding data field of every record should be unique. It is called primary key. Primary key is used to identify the unique record from a collection of records. Foreign key: Sometimes, it is necessary to relate two tables to maintain some details in another table, which contains the relationship between two tables. So, to connect two tables, a primary key field in one table is added to the related table, and it is called foreign key.

Question

Add a new class Checking Account that inherits from the BankAccount class, and has a double instance variable overdraftLimit in addition to the variables inherited from the superclass. Create a constructor for the Checking Account class that takes in the account number, account holder name, initial balance, account type and overdraft limit as input, and uses the super keyword to call the constructor of the superclass, passing in the account number, account holder name and initial balance, account type. Re-write the withdraw() method in the CheckingAccount class so that it first checks if the withdrawal amount is less than the current balance plus the overdraft limit. If it is, the withdrawal is allowed and the balance is updated. If not, the method should return an error message "Insufficient funds". Create a new method displayOverdraft Limit() that returns the overdraft limit of the Checking Account. In the BankAccountTest class, create a new object of type Checking Account with…

Answer 1

Question

Chapter 8, Problem 18P

Program Plan Intro

Primary key:

To identify each record in a table, at least there must be one data field, which should be unique.

That is corresponding data field of every record should be unique.

It is called primary key.

Primary key is used to identify the unique record from a collection of records.

Foreign key:

Sometimes, it is necessary to relate two tables to maintain some details in another table, which contains the relationship between two tables.

So, to connect two tables, a primary key field in one table is added to the related table, and it is called foreign key.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Add a new class Checking Account that inherits from the BankAccount class, and has a double instance variable overdraftLimit in addition to the variables inherited from the superclass. Create a constructor for the Checking Account class that takes in the account number, account holder name, initial balance, account type and overdraft limit as input, and uses the super keyword to call the constructor of the superclass, passing in the account number, account holder name and initial balance, account type. Re-write the withdraw() method in the CheckingAccount class so that it first checks if the withdrawal amount is less than the current balance plus the overdraft limit. If it is, the withdrawal is allowed and the balance is updated. If not, the method should return an error message "Insufficient funds". Create a new method displayOverdraft Limit() that returns the overdraft limit of the Checking Account. In the BankAccountTest class, create a new object of type Checking Account with…

Need help answering this pseudocode row question

Need help! Wheres the error in the pseudocode?