OLF:
create database OLF;
use OLF;
--

create table tblkund
(knr int primary key,
Fnamn varchar(30),
Enamn varchar(30),
Gadress varchar(30),
Postnr char (6),
Padress varchar(30),
Rabatt double);

insert into tblkund
(knr, Fnamn, Enamn, Gadress, Postnr, Padress, Rabatt)
values
('111','Eric','Johnson','Gitarrgatan 1','41344','Göteborg','0.5'),
('112', 'Steve','Morse','Gitarrgatan 2','41366','Stockholm','0.2'),
('116', 'John','Petrucci','Gibsongatan 12','43571','Göteborg','0.2');

---
create table tblkundorder
(ordernr int primary key,
kundnummer int,
levdatum date,
bestdatum date);

insert into tblkundorder
(ordernr, kundnummer, levdatum, bestdatum)
values
('2','116','2006-01-01','2006-01-01'),
('3','116','2006-01-06','2006-01-06'),
('4','112','2006-01-10','2006-01-10'),
('5','111','2006-01-14','2006-01-14'),
('6','112','2006-01-22','2006-01-19'),
('8','116','2006-01-01','2006-01-01'),
('9','116','2006-03-23','2006-03-23');

---

create table tblorderrad
(ordernr int,
artnr int,
antal int,
FOREIGN KEY (ordernr) REFERENCES tblkundorder(ordernr));

insert into tblorderrad
(ordernr, artnr, antal)
values
('2','10000','12'),
('3','10000','50'),
('3','10004','1'),
('4','10002','2'),
('5','10008','3'),
('5','10002','2'),
('6','10004','3'),
('6','10002','2'),
('2','10002','1'),
('8','10004','2'),
('8','10002','3'),
('9','10005','2'),
('9','10001','20');

---

create table tblartikel
(artnr int primary key,
artnamn varchar(30),
lagerantal int,
bestpunkt int,
pris int);

insert into tblartikel
(artnr, Artnamn, lagerantal, bestpunkt, pris)
values
('10000','Bult','35', '20', '15'),
('10001','Mutter','200', '40', '15'),
('10002','Kniv','250', '60', '25'),
('10003','Yxa','35', '40', '65'),
('10004','Hyvel','20', '50', '45'),
('10005','Skruv','100', '20', '1'),
('10006','Spik','300', '80', '1');