Question

1 Approved Answer

Posted on Sep 30, 2024

could you write database with sql for this diagram? we need to set up a database, load some data into it and make 4 queries.

image text in transcribed

could you write database with sql for this diagram? we need to set up a database, load some data into it and make 4 queries. The first of these queries should be to separate address information. ie neighborhood, street, apartment name. should separate the house number information as in the table below (the table is in German, but has enough explanatory information)

should add new customer in second query.In the third query, it should show the transfer amounts higher than 30.000. and the 4th query should also have a customer deletion.

image text in transcribed

amooey telephone number Custome Surname able transfer to IBAN of customer Tcustomer address +9 IBAN customer name Accounter Tenech Date customer Surname customer nas Account Customer birthdate Dote Customer number IBAN custane number Table transfer money with customer number to customer name customer account customer surname amount of money KundenNr. KundenkontoNr. IBAN 00 0000 1010 6514 21 TR74 0455 2000 0000 1010 6514 21 00 0000 6547 5222 78 TR74 0455 2000 0000 6547 5222 78 00 0000 6245 7489 21 TR740455 2000 0000 6245 7489 21 00 0000 2454 6322 41 TR74 0455 2000 0000 2454 6322 41 Too 0000 5547 3221 87 TR74 0455 2000 0000 5547 3221 87 00 0000 5547 3221 87 TR740455 2000 0000 5547 3221 87 100 000 64113478 36 TR47 455 2000 0000 6411 3478 36 00 0000 7456 5159 44 TR47 0455 2000 0000 7456 5159 44 00 0000 6654 4125 74 TR47 0455 2000 0000 6654 4125 74 900 0000 5462 2247 46 TR47 0455 2000 0000 5462 2247 46 10 00 0000 2452 4578 33 TR47 0455 2000 0000 2452 4578 33 KUNDE Kunden_Vorname Kunden_Nachname Geburtsdatum TelefonNr. Atilla zdemirolu 15.01.1945 216 387 95 54 Timur ] Seluk 12.11.1942 216 425 78 62 Muammer Sun 22.06.1930 216 341 36 22 Ahmet Adnan ) Saygun 15.12.1933 216 021 58 64 15. 12. 1933 216 021 Tulin 17.06.1911 216 754 12 44 Cemal Resit ter Rey 28.04.1900|216 147 56 33 Hasan Ferit Alnar 12.02.1922216 546 27 13 Necil Kazm Akses 29.10.1912 312 982 44 77 Olcayto Ahmet Tusuz 14.08.1913 312 774 30 14 Melih Kibar 11.07.1902 312541 34 26 uvi Cemal Adresse Gl Caddesi 7, 34752 Memur Caddesi 75, 34012 Ahlat Caddesi 19, 34255 Toros Caddesi 44, 34755 Alk Caddesi 72, 34665 MotCaddesi 72 , Ankara Caddesi 16, 34951 Fidan Caddesi 54, 34444 Cinnah Caddesi 63, 06110 Konsolosluklar Caddesi 79, 06441 ileri Caddesi 86, 06421 Atilla KundenNr. KundenkontoNr. IBAN 00 0000 1010 6514 21 TR74 0455 2000 0000 1010 6514 21 00 0000 6547 5222 78 TR74 0455 2000 0000 6547 5222 78 00 0000 6245 7499 21 TR74 0455 2000 0000 6245 7489 21 00 0000 2454 6322 41 TR74 0455 2000 0000 2454 6322 41 + 00 0000 5547 3221 87 TR74 0455 2000 0000 5547 3221 87 00 0000 6411 3478 36 TR47 0455 2000 0000 6411 3478 36 700 0000 7456 5159 44 TR47 0455 2000 0000 7456 5159 44 00 0000 6654 4125 74 TR47 0455 2000 0000 6654 4125 74 900 0000 5462 2247 46 TR47 0455 2000 0000 5462 2247 46 10 00 0000 2452 4578 33 TR47 0455 2000 0000 2452 4578 33 KUNDE Kunden_Vorname Kunden_Nachname Geburtsdatum TelefonNr. zdemirolu 15.01.1945 216 387 95 54 Timur Seluk 12.11.1942 216 425 78 62 Muammer Sun 22.06.1930 216 341 36 22 Ahmet Adnan Saygun 15.12.1933 216 021 58 64 Ulvi Cemal Erkin 17.06.1911216 754 12 44 Cemal Resit Rey 28.04.1900|216 147 56 33 | Hasan Perit Alnar 12.02.1922 216 546 27 13 Necil Kazm Akses 29.10.1912 312 982 44 77 Olcayto Ahmet Tusuz 14.08.1913 312 774 30 14 Meliha Kibar 11.07.1902 312541 34 26 Strae_Name Gl Caddesi Memur Caddesi Ahlat Caddesi Ahlat Caddesi Toros Caddesi Alsk Caddesi Ankara Caddesi Fidan Caddesi Cinnah Caddesi Konsolosluklar Caddesi ileri Caddesi HausNr. PLZ 7 347521 75 34012 19 34255 44 34755 72 12 17005 34665 16 16 34951 54 63 06110 79 06441 86 06421 34444 amooey telephone number Custome Surname able transfer to IBAN of customer Tcustomer address +9 IBAN customer name Accounter Tenech Date customer Surname customer nas Account Customer birthdate Dote Customer number IBAN custane number Table transfer money with customer number to customer name customer account customer surname amount of money KundenNr. KundenkontoNr. IBAN 00 0000 1010 6514 21 TR74 0455 2000 0000 1010 6514 21 00 0000 6547 5222 78 TR74 0455 2000 0000 6547 5222 78 00 0000 6245 7489 21 TR740455 2000 0000 6245 7489 21 00 0000 2454 6322 41 TR74 0455 2000 0000 2454 6322 41 Too 0000 5547 3221 87 TR74 0455 2000 0000 5547 3221 87 00 0000 5547 3221 87 TR740455 2000 0000 5547 3221 87 100 000 64113478 36 TR47 455 2000 0000 6411 3478 36 00 0000 7456 5159 44 TR47 0455 2000 0000 7456 5159 44 00 0000 6654 4125 74 TR47 0455 2000 0000 6654 4125 74 900 0000 5462 2247 46 TR47 0455 2000 0000 5462 2247 46 10 00 0000 2452 4578 33 TR47 0455 2000 0000 2452 4578 33 KUNDE Kunden_Vorname Kunden_Nachname Geburtsdatum TelefonNr. Atilla zdemirolu 15.01.1945 216 387 95 54 Timur ] Seluk 12.11.1942 216 425 78 62 Muammer Sun 22.06.1930 216 341 36 22 Ahmet Adnan ) Saygun 15.12.1933 216 021 58 64 15. 12. 1933 216 021 Tulin 17.06.1911 216 754 12 44 Cemal Resit ter Rey 28.04.1900|216 147 56 33 Hasan Ferit Alnar 12.02.1922216 546 27 13 Necil Kazm Akses 29.10.1912 312 982 44 77 Olcayto Ahmet Tusuz 14.08.1913 312 774 30 14 Melih Kibar 11.07.1902 312541 34 26 uvi Cemal Adresse Gl Caddesi 7, 34752 Memur Caddesi 75, 34012 Ahlat Caddesi 19, 34255 Toros Caddesi 44, 34755 Alk Caddesi 72, 34665 MotCaddesi 72 , Ankara Caddesi 16, 34951 Fidan Caddesi 54, 34444 Cinnah Caddesi 63, 06110 Konsolosluklar Caddesi 79, 06441 ileri Caddesi 86, 06421 Atilla KundenNr. KundenkontoNr. IBAN 00 0000 1010 6514 21 TR74 0455 2000 0000 1010 6514 21 00 0000 6547 5222 78 TR74 0455 2000 0000 6547 5222 78 00 0000 6245 7499 21 TR74 0455 2000 0000 6245 7489 21 00 0000 2454 6322 41 TR74 0455 2000 0000 2454 6322 41 + 00 0000 5547 3221 87 TR74 0455 2000 0000 5547 3221 87 00 0000 6411 3478 36 TR47 0455 2000 0000 6411 3478 36 700 0000 7456 5159 44 TR47 0455 2000 0000 7456 5159 44 00 0000 6654 4125 74 TR47 0455 2000 0000 6654 4125 74 900 0000 5462 2247 46 TR47 0455 2000 0000 5462 2247 46 10 00 0000 2452 4578 33 TR47 0455 2000 0000 2452 4578 33 KUNDE Kunden_Vorname Kunden_Nachname Geburtsdatum TelefonNr. zdemirolu 15.01.1945 216 387 95 54 Timur Seluk 12.11.1942 216 425 78 62 Muammer Sun 22.06.1930 216 341 36 22 Ahmet Adnan Saygun 15.12.1933 216 021 58 64 Ulvi Cemal Erkin 17.06.1911216 754 12 44 Cemal Resit Rey 28.04.1900|216 147 56 33 | Hasan Perit Alnar 12.02.1922 216 546 27 13 Necil Kazm Akses 29.10.1912 312 982 44 77 Olcayto Ahmet Tusuz 14.08.1913 312 774 30 14 Meliha Kibar 11.07.1902 312541 34 26 Strae_Name Gl Caddesi Memur Caddesi Ahlat Caddesi Ahlat Caddesi Toros Caddesi Alsk Caddesi Ankara Caddesi Fidan Caddesi Cinnah Caddesi Konsolosluklar Caddesi ileri Caddesi HausNr. PLZ 7 347521 75 34012 19 34255 44 34755 72 12 17005 34665 16 16 34951 54 63 06110 79 06441 86 06421 34444