> Home > PostgreSQL > BibliothekDB

Bibliothek-DB - Daten-Tabellen ^

(Quelle: gem. freundlichem Vorschlag eines Studenten)

Buch ^

buchnr	titel	seiten
1	Red Storm Rising.	857
2	Executive Orders	1377
3	Romeo und Julia	283
4	Tamerlane	99
5	Murders in the Rue Morgue	202
6	The Raven and Other Poems	125
7	Great Tales of Horror	89
8	Harry Potter and the Sorcerers Stone	888
9	Harry Potter and the Chamber of Secrets	952
10	Harry Potter and the Prisoner of Azkaban	1025
11	Harry Potter and the Goblet of Fire	1213
12	The Hitch-Hikers Guide to the Galaxy	271
13	The Restaurant at the End of the Universe	257
14	Life, the Universe and Everything	193
15	So Long, and Thanks for All the Fish	193
16	IT	1105
17	Egons Autobiographie	619
18	Mein Leben	313
19	Der Computer-Daemon	181
20	Mein Leben	313

Person ^

persnr	vorname	nachname	gebdat	verstorben
1	Tom	Clancy	1947-12-04	null
2	Peter	Imhauser	1976-05-13	null
3	Sabine	Muellner	1978-08-12	null
5	William	Shakespeare	1564-04-23	null
6	J.K.	Rowling	1965-07-31	1616-04-23
7	Stephen	King	1947-09-21	null
8	Edgar Allen	Poe	1809-01-19	1849-07-10
9	Douglas	Adams	1952-11-03	2001-05-14
10	Samuel	Fischer	1984-05-12	null
11	Jonas	Strassel	1964-08-08	null
12	Katharina	Ebenthal	1974-11-17	null
13	Herta	Lohengrin	1946-06-02	null
14	Jochen	Maler	1955-03-18	null
15	Birgit	Kochmann	1981-03-16	null
16	Peter	Krass	1938-11-04	null
17	Egon	Wimmer	1967-08-13	null
18	Anna	Bohr	1976-10-27	null
19	Karin	Virt	1972-02-02	null
20	Ali	Jussufowitc	1979-09-18	null
21	Hugo	Mayr	1944-11-17	null
22	Juergen	Richter	1967-06-14	null
23	Sabine	Gerer	1983-07-08	null
24	Joachim	Morgenstern	1923-11-19	null
25	Egon	Mayer	1996-05-19	null
26	Egon	Mayer	1967-06-14	null
27	Thomas	Brezina	1963-01-30	null

Mitarbeiter ^

persnr	eingestellt	gehalt
3	2000-04-08	360
16	1995-08-03	870
17	1995-08-03	870
18	2000-12-19	290
19	1995-08-03	870
20	2002-07-30	460
21	1998-07-11	360

Kunde ^

persnr	eingeschrieben	treuepunkte
2	1984-07-07	614
10	2000-01-17	27
11	1997-02-18	413
12	1994-04-04	3755
13	1998-03-26	815
14	2002-01-31	125
15	2002-04-26	99
22	2000-06-04	316
23	1999-07-11	825
24	1973-02-01	9414

Ausleihe ^

kpersnr	buchnr	mpersnr	ausleihdat
2	1	3	2001-06-04
2	1	17	2003-09-18
2	2	3	2003-12-11
2	3	3	2003-05-17
10	1	21	1999-05-30
10	3	16	2004-03-20
10	6	17	2003-03-19
10	11	19	2001-06-04
11	1	20	2000-04-14
11	10	20	2000-04-30
12	7	20	2003-10-16
14	12	19	2002-03-01
14	13	19	2002-03-01
14	14	19	2000-04-30
14	15	19	2002-03-01
22	3	16	2002-01-17
23	8	17	2000-07-03
23	9	17	2000-07-03
23	10	16	2000-07-03
23	11	16	2000-07-03
23	12	16	2000-07-03
24	1	18	1981-03-17
24	2	18	1984-05-16
24	3	19	1986-12-29
24	3	20	1993-04-28
24	5	19	2000-04-14
24	8	3	2003-12-11
24	13	18	1990-05-24
24	16	18	1992-03-19
24	17	19	2003-06-13
24	17	20	1996-04-23

Rueckgabe ^

buchnr	mpersnr	ausleihdat	rueckgabedat
1	3	2001-06-04	2001-06-18
1	18	1981-03-17	1992-03-19
2	18	1984-05-16	1992-03-19
12	16	2002-03-01	2002-03-24
13	16	2002-03-01	2002-03-24
13	18	1990-05-24	1992-03-19
15	16	2002-03-01	2002-03-24

Autor ^

persnr	nation
1	USA
5	England
6	England
7	USA
8	England
9	England
25	Oesterreich
26	Oesterreich
27	Oesterreich

Autorenschaft ^

autor	buch
1	1
1	2
5	3
6	8
6	9
6	10
6	11
7	16
8	4
8	5
8	6
8	7
9	12
9	13
9	14
9	15
25	17
26	17
26	18
26	20
27	19