zdHwbLZ0

1-- MySQL dump 10.13  Distrib 5.7.17, for osx10.12 (x86_64)
2--
3-- Host: localhost    Database: DoreensDatenbank
4-- ------------------------------------------------------
5-- Server version	5.7.17
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `DoreensDatenbank`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `DoreensDatenbank` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `DoreensDatenbank`;
25
26--
27-- Table structure for table `Assistenten`
28--
29
30DROP TABLE IF EXISTS `Assistenten`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Assistenten` (
34  `PerslNr` int(11) unsigned NOT NULL,
35  `Name` varchar(50) DEFAULT NULL,
36  `Fachgebiet` varchar(50) DEFAULT NULL,
37  `Boss` int(11) unsigned NOT NULL,
38  PRIMARY KEY (`PerslNr`),
39  KEY `FK_Assi_Boss` (`Boss`),
40  CONSTRAINT `FK_Assi_Boss` FOREIGN KEY (`Boss`) REFERENCES `Professoren` (`PersNr`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8;
42/*!40101 SET character_set_client = @saved_cs_client */;
43
44--
45-- Dumping data for table `Assistenten`
46--
47
48LOCK TABLES `Assistenten` WRITE;
49/*!40000 ALTER TABLE `Assistenten` DISABLE KEYS */;
50INSERT INTO `Assistenten` VALUES (3002,'Platon','Ideenlehre',2125),(3003,'Aristoteles','Syllogistik',2125),(3004,'Wittgenstein','Sprachtheorie',2126),(3005,'Rhetikus','Planetenbewegung',2127),(3006,'Newton','Keplersche Gesetze',2127),(3007,'Spinoza','Gott und Natur',2126);
51/*!40000 ALTER TABLE `Assistenten` ENABLE KEYS */;
52UNLOCK TABLES;
53
54--
55-- Table structure for table `Professoren`
56--
57
58DROP TABLE IF EXISTS `Professoren`;
59/*!40101 SET @saved_cs_client     = @@character_set_client */;
60/*!40101 SET character_set_client = utf8 */;
61CREATE TABLE `Professoren` (
62  `PersNr` int(11) unsigned NOT NULL,
63  `Name` varchar(50) DEFAULT NULL,
64  `Rang` varchar(50) DEFAULT NULL,
65  `Raum` varchar(50) DEFAULT NULL,
66  PRIMARY KEY (`PersNr`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `Professoren`
72--
73
74LOCK TABLES `Professoren` WRITE;
75/*!40000 ALTER TABLE `Professoren` DISABLE KEYS */;
76INSERT INTO `Professoren` VALUES (2125,'Sokrates','C4','226'),(2126,'Russel','C4','232'),(2127,'Kopernikus','C3','310'),(2133,'Popper','C3','52'),(2134,'Augustinus','C3','309'),(2136,'Curie','C4','36'),(2137,'Kant','C4','7');
77/*!40000 ALTER TABLE `Professoren` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `Studenten`
82--
83
84DROP TABLE IF EXISTS `Studenten`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `Studenten` (
88  `MatrNr` int(11) unsigned NOT NULL,
89  `Name` varchar(50) DEFAULT NULL,
90  `Semester` int(11) DEFAULT NULL,
91  PRIMARY KEY (`MatrNr`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `Studenten`
97--
98
99LOCK TABLES `Studenten` WRITE;
100/*!40000 ALTER TABLE `Studenten` DISABLE KEYS */;
101INSERT INTO `Studenten` VALUES (24002,'Xenokrates',18),(25403,'Jonas',12),(26120,'Fichte',10),(26830,'Aristoxenos',8),(27550,'Schopenhauer',6),(28106,'Carnap',3),(29120,'Theophrastos',2),(29555,'Feuerbach',2);
102/*!40000 ALTER TABLE `Studenten` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `Vorlesungen`
107--
108
109DROP TABLE IF EXISTS `Vorlesungen`;
110/*!40101 SET @saved_cs_client     = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `Vorlesungen` (
113  `VorlNr` int(11) unsigned NOT NULL,
114  `Titel` varchar(50) DEFAULT NULL,
115  `SWS` int(11) NOT NULL,
116  `gelesen von` int(11) NOT NULL,
117  PRIMARY KEY (`VorlNr`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `Vorlesungen`
123--
124
125LOCK TABLES `Vorlesungen` WRITE;
126/*!40000 ALTER TABLE `Vorlesungen` DISABLE KEYS */;
127INSERT INTO `Vorlesungen` VALUES (4052,'Logik',4,2125),(4630,'Die 3 Kritiken',4,2137),(5001,'Grundzüge',4,2137),(5022,'Glaube und Wissen',2,2134),(5041,'Ethik',4,2125),(5043,'Erkenntnistheorie',3,2126),(5049,'Mäeutik',2,2125),(5052,'Wissenschaftstheorie',3,2126),(5216,'Bio-Ethik',2,2126),(5259,'Der Wiener Kreis',2,2133);
128/*!40000 ALTER TABLE `Vorlesungen` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `hören`
133--
134
135DROP TABLE IF EXISTS `hören`;
136/*!40101 SET @saved_cs_client     = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `hören` (
139  `MatrNr` int(11) unsigned NOT NULL,
140  `VorlNr` int(11) unsigned NOT NULL,
141  PRIMARY KEY (`MatrNr`,`VorlNr`),
142  KEY `FK_Hören_Vorlesung` (`VorlNr`),
143  CONSTRAINT `FK_Hören_Student` FOREIGN KEY (`MatrNr`) REFERENCES `Studenten` (`MatrNr`),
144  CONSTRAINT `FK_Hören_Vorlesung` FOREIGN KEY (`VorlNr`) REFERENCES `Vorlesungen` (`VorlNr`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `hören`
150--
151
152LOCK TABLES `hören` WRITE;
153/*!40000 ALTER TABLE `hören` DISABLE KEYS */;
154INSERT INTO `hören` VALUES (27550,4052),(26120,5001),(27550,5001),(29120,5001),(25403,5022),(29555,5022),(28106,5041),(29120,5041),(29120,5049),(28106,5052),(28106,5216),(28106,5259);
155/*!40000 ALTER TABLE `hören` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `prüfen`
160--
161
162DROP TABLE IF EXISTS `prüfen`;
163/*!40101 SET @saved_cs_client     = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `prüfen` (
166  `MatrNr` int(11) unsigned NOT NULL,
167  `VorlNr` int(11) unsigned NOT NULL,
168  `PersNr` int(10) unsigned NOT NULL,
169  `Note` decimal(20,9) NOT NULL,
170  PRIMARY KEY (`MatrNr`,`VorlNr`,`PersNr`)
171) ENGINE=InnoDB DEFAULT CHARSET=utf8;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping data for table `prüfen`
176--
177
178LOCK TABLES `prüfen` WRITE;
179/*!40000 ALTER TABLE `prüfen` DISABLE KEYS */;
180INSERT INTO `prüfen` VALUES (25403,5041,2125,2.300000000),(27550,4630,2137,2.700000000),(28106,5001,2126,1.000000000);
181/*!40000 ALTER TABLE `prüfen` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `voraussetzen`
186--
187
188DROP TABLE IF EXISTS `voraussetzen`;
189/*!40101 SET @saved_cs_client     = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `voraussetzen` (
192  `Vorgänger` int(11) unsigned NOT NULL,
193  `Nachfolger` int(11) unsigned NOT NULL,
194  PRIMARY KEY (`Vorgänger`,`Nachfolger`)
195) ENGINE=InnoDB DEFAULT CHARSET=utf8;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `voraussetzen`
200--
201
202LOCK TABLES `voraussetzen` WRITE;
203/*!40000 ALTER TABLE `voraussetzen` DISABLE KEYS */;
204INSERT INTO `voraussetzen` VALUES (5001,5041),(5001,5043),(5001,5049),(5041,5052),(5041,5216),(5043,5052),(5052,5259);
205/*!40000 ALTER TABLE `voraussetzen` ENABLE KEYS */;
206UNLOCK TABLES;
207/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
208
209/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
210/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
211/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
212/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
213/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
214/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
215/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
216
217-- Dump completed on 2017-01-03 20:13:43