Problem 4 (20 Points) Surfside Bank agrees to lend Kernan Ma…

Problem 4 (20 Points) Surfside Bank agrees to lend Kernan Manufacturing Company $400,000 on January 1. Kernan Manufacturing Company signs a $400,000, 6%, 6-month note. Instructions Record the following using tabular analysis: The proceeds and issuance of the note by Kernan Manufacturing Company on January 1 The adjustment required assuming Kernan Manufacturing Company prepares financial statements on March 31 Kernan’s pay off of the note and interest at maturity on June 30, assuming that no further interest has been accrued.= To create a table, open the table editor as indicated in the image below. (Add rows and columns as needed.)

  This is the relational schema in text version if you canno…

  This is the relational schema in text version if you cannot see the graph. EMPLOYEE(Ssn, Fname, Minit, Lname, Bdate, Address, Sex, Salary, Super_Snn, Dno ) DEPARTMENT(DNumber, DName, Mgr_ssn, Mgr_start_date) DEPT_LOCATIONS(DNumber, DLocation) PROJECT(Pnumber, Pname, Plocation, Dnum) WORKS_ON(Essn, Pno, Hours) DEPENDENT(Essn, Dependent_name, Sex, Bdate, Relationship)