From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001 From: Sven Eisenhauer Date: Fri, 10 Nov 2023 15:11:48 +0100 Subject: add new repo --- Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql | 166 ++++++++++++++++++++++++ 1 file changed, 166 insertions(+) create mode 100644 Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql (limited to 'Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql') diff --git a/Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql b/Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql new file mode 100644 index 0000000..68e3cf8 --- /dev/null +++ b/Bachelor/Datenbanken 2/Praktikum3/bibinsert.sql @@ -0,0 +1,166 @@ +insert into entleiher values +('E0101','Jasmin Baumann'); +insert into entleiher values +('E0102','Jennifer Stock'); +insert into entleiher values +('E0103','Fabian Sack'); +insert into entleiher values +('E0104','Marcell Meier'); +insert into entleiher values +('E0105','Daniel Mueller'); +insert into entleiher values +('E0106','Caroline Meyer'); +insert into entleiher values +('E0107','Kathrin Mai'); +insert into entleiher values +('E0108','Michael Bauer'); + +insert into leihobjekt values +('L010','a'); +insert into leihobjekt values +('L011','b'); +insert into leihobjekt values +('L012','a'); +insert into leihobjekt values +('L013','b'); +insert into leihobjekt values +('L014','z'); +insert into leihobjekt values +('L015','z'); +insert into leihobjekt values +('L016','z'); +insert into leihobjekt values +('L017','b'); +insert into leihobjekt values +('L018','b'); +insert into leihobjekt values +('L019','b'); +insert into leihobjekt values +('L020','a'); +insert into leihobjekt values +('L021','a'); +insert into leihobjekt values +('L022','a'); +insert into leihobjekt values +('L023','b'); +insert into leihobjekt values +('L024','b'); +insert into leihobjekt values +('L025','b'); +insert into leihobjekt values +('L026','b'); +insert into leihobjekt values +('L027','b'); +insert into leihobjekt values +('L028','b'); + +insert into audio values +('L010','kl','Sonate A Dur'); +insert into audio values +('L012','ro','One night at the opera'); +insert into audio values +('L020','ro','Mensch'); +insert into audio values +('L021','ro','Just the best'); +insert into audio values +('L022','po','Bravo Hits'); + +insert into zeitschrift values +('L014',1999,'Focus'); +insert into zeitschrift values +('L015',2004,'Brigitte'); +insert into zeitschrift values +('L016',2005,'Stern'); + +insert into buch values +('L011','3-8218-1406-311','Mobby Dick',2001); +insert into buch values +('L013','9-7838-2353-223','Pippi Langstrumpf',1998); +insert into buch values +('L017','4-2546-2625-341','Kristall der Träuume',2000); +insert into buch values +('L018','3-2533-5862-134','Kochen fuer Anfaenger',2002); +insert into buch values +('L019','4-1235-3332-125','Backen leicht gemacht',2003); +insert into buch values +('L023','3-8218-1406-301','Studentenkueche',2004); +insert into buch values +('L024','9-7838-2233-223','Lockruf der Vergangenheit',2004); +insert into buch values +('L025','4-2116-2625-341','Bitteres Geheimnis',2001); +insert into buch values +('L026','3-2533-5876-134','Oliver Twist',2003); +insert into buch values +('L027','4-1235-1000-125','Das Weihnachtsgespenst',2001); +insert into buch values +('L028','3-8218-1578-351','Das Muffinkochbuch',2004); + +insert into autor values +('A0101','Astrid Lindgren'); +insert into autor values +('A0102','Charles Dickens'); +insert into autor values +('A0103','Annette Weiler'); +insert into autor values +('A0104','Barbara Wood'); + +insert into autor_buch values +('L013','A0101'); +insert into autor_buch values +('L011','A0102'); +insert into autor_buch values +('L018','A0103'); +insert into autor_buch values +('L019','A0103'); +insert into autor_buch values +('L017','A0104'); +insert into autor_buch values +('L024','A0104'); +insert into autor_buch values +('L025','A0104'); +insert into autor_buch values +('L026','A0102'); +insert into autor_buch values +('L027','A0102'); +insert into autor_buch values +('L023','A0103'); +insert into autor_buch values +('L028','A0103'); + +insert into ausleihe values +('L012','E0102','07.09.2005','02.11.2005',1); +insert into ausleihe values +('L028','E0103','12.11.2005','07.12.2005',0); +insert into ausleihe values +('L011','E0101','02.02.2006','02.03.2006',0); +insert into ausleihe values +('L012','E0101','03.01.2006','31.01.2006',1); +insert into ausleihe values +('L012','E0103','10.01.2006','08.02.2006',1); +insert into ausleihe values +('L013','E0103','10.01.2006','08.02.2006',1); +insert into ausleihe values +('L014','E0103','10.01.2006','08.02.2006',1); +insert into ausleihe values +('L015','E0104','03.02.2006','03.03.2006',0); +insert into ausleihe values +('L016','E0106','04.01.2006','01.02.2006',1); +insert into ausleihe values +('L017','E0107','05.01.2006','02.03.2006',1); +insert into ausleihe values +('L019','E0108','03.02.2006','03.03.2006',0); +insert into ausleihe values +('L020','E0108','03.02.2006','03.03.2006',0); +insert into ausleihe values +('L021','E0108','03.02.2006','03.03.2006',0); +insert into ausleihe values +('L024','E0108','03.02.2006','03.03.2006',0); +insert into ausleihe values +('L025','E0108','07.02.2006','07.03.2006',0); +insert into ausleihe values +('L026','E0108','07.02.2006','07.03.2006',0); +insert into ausleihe values +('L027','E0108','07.02.2006','07.03.2006',0); + + + -- cgit v1.2.3