DROP TABLE IF EXISTS cpBook;
CREATE TABLE `cpBook`(
    `ISBN` char(10),
    `Name` varchar(20),
     PRIMARY KEY (`ISBN`,`Name`)
);
INSERT INTO cpBook VALUES ('0990637204', 'Andy Van');
INSERT INTO cpBook VALUES ('0990639204', 'Anders Stormer');
INSERT INTO cpBook VALUES ('0990638204', 'Jesper Skipper');
INSERT INTO cpBook VALUES ('0990638200', 'Jesper Skipper');


DROP TABLE IF EXISTS `works-at`;
CREATE TABLE `works-at`(
    `pName` varchar(20),
    `Name` varchar(20),
     PRIMARY KEY(`pName`,`Name`)
);
INSERT INTO `works-at` VALUES ('Discovery', 'Andy Van');
INSERT INTO `works-at` VALUES ('The Label', 'Jesper Skipper');
INSERT INTO `works-at` VALUES ('Gyldendahl', 'Anders Stormer');


DROP TABLE IF EXISTS ContactPerson;
CREATE TABLE `ContactPerson`(
    `Name` varchar(20) PRIMARY KEY
);
INSERT INTO ContactPerson VALUES ('Jesper Skipper');
INSERT INTO ContactPerson VALUES ('Anders Stormer');
INSERT INTO ContactPerson VALUES ('Andy Van');


DROP TABLE IF EXISTS `published-by`;
CREATE TABLE `published-by`(
    `ISBN` char(10),
    `pName` varchar(20),
    PRIMARY KEY (`ISBN`,`pName`)
);
INSERT INTO `published-by` VALUES ('0990637204', 'Gyldendahl');
INSERT INTO `published-by` VALUES ('0990639204', 'Discovery');
INSERT INTO `published-by` VALUES ('0990638204', 'The Label');
INSERT INTO `published-by` VALUES ('0990638200', 'Gyldendahl');


DROP TABLE IF EXISTS Publisher;
CREATE TABLE `Publisher`(
    `pName` varchar(20) PRIMARY KEY
);
INSERT INTO Publisher VALUES ('Gyldendahl');
INSERT INTO Publisher VALUES ('Discovery');
INSERT INTO Publisher VALUES ('The Label');


DROP TABLE IF EXISTS writtenBy;
CREATE TABLE `writtenBy`(
    `ISBN` char(10),
    `aName` varchar(20),
    PRIMARY KEY (`ISBN`,`aName`)
);
INSERT INTO writtenBy VALUES ('0990637204', 'Søren Lerby');
INSERT INTO writtenBy VALUES ('0990639204', 'George R.R. Martin');
INSERT INTO writtenBy VALUES ('0990638204', 'Henrik Baerbak');
INSERT INTO writtenBy VALUES ('0990638200', 'Søren Lerby');
INSERT INTO writtenBy VALUES ('0990639204', 'H.C. Andersen');


DROP TABLE IF EXISTS Authors;
CREATE TABLE `Authors`(
    `aName` varchar(20) PRIMARY KEY
);
INSERT INTO Authors VALUES ('Søren Lerby');
INSERT INTO Authors VALUES ('George R.R. Martin');
INSERT INTO Authors VALUES ('Henrik Baerbak');
INSERT INTO Authors VALUES ('H.C. Andersen');

DROP TABLE IF EXISTS numberOf;
CREATE TABLE `numberOf`(
    `ISBN` char(10) PRIMARY KEY,
    `pricePerBook` int
);
INSERT INTO numberOf VALUES ('0990637204', 20);
INSERT INTO numberOf VALUES ('0990639204', 10);
INSERT INTO numberOf VALUES ('0990638204', 50);
INSERT INTO numberOf VALUES ('0990638200', 100);



DROP TABLE IF EXISTS `contains`;
CREATE TABLE `contains`(
    `shopLocation` varchar(20),
    `ISBN` char(10),
    PRIMARY KEY (`ISBN`,`shopLocation`)
);
INSERT INTO `contains` VALUES ('Fiskemosevej','0990637204');
INSERT INTO `contains` VALUES ('Katrinebjergvej','0990639204');
INSERT INTO `contains` VALUES ('Vestre Ringgade','0990638204');
INSERT INTO `contains` VALUES ('Vestre Ringgade','0990638200');


DROP TABLE IF EXISTS Shop;
CREATE TABLE `Shop`(
    `shopLocation` varchar(20) PRIMARY KEY
);
INSERT INTO Shop VALUES ('Fiskemosevej');
INSERT INTO Shop VALUES ('Katrinebjergvej');
INSERT INTO Shop VALUES ('Vestre Ringgade');


DROP TABLE IF EXISTS `made-in`;
CREATE TABLE `made-in`(
    `shopLocation` varchar(20) PRIMARY KEY
);
INSERT INTO `made-in` VALUES ('Katrinebjergvej');
INSERT INTO `made-in` VALUES ('Vestre Ringgade');
INSERT INTO `made-in` VALUES ('Fiskemosevej');


DROP TABLE IF EXISTS Purchase;
CREATE TABLE `Purchase`(
    `totalPrice` int,
    `custormerDeliveryAddress` varchar(20)
);
INSERT INTO Purchase VALUES (400, 'OtherStreet 10');
INSERT INTO Purchase VALUES (200, 'RydeVænget 15');
INSERT INTO Purchase VALUES (100, 'RydeVænget 20');
INSERT INTO Purchase VALUES (300, 'RydeVænget 25');


DROP TABLE IF EXISTS WebShop;
CREATE TABLE `WebShop`(
    `shopLocation` varchar(20) PRIMARY KEY
);
INSERT INTO WebShop VALUES ('www.fishshop.dk');


DROP TABLE IF EXISTS Book;
CREATE TABLE `Book`(
    `ISBN` char(10) PRIMARY KEY,
    `Language` varchar(20),
    `bName` varchar(20),
    `YearPublished` char(4),
    `EditionNumber` int
);
INSERT INTO Book VALUES ('0990637204', 'Dansk', 'lær at tegne', '1992',2);
INSERT INTO Book VALUES ('0990639204', 'Engelsk', 'Song of Fire', '2007',1);
INSERT INTO Book VALUES ('0990638204', 'Engelsk', 'Softwareconstruction', '2013',1);
INSERT INTO Book VALUES ('0990638200', 'Ukrainsk', 'Learn English', '2013',5);