Fsn84Ngy

1CREATE TABLE IF NOT EXISTS `Disease` (
2   `Name` varchar(20) NOT NULL,
3   `Age` int(10) unsigned NOT NULL,
4   `Descriptin` text NOT NULL,
5   `Sex` varchar(10) NOT NULL,
6   `Ethnicity` varchar(20) NOT NULL,
7    PRIMARY KEY (`Name`,`Sex`,`Ethnicity`),
8    KEY `Sex` (`Sex`),
9    KEY `Ethnicity` (`Ethnicity`)
10     ) 
11
12  ALTER TABLE `Disease`
13   ADD CONSTRAINT `Disease_ibfk_1` FOREIGN KEY (`Sex`) REFERENCES `Sex` (`Sex`)     ON DELETE CASCADE ON UPDATE CASCADE,
14  ADD CONSTRAINT `Disease_ibfk_2` FOREIGN KEY (`Ethnicity`) REFERENCES `Ethnicity` (`Ethnicity`)     ON DELETE CASCADE ON UPDATE CASCADE;
15	
16Disease(Name="DiseaseName",Age="40",Description="is caused by...",Sex="male",Ethnicity="Caucasian",Symptoms"Headache,sorethroat,fever")