Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE kursusleverandoer
- DROP TABLE kursus
- DROP TABLE kursuslokale
- DROP TABLE enkeltvaerelse
- DROP TABLE kursist
- DROP TABLE tilmelding
- DROP TABLE kursusafvikling
- GO
- CREATE TABLE kursusleverandoer(
- email VARCHAR(25) PRIMARY KEY,
- navn VARCHAR(25),
- adresse VARCHAR(25)
- )
- CREATE TABLE kursus(
- kursusid INT PRIMARY KEY IDENTITY(1,1),
- email VARCHAR(25) FOREIGN KEY REFERENCES kursusleverandoer NOT NULL,
- navn VARCHAR(25),
- beskrivelse VARCHAR(40),
- maxantaldeltagere INT CHECK(maxantaldeltagere > 0),
- varighed INT CHECK(varighed >= 2 AND varighed <= 5),
- pris DECIMAL CHECK(pris > 0)
- )
- CREATE TABLE kursuslokale(
- lokalenr INT PRIMARY KEY IDENTITY(1,1),
- lokalenavn VARCHAR(15)
- )
- CREATE TABLE enkeltvaerelse(
- vaerelsesnr INT PRIMARY KEY IDENTITY(1,1)
- )
- CREATE TABLE kursist(
- email VARCHAR(25) PRIMARY KEY,
- adresse VARCHAR(25),
- navn VARCHAR(20)
- )
- CREATE TABLE tilmelding(
- tilmeldid INT PRIMARY KEY IDENTITY(1,1),
- email VARCHAR(25) FOREIGN KEY REFERENCES kursist(email) NOT NULL,
- vaerelsesnr INT FOREIGN KEY REFERENCES enkeltvaerelse(vaerelsesnr),
- kursusid INT FOREIGN KEY REFERENCES kursus(kursusid) NOT NULL,
- afviklingid INT FOREIGN KEY REFERENCES kursusafvikling(afviklingid) NOT NULL,
- oenskerovernatning bit
- )
- CREATE TABLE kursusafvikling(
- afviklingid INT PRIMARY KEY IDENTITY(1,1),
- lokalenr INT FOREIGN KEY REFERENCES kursuslokale(lokalenr) NOT NULL,
- kursusid INT FOREIGN KEY REFERENCES kursus(kursusid) NOT NULL,
- startdato DATE,
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement