CREATE TABLE `Kitap` ( `KitapID` int PRIMARY KEY, `KitapAdi` varchar(255) ); CREATE TABLE `Uye_Kitaplar` ( `kitaplar` varchar(255), FOREIGN KEY(`kitaplar`) REFERENCES `Kitap` (`KitapID`) ); CREATE TABLE `Uye` ( `UyeID` int PRIMARY KEY, `UyeAdi` varchar(255) ); CREATE TABLE `Uye_Kitaplik` ( `uye` varchar(255), `kitaplar` varchar(255), FOREIGN KEY(`uye`) REFERENCES `Uye` (`UyeID`), FOREIGN KEY(`kitaplar`) REFERENCES `Uye_Kitaplar` (`kitaplar`) ); CREATE TABLE `KitaplarUye` ( `member` varchar(255), `sptlitkitap` varchar(255), FOREIGN KEY(`member`) REFERENCES `Uye_Kitaplik` (`uye`), FOREIGN KEY(`sptlitkitap`) REFERENCES `Uye_Kitaplik` (`kitaplar`) );