Create table employee_Performance (
	employee_Seq Int NOT NULL,
	type Char(20) NOT NULL,
	date Date NOT NULL,
	notes Blob NOT NULL,
	performance_Seq Int NOT NULL AUTO_INCREMENT,
	UNIQUE (performance_Seq),
 Primary Key (performance_Seq)) ENGINE = InnoDB;

Create table employee (
	f_Name Char(20) NOT NULL,
	l_Name Char(50) NOT NULL,
	address1 Char(20) NOT NULL,
	address2 Char(10) NOT NULL,
	ssn Char(11) NOT NULL,
	employee_Seq Int NOT NULL,
	UNIQUE (employee_Seq),
 Primary Key (employee_Seq)) ENGINE = MyISAM;

Create table employee_Performance_Type (
	type Char(20) NOT NULL,
	UNIQUE (type),
 Primary Key (type)) ENGINE = MyISAM;


Alter table employee_Performance add unique Alter_Key4 (employee_Seq,type,date);
Alter table employee add unique Alter_Key3 (l_Name,ssn);


Alter table employee_Performance add Foreign Key (employee_Seq) references employee (employee_Seq) on delete  restrict on update  restrict;
Alter table employee_Performance add Foreign Key (type) references employee_Performance_Type (type) on delete  restrict on update  restrict;