1 files changed, 166 insertions, 0 deletions
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);
+
+
+