summaryrefslogtreecommitdiffstats
path: root/Bachelor/Datenbanken/P5
diff options
context:
space:
mode:
authorSven Eisenhauer <sven@sven-eisenhauer.net>2023-11-10 15:11:48 +0100
committerSven Eisenhauer <sven@sven-eisenhauer.net>2023-11-10 15:11:48 +0100
commit33613a85afc4b1481367fbe92a17ee59c240250b (patch)
tree670b842326116b376b505ec2263878912fca97e2 /Bachelor/Datenbanken/P5
downloadStudium-master.tar.gz
Studium-master.tar.bz2
add new repoHEADmaster
Diffstat (limited to 'Bachelor/Datenbanken/P5')
-rw-r--r--Bachelor/Datenbanken/P5/beinhaltet.csv26
-rw-r--r--Bachelor/Datenbanken/P5/bus.csv5
-rw-r--r--Bachelor/Datenbanken/P5/data_p5.sql20
-rw-r--r--Bachelor/Datenbanken/P5/deckt_ab.csv11
-rw-r--r--Bachelor/Datenbanken/P5/enthaelt.csv12
-rw-r--r--Bachelor/Datenbanken/P5/fahrplan.csv1
-rw-r--r--Bachelor/Datenbanken/P5/fahrt.csv11
-rw-r--r--Bachelor/Datenbanken/P5/farbe.csv3
-rw-r--r--Bachelor/Datenbanken/P5/haltestelle.csv12
-rw-r--r--Bachelor/Datenbanken/P5/init_p5.sql231
-rw-r--r--Bachelor/Datenbanken/P5/liegt_in.csv12
-rw-r--r--Bachelor/Datenbanken/P5/nach.csv22
-rw-r--r--Bachelor/Datenbanken/P5/ort.csv4
-rw-r--r--Bachelor/Datenbanken/P5/route.csv3
-rw-r--r--Bachelor/Datenbanken/P5/routenabschnitt.csv26
-rw-r--r--Bachelor/Datenbanken/P5/setzt_ein.csv11
-rw-r--r--Bachelor/Datenbanken/P5/strecke.csv22
-rw-r--r--Bachelor/Datenbanken/P5/verwendet_als.csv22
-rw-r--r--Bachelor/Datenbanken/P5/von.csv22
-rw-r--r--Bachelor/Datenbanken/P5/wochentag.csv7
20 files changed, 483 insertions, 0 deletions
diff --git a/Bachelor/Datenbanken/P5/beinhaltet.csv b/Bachelor/Datenbanken/P5/beinhaltet.csv
new file mode 100644
index 0000000..315f2c9
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/beinhaltet.csv
@@ -0,0 +1,26 @@
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+2 1
+2 11
+2 12
+2 13
+2 14
+2 15
+2 16
+2 10
+3 13
+3 17
+3 18
+3 19
+3 20
+3 21
+3 22
+3 14
diff --git a/Bachelor/Datenbanken/P5/bus.csv b/Bachelor/Datenbanken/P5/bus.csv
new file mode 100644
index 0000000..6b4ef6d
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/bus.csv
@@ -0,0 +1,5 @@
+1 AB-XY 123 1990 50
+2 AB-XY 223 1990 50
+3 AB-XY 323 1990 50
+4 AB-XY 423 1990 50
+5 AB-XY 523 1990 50 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/data_p5.sql b/Bachelor/Datenbanken/P5/data_p5.sql
new file mode 100644
index 0000000..bc56c08
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/data_p5.sql
@@ -0,0 +1,20 @@
+USE busunternehmen;
+
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/bus.csv" INTO TABLE Bus LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/ort.csv" INTO TABLE Ort LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/wochentag.csv" INTO TABLE Wochentage LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/farbe.csv" INTO TABLE Farbe LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/haltestelle.csv" INTO TABLE Haltestelle LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/liegt_in.csv" INTO TABLE liegt_in LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/route.csv" INTO TABLE Route LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/strecke.csv" INTO TABLE Strecke LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/routenabschnitt.csv" INTO TABLE Routenabschnitt LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/von.csv" INTO TABLE Von LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/nach.csv" INTO TABLE Nach LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/verwendet_als.csv" INTO TABLE verwendet_als LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/beinhaltet.csv" INTO TABLE beinhaltet LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/fahrplan.csv" INTO TABLE Fahrplan LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/fahrt.csv" INTO TABLE Fahrt LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/setzt_ein.csv" INTO TABLE Setzt_ein LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/deckt_ab.csv" INTO TABLE Deckt_ab LINES TERMINATED BY '\n';
+LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/enthaelt.csv" INTO TABLE Enthaelt LINES TERMINATED BY '\n'; \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/deckt_ab.csv b/Bachelor/Datenbanken/P5/deckt_ab.csv
new file mode 100644
index 0000000..d42e46e
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/deckt_ab.csv
@@ -0,0 +1,11 @@
+1 1
+2 2
+3 3
+4 1
+5 2
+6 3
+7 1
+8 2
+9 3
+10 1
+11 2 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/enthaelt.csv b/Bachelor/Datenbanken/P5/enthaelt.csv
new file mode 100644
index 0000000..b4abdc7
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/enthaelt.csv
@@ -0,0 +1,12 @@
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+
diff --git a/Bachelor/Datenbanken/P5/fahrplan.csv b/Bachelor/Datenbanken/P5/fahrplan.csv
new file mode 100644
index 0000000..77e0e31
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/fahrplan.csv
@@ -0,0 +1 @@
+1 2005-04-01 2005-09-30 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/fahrt.csv b/Bachelor/Datenbanken/P5/fahrt.csv
new file mode 100644
index 0000000..3c8ec3d
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/fahrt.csv
@@ -0,0 +1,11 @@
+1 Mo 6:00
+2 Mo 8:00
+3 Di 10:00
+4 Mi 15:00
+5 Do 17:00
+6 Fr 14:00
+7 Sa 10:00
+8 Sa 22:00
+9 So 2:00
+10 So 3:00
+11 So 4:00 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/farbe.csv b/Bachelor/Datenbanken/P5/farbe.csv
new file mode 100644
index 0000000..05203d4
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/farbe.csv
@@ -0,0 +1,3 @@
+rot
+blau
+grün \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/haltestelle.csv b/Bachelor/Datenbanken/P5/haltestelle.csv
new file mode 100644
index 0000000..aff7665
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/haltestelle.csv
@@ -0,0 +1,12 @@
+1 h1 adresse1
+2 h2 adresse2
+3 h3 adresse3
+4 h4 adresse4
+5 h5 adresse5
+6 h6 adresse6
+7 h7 adresse7
+8 h8 adresse8
+9 h9 adresse9
+10 h10 adresse10
+11 h11 adresse11
+12 h12 adresse12 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/init_p5.sql b/Bachelor/Datenbanken/P5/init_p5.sql
new file mode 100644
index 0000000..84248fb
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/init_p5.sql
@@ -0,0 +1,231 @@
+DROP DATABASE IF EXISTS busunternehmen;
+CREATE DATABASE busunternehmen
+ COLLATE latin1_german1_ci;
+USE busunternehmen;
+
+CREATE TABLE Fahrplan (
+ fahrplannr int NOT NULL,
+ gueltigvon date,
+ gueltigbis date,
+ PRIMARY KEY (fahrplannr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Wochentage (
+ wochentag varchar(10),
+ PRIMARY KEY (wochentag)
+) ENGINE = InnoDB;
+
+
+CREATE TABLE Fahrt (
+ fahrtnr int NOT NULL,
+ wochentage varchar(10),
+ startzeit TIME,
+ PRIMARY KEY (fahrtnr),
+ FOREIGN KEY (wochentage) REFERENCES Wochentage(wochentag)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE
+) ENGINE = InnoDB;
+
+CREATE TABLE Bus (
+ busnr int NOT NULL,
+ kennzeichen varchar(12),
+ baujahr int,
+ sitzplaetze int,
+ PRIMARY KEY (busnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Farbe (
+ farbe varchar(10),
+ PRIMARY KEY (farbe)
+) ENGINE = InnoDB;
+
+CREATE TABLE Route (
+ routenr int NOT NULL,
+ farbe varchar(10),
+ routeninfo varchar(255),
+ PRIMARY KEY (routenr),
+ FOREIGN KEY (farbe) REFERENCES Farbe(farbe)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE
+) ENGINE = InnoDB;
+
+CREATE TABLE Routenabschnitt (
+ lfdnr int NOT NULL,
+ PRIMARY KEY (lfdnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Landkreis (
+ landkreis varchar(50),
+ PRIMARY KEY (landkreis)
+) ENGINE = InnoDB;
+
+CREATE TABLE Ort (
+ ortnr int NOT NULL,
+ ortname varchar(50),
+ landkreis varchar(50),
+ PRIMARY KEY (ortnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Haltestelle (
+ haltestellenr int NOT NULL,
+ name varchar(50),
+ position varchar(50),
+ PRIMARY KEY (haltestellenr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Strecke (
+ vonnr int,
+ nachnr int,
+ fahrzeit int,
+ entfernung float,
+ PRIMARY KEY (vonnr,nachnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Enthaelt (
+ fahrplannr int NOT NULL,
+ fahrtnr int NOT NULL,
+ PRIMARY KEY (fahrplannr,fahrtnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Setzt_ein (
+ fahrtnr int NOT NULL,
+ busnr int NOT NULL,
+ PRIMARY KEY (fahrtnr, busnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Deckt_ab (
+ fahrtnr int NOT NULL,
+ routenr int NOT NULL,
+ PRIMARY KEY (fahrtnr, routenr)
+) ENGINE = InnoDB;
+
+CREATE TABLE beinhaltet (
+ routenr int NOT NULL,
+ routenabschnittnr int NOT NULL,
+ PRIMARY KEY (routenr,routenabschnittnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE verwendet_als (
+ strecke_von int NOT NULL,
+ strecke_nach int NOT NULL,
+ routenabschnittnr int NOT NULL,
+ PRIMARY KEY (strecke_von,strecke_nach,routenabschnittnr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Von (
+ strecke_von int NOT NULL,
+ strecke_nach int NOT NULL,
+ haltestellenr int NOT NULL,
+ PRIMARY KEY (strecke_von,strecke_nach,haltestellenr)
+) ENGINE = InnoDB;
+
+CREATE TABLE Nach (
+ strecke_von int NOT NULL,
+ strecke_nach int NOT NULL,
+ haltestellenr int NOT NULL,
+ PRIMARY KEY (strecke_von,strecke_nach,haltestellenr)
+) ENGINE = InnoDB;
+
+CREATE TABLE liegt_in (
+ haltestellenr int NOT NULL,
+ ortnr int NOT NULL,
+ PRIMARY KEY (haltestellenr,ortnr)
+) ENGINE = InnoDB;
+
+ALTER TABLE Ort ADD
+ FOREIGN KEY (landkreis) REFERENCES Landkreis(landkreis)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Strecke ADD
+ FOREIGN KEY (vonnr) REFERENCES Haltestelle(haltestellenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Strecke ADD
+ FOREIGN KEY (nachnr) REFERENCES Haltestelle(haltestellenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Enthaelt ADD
+ FOREIGN KEY (fahrplannr) REFERENCES Fahrplan(fahrplannr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Enthaelt ADD
+ FOREIGN KEY (fahrtnr) REFERENCES Fahrt(fahrtnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Setzt_ein ADD
+ FOREIGN KEY (busnr) REFERENCES Bus(busnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Setzt_ein ADD
+ FOREIGN KEY (fahrtnr) REFERENCES Fahrt(fahrtnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Deckt_ab ADD
+ FOREIGN KEY (routenr) REFERENCES Route(routenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Deckt_ab ADD
+ FOREIGN KEY (fahrtnr) REFERENCES Fahrt(fahrtnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE beinhaltet ADD
+ FOREIGN KEY (routenr) REFERENCES Route(routenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE beinhaltet ADD
+ FOREIGN KEY (routenabschnittnr) REFERENCES Routenabschnitt(lfdnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE verwendet_als ADD
+ FOREIGN KEY (strecke_nach) REFERENCES Strecke(nachnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE verwendet_als ADD
+ FOREIGN KEY (strecke_von) REFERENCES Strecke(vonnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE verwendet_als ADD
+ FOREIGN KEY (routenabschnittnr) REFERENCES Routenabschnitt(lfdnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Von ADD
+ FOREIGN KEY (strecke_nach) REFERENCES Strecke(nachnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Von ADD
+ FOREIGN KEY (strecke_von) REFERENCES Strecke(vonnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Von ADD
+ FOREIGN KEY (haltestellenr) REFERENCES Haltestelle(haltestellenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE Nach ADD
+ FOREIGN KEY (strecke_nach) REFERENCES Strecke(nachnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Nach ADD
+ FOREIGN KEY (strecke_von) REFERENCES Strecke(vonnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE Nach ADD
+ FOREIGN KEY (haltestellenr) REFERENCES Haltestelle(haltestellenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+
+ALTER TABLE liegt_in ADD
+ FOREIGN KEY (haltestellenr) REFERENCES Haltestelle(haltestellenr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
+ALTER TABLE liegt_in ADD
+ FOREIGN KEY (ortnr) REFERENCES Ort(ortnr)
+ ON UPDATE CASCADE
+ ON DELETE CASCADE;
diff --git a/Bachelor/Datenbanken/P5/liegt_in.csv b/Bachelor/Datenbanken/P5/liegt_in.csv
new file mode 100644
index 0000000..7ea36a6
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/liegt_in.csv
@@ -0,0 +1,12 @@
+1 1
+2 1
+3 1
+4 1
+5 2
+6 2
+7 2
+8 3
+9 3
+10 4
+11 4
+12 4 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/nach.csv b/Bachelor/Datenbanken/P5/nach.csv
new file mode 100644
index 0000000..294e9fd
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/nach.csv
@@ -0,0 +1,22 @@
+1 2 2
+2 4 4
+4 5 5
+5 6 6
+6 7 7
+7 6 6
+6 5 5
+5 4 4
+4 2 2
+2 1 1
+2 3 3
+3 8 8
+8 9 9
+9 8 8
+8 3 3
+3 2 2
+9 10 10
+10 11 11
+11 12 12
+12 11 11
+11 10 10
+10 9 9 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/ort.csv b/Bachelor/Datenbanken/P5/ort.csv
new file mode 100644
index 0000000..77b5f89
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/ort.csv
@@ -0,0 +1,4 @@
+1 Ahlsen
+2 Boren
+3 Clausdorf
+4 Duistal \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/route.csv b/Bachelor/Datenbanken/P5/route.csv
new file mode 100644
index 0000000..28b872c
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/route.csv
@@ -0,0 +1,3 @@
+1 rot Marktplatz/Ahlsen - Rathaus/Boren
+2 blau Marktplatz/Ahlsen - Südtor/Clausdorf
+3 grün Nordtor/Clausdorf - Wartehalle/Duistal \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/routenabschnitt.csv b/Bachelor/Datenbanken/P5/routenabschnitt.csv
new file mode 100644
index 0000000..5036952
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/routenabschnitt.csv
@@ -0,0 +1,26 @@
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
+24
+25
+26 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/setzt_ein.csv b/Bachelor/Datenbanken/P5/setzt_ein.csv
new file mode 100644
index 0000000..5f2ea5d
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/setzt_ein.csv
@@ -0,0 +1,11 @@
+1 1
+2 2
+3 3
+4 4
+5 5
+6 1
+7 2
+8 3
+9 4
+10 5
+11 1 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/strecke.csv b/Bachelor/Datenbanken/P5/strecke.csv
new file mode 100644
index 0000000..0138a2f
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/strecke.csv
@@ -0,0 +1,22 @@
+1 2 1 1
+2 4 2 2
+4 5 3 3
+5 6 4 4
+6 7 5 5
+7 6 6 6
+6 5 5 5
+5 4 4 5
+4 2 3 3
+2 1 3 3
+2 3 4 4
+3 8 5 5
+8 9 7 7
+9 8 5 5
+8 3 4 4
+3 2 3 3
+9 10 6 6
+10 11 10 10
+11 12 7 7
+12 11 5 5
+11 10 5 5
+10 9 2 2 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/verwendet_als.csv b/Bachelor/Datenbanken/P5/verwendet_als.csv
new file mode 100644
index 0000000..c2112bc
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/verwendet_als.csv
@@ -0,0 +1,22 @@
+1 2 1
+2 4 2
+4 5 3
+5 6 4
+6 7 5
+7 6 6
+6 5 7
+5 4 8
+4 2 9
+2 1 10
+2 3 11
+3 8 12
+8 9 13
+9 8 14
+8 3 15
+3 2 16
+9 10 17
+10 11 18
+11 12 19
+12 11 20
+11 10 21
+10 9 22 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/von.csv b/Bachelor/Datenbanken/P5/von.csv
new file mode 100644
index 0000000..b7b04aa
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/von.csv
@@ -0,0 +1,22 @@
+1 2 1
+2 4 2
+4 5 4
+5 6 5
+6 7 6
+7 6 7
+6 5 6
+5 4 5
+4 2 4
+2 1 2
+2 3 2
+3 8 3
+8 9 8
+9 8 9
+8 3 8
+3 2 3
+9 10 9
+10 11 10
+11 12 11
+12 11 12
+11 10 11
+10 9 10 \ No newline at end of file
diff --git a/Bachelor/Datenbanken/P5/wochentag.csv b/Bachelor/Datenbanken/P5/wochentag.csv
new file mode 100644
index 0000000..35838f6
--- /dev/null
+++ b/Bachelor/Datenbanken/P5/wochentag.csv
@@ -0,0 +1,7 @@
+Mo
+Di
+Mi
+Do
+Fr
+Sa
+So \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2026-01-17 13:07:21 +0000