1 files changed, 42 insertions, 0 deletions
diff --git a/eindopdracht/b5.sql b/eindopdracht/b5.sql
new file mode 100644
index 0000000..fa7a548
--- /dev/null
+++ b/eindopdracht/b5.sql
@@ -0,0 +1,42 @@
+create table if not exists Land (
+	ID int unsigned not null auto_increment,
+	Naam varchar(90) not null,
+	primary key (ID),
+	unique(Naam)
+);
+
+create table if not exists Locatie (
+	ID int unsigned not null auto_increment,
+	LandID int unsigned not null,
+	Naam varchar(90) not null,
+	primary key (ID),
+	foreign key (LandID) references Land(ID),
+	unique(Naam)
+);
+
+create table if not exists Merk (
+	ID int unsigned not null auto_increment,
+	Naam varchar(90) not null,
+	primary key (ID),
+	unique(Naam)
+);
+
+create table if not exists Hoofdkantoor (
+	ID int unsigned not null auto_increment,
+	LocatieID int unsigned not null,
+	MerkID int unsigned not null,
+	primary key (ID),
+	foreign key (LocatieID) references Locatie(ID),
+	foreign key (MerkID) references Merk(ID)
+);
+
+create table if not exists `Type` (
+	ID int unsigned not null auto_increment,
+	Naam varchar(90) not null,
+	MerkID int unsigned not null,
+	Vermogen int unsigned not null,
+	primary key (ID),
+	foreign key (MerkID) references Merk(ID),
+	unique(Naam)
+);
+