eYH5Pksj

1DROP DATABASE IF EXISTS `Flyankomster`;
2CREATE DATABASE `Flyankomster`;
3USE `Flyankomster` ;
4
5
6CREATE TABLE IF NOT EXISTS `Flyankomster`.`Flyplass` (
7    `FpKode` VARCHAR(45) NOT NULL,
8    `FpNavn` VARCHAR(45),
9    `FpTlf` VARCHAR(45),
10    PRIMARY KEY (`FpKode`)
11);
12
13
14CREATE TABLE IF NOT EXISTS `Flyankomster`.`Rullebane` (
15    `RKode` INT NOT NULL,
16    `RLengde` VARCHAR(45),
17    `RPos` VARCHAR(45),
18    `Flyplass_FpKode` VARCHAR(45) NOT NULL,
19    PRIMARY KEY (`RKode`),
20    FOREIGN KEY (`Flyplass_FpKode`)
21        REFERENCES `Flyankomster`.`Flyplass` (`FpKode`)
22);
23
24
25CREATE TABLE IF NOT EXISTS `Flyankomster`.`Fly` (
26    `FlKode` INT NOT NULL,
27    `FlPP` INT,
28    `FlAntP` INT,
29    `FlSelskap` VARCHAR(45),
30    `Rullebane_RKode` INT NOT NULL,
31    PRIMARY KEY (`FlKode`),
32    FOREIGN KEY (`Rullebane_RKode`)
33        REFERENCES `Flyankomster`.`Rullebane` (`RKode`)
34);
35
36
37CREATE TABLE IF NOT EXISTS `Flyankomster`.`Reise` (
38    `ReiseType` VARCHAR(45) NOT NULL,
39    `Dato` DATE NOT NULL,
40    `Klokkeslett` TIME NOT NULL,
41	`Fly_FlKode` INT NOT NULL,
42    PRIMARY KEY (`Dato` , `Klokkeslett`, `Fly_FlKode`),
43    FOREIGN KEY (`Fly_FlKode`)
44        REFERENCES `Flyankomster`.`Fly` (`FlKode`)
45);