CREATE TABLE `office` ( `officeCode` varchar(10) NOT NULL, `city` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, PRIMARY KEY (`officeCode`) ) ENGINE=InnoDB DEFAULT; CREATE TABLE `employee` ( `employeeNumber` int(11) NOT NULL, `lastName` varchar(50) NOT NULL, `firstName` varchar(50) NOT NULL, `officeCode` varchar(10) NOT NULL, PRIMARY KEY (`employeeNumber`), KEY `officeCode` (`officeCode`), CO