CREATE TABLE Poststed (
postnr		char (4) ,
poststed	char (20) NOT NULL,
CONSTRAINT entPostnr PRIMARY KEY (postnr)
);

CREATE TABLE Leverandorer (
leverandornr    CHAR (10) NOT NULL,
navn            CHAR (30) NOT NULL,
adresse         CHAR (25) NOT NULL,
postnr          CHAR (4) NOT NULL,
telefonnr       CHAR (8) NOT NULL,
CONSTRAINT entLeverandornr PRIMARY KEY (leverandornr)
);

CREATE TABLE CD (
cdnr		CHAR (10) NOT NULL,
artist		CHAR (50) NOT NULL,
plassering	CHAR (4),
antall		INT,
aarstall	INT,
selskap		char (20),
innkPris	NUMERIC (3,2) ,
utPris		NUMERIC (3,2) ,
leverandornr	CHAR (10) NOT NULL,
tittel		CHAR (50) NOT NULL,
CONSTRAINT entCdnr PRIMARY KEY (cdnr),
CONSTRAINT leverandornr FOREIGN KEY (leverandornr) REFERENCES Leverandorer
);

CREATE TABLE Kunde (
kundenr		CHAR (10) NOT NULL,
fornavn		CHAR (20) NOT NULL,
etternavn	CHAR (30) NOT NULL,
adresse		CHAR (25) NOT NULL,
postnr		CHAR (4)  NOT NULL,
telefonnr	CHAR (8),
CONSTRAINT entKundenr PRIMARY KEY (kundenr),
CONSTRAINT postnr FOREIGN KEY (postnr) REFERENCES Poststed
);

CREATE TABLE Ansatt (
ansattnr    CHAR (10) NOT NULL,
fornavn     CHAR (20) NOT NULL,
etternavn   CHAR (30) NOT NULL,
adresse     CHAR (30) NOT NULL,
postnr      CHAR (4) NOT NULL,
telefonnr   CHAR (8) NOT NULL,
CONSTRAINT entAnsattnr PRIMARY KEY (ansattnr),
CONSTRAINT apostnr FOREIGN KEY (postnr) REFERENCES Poststed
);

CREATE TABLE Ordre (
ordrenr		CHAR (10) NOT NULL,
ansattnr	CHAR (10) NOT NULL,
kundenr		CHAR (10),
dato		DATE NOT NULL,
CONSTRAINT entOrdrenr PRIMARY KEY (ordrenr),
CONSTRAINT ansattnr FOREIGN KEY (ansattnr) REFERENCES Ansatt,
CONSTRAINT kundenr FOREIGN KEY (kundenr) REFERENCES Kunde
);

CREATE TABLE CDiOrdre (
ordrenr		CHAR (10) NOT NULL,
cdnr		CHAR (10) NOT NULL,
antall		INT NOT NULL,
CONSTRAINT cdiordre PRIMARY KEY (ordrenr,cdnr),
CONSTRAINT ordrenr FOREIGN KEY (ordrenr) REFERENCES Ordre,
CONSTRAINT cdnr FOREIGN KEY (cdnr) REFERENCES CD
);