Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop database Flyplass;
- create database Flyplass;
- use Flyplass;
- create table Flyplass(
- FPKode int (10),
- FNavn varchar(45),
- Telefon varchar(20),
- Primary key (FPKode)
- );
- create table Rullebane(
- RKode int (20),
- Pos varchar (45),
- Lengde varchar (45),
- FPKode int (10),/*Hentet fra Flyplass(Primær)*/
- Primary key (RKode),
- Foreign key (FPKode) references Flyplass(FPKode)
- );
- create table Resie(
- Dato int (10),
- Tid varchar(20),
- Avgang varchar (20),
- Ankomst varchar (20),
- Antpers varchar(20),
- RKode int (20),
- FKode int(20),
- primary key (Dato),
- foreign key (RKode) references Rullebane(RKode),
- foreign key (FKode) references Fly(FKode)
- );
- create table Fly(
- FKode int(20),
- FSelskap varchar (45),
- PPlass varchar (45),
- primary key (FKode)
- );
- use Flyplass;
- insert into Flyplass
- values ();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement