<prompt> Andika hati ya SQL ambayo huunda na kujaza schema ya hifadhidata ya uhusiano ya kudhibiti orodha ya vitabu vya maktaba na rekodi za mlinzi.PLINFORMAT  <response>: - Unda majedwali ya schema ya hifadhidata ya maktabaCREATE TABLE waandishi kitambulisho cha mwandishi INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR50 NOT NULL, jina_la_mwisho VARCHAR50 SI UFUPI;CREATE TABLE vitabu kitambulisho_cha kitabu INT PRIMARY KEY AUTO_INCREMENT, kichwa VARCHAR100 SI UFUPI, uchapishaji_mwaka INT, kitambulisho cha mwandishi INT, UFUNGUO WA KIGENI kitambulisho_cha_mwandishi MAREJEO waandishi kitambulisho_cha_mwandishi;TUNZA walinzi wa TABLE patron_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR50 NOT NULL, jina_la mwisho VARCHAR50 SI UFUPI, barua pepe VARCHAR100, nambari_ya_simu VARCHAR15;TUNZA mikopo ya TABLE loan_id INT PRIMARY KEY AUTO_INCREMENT, kitambulisho_cha_kitabu INT, mlezi_id INT, tarehe_ya_kukamilika DATE, alirudisha BOOLEAN DEFAULT FALSE, FOREIGN KEY kitabu_kitabu vitabu vya MAREJEOkitambulisho_cha, UFUNGUO WA NJE mlinzi_id MAREJELEO watejapatron_id;-- Jaza jedwali na data ya sampuliWEKA NDANI ya waandishi jina_la_mwisho, jina_la_mwishoTHAMANI George, Orwell, Aldous, Huxley, Ray, Bradbury;INGIA KATIKA vitabu kichwa, mwaka_wa_chapisho, kitambulisho_cha_mwandishiTHAMANI 1984, 1949, 1, Shamba la Wanyama, 1945, 1, Ulimwengu Mpya wa Ujasiri, 1932, 2, Fahrenheit 451, 1953, 3;WEKA NDANI ya wateja jina_la_kwanza, jina_la_mwisho, barua pepe, nambari_ya_simuMAADILI John, Doe, 555-123-4567, Jane, Smith, 555-987-6543;INGIA KWENYE mikopo kitambulisho_cha_kitabu, kitambulisho_cha_mdhamini, tarehe_ya_kulipwa, zilizorejeshwaMAADILI 1, 1, 2022-08-01, UONGO, 2, 2, 2022-07-15, TRUE, 3, 1, 2022-07-30, UONGO; 