Diagram for database test state stateCode CHAR(2) description VARCHAR(30) Indexes quarter qtrCode VARCHAR(5) location CHAR(2) minSal DECIMAL(6,2) minHrs TINYINT Indexes employer companyName VARCHAR(30) division VARCHAR(30) address VARCHAR(30) city VARCHAR(20) stateCode CHAR(2) zipcode VARCHAR(10) Indexes interview InterviewID INT interviewDate DATE companyName VARCHAR(30) division VARCHAR(30) qtrCode VARCHAR(5) 424876.27652120x320/7 salaryOffered DECIMAL(8,2) minHrsOffered TINYINT listing ENUM(Y', 'n') jobDesc VARCHAR(255) Indexes Notes: This database is for tracking co-op opportunities. Table "quarter" holds information about what is desired. Table "interview" holds information about offers. You noticed an inconsistency in the employer table. Change the company name "Rochester Application Software" to "Rochester Software Design. After the above change has been completed enter in the following query: SELECT companyname, address, zipcode FROM employer WHERE companyname LIKE "Rochester Software Design"; Use the coding standards that were in Appendix A on HW02. companyname address Rochester Software Design 16 Broad Street Rochester Software Design | 16 Broad Street 2 rows in set (0.00 sec) | zipcode 14621 14621