Re: Three queries needed with the same result
Here are the results of SHOW CREATE TABLE for all four tables in question:
STUDENT Create Table: CREATE TABLE `STUDENT` ( `STUDENT_ID` bigint(20) NOT NULL, `SALUTATION` varchar(5) DEFAULT NULL, `FIRST_NAME` varchar(25) DEFAULT NULL, `LAST_NAME` varchar(25) NOT NULL, `STREET_ADDRESS` varchar(50) DEFAULT NULL, `ZIP` varchar(5) NOT NULL, `PHONE` varchar(15) DEFAULT NULL, `EMPLOYER` varchar(50) DEFAULT NULL, `REGISTRATION_DATE` date NOT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`), KEY `STU_ZIP_FK_I` (`ZIP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
ENROLLMENT Create Table: CREATE TABLE `ENROLLMENT` ( `STUDENT_ID` bigint(20) NOT NULL, `SECTION_ID` bigint(20) NOT NULL, `ENROLL_DATE` date NOT NULL, `FINAL_GRADE` int(11) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`,`SECTION_ID`), KEY `ENR_SECT_FK_I` (`SECTION_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
GRADE Create Table: CREATE TABLE `GRADE` ( `STUDENT_ID` bigint(20) NOT NULL, `SECTION_ID` bigint(20) NOT NULL, `GRADE_TYPE_CODE` char(2) NOT NULL, `GRADE_CODE_OCCURRENCE` bigint(20) NOT NULL, `NUMERIC_GRADE` double(3,0) NOT NULL, `COMMENTS` varchar(2000) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`STUDENT_ID`,`SECTION_ID`,`GRADE_TYPE_CODE`,`GRADE_CODE_OCCURRENCE`), KEY `GR_GRTW_FK_I` (`SECTION_ID`,`GRADE_TYPE_CODE`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
ZIPCODE Create Table: CREATE TABLE `ZIPCODE` ( `ZIP` varchar(5) NOT NULL, `CITY` varchar(25) DEFAULT NULL, `STATE` varchar(2) DEFAULT NULL, `CREATED_BY` varchar(30) NOT NULL, `CREATED_DATE` date NOT NULL, `MODIFIED_BY` varchar(30) NOT NULL, `MODIFIED_DATE` date NOT NULL, PRIMARY KEY (`ZIP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1