CREATE TABLE WRITINGGROUPS
  (
  group_name  VARCHAR(20)     NOT NULL,
  head_writer VARCHAR(20) NOT NULL,
  year_formed VARCHAR(4) NOT NULL,
  subject     VARCHAR(12)  NOT NULL       ,
  CONSTRAINT pk_writing_groups PRIMARY KEY (group_name)
  );

CREATE TABLE PUBLISHERS
  (
  publisher_name  VARCHAR(20)     NOT NULL,
  publisher_address VARCHAR(20) NOT NULL,
  publisher_phone VARCHAR(10) NOT NULL,
  publisher_email     VARCHAR(50) NOT NULL        ,
  CONSTRAINT pk_publishers PRIMARY KEY (publisher_name)
  );

CREATE TABLE BOOKS
  (
  group_name  VARCHAR(20)     NOT NULL,
  book_title  VARCHAR(40)     NOT NULL,
  publisher_name VARCHAR(20) NOT NULL,
  year_published VARCHAR(4) NOT NULL,
  numOfPages    VARCHAR(12) NOT NULL        ,
  CONSTRAINT pk_books PRIMARY KEY (group_name, book_title),
  CONSTRAINT fk_books FOREIGN KEY (publisher_name) REFERENCES PUBLISHERS (publisher_name)
  );

INSERT INTO WRITINGGROUPS VALUES('Gryffindor','Sarah Buchman','1900', 'Math');
INSERT INTO WRITINGGROUPS VALUES('Slytherin','Klee Hull','1778', 'English');
INSERT INTO WRITINGGROUPS VALUES('Ravenclaw','Nevill Longbottom','1993', 'Science');
INSERT INTO WRITINGGROUPS VALUES('Hufflepuff','Nortrop Grumman','1598', 'War');

INSERT INTO PUBLISHERS VALUES('Harry Potter', '1563 Hogwarts Rd', '3455672378', 'hairyharry@gmail.com');
INSERT INTO PUBLISHERS VALUES('Ron Weasly', '2424 Ginger Ave', '6782346734', 'ronweasly@hotmail.com');
INSERT INTO PUBLISHERS VALUES('Hermonie Granger', '8955 Muggle Dr', '8935681256', 'hermoney@yahoo.com');
INSERT INTO PUBLISHERS VALUES('Draco Malfoy', '6315 Felton Rd', '4536742373', 'myfatherwill@gmail.com');

INSERT INTO BOOKS VALUES('Gryffindor', 'How to be Good', 'Hermonie Granger', '1934', '1000');
INSERT INTO BOOKS VALUES('Slytherin', 'All About Snakes', 'Draco Malfoy', '1789', '3457');
INSERT INTO BOOKS VALUES('Ravenclaw', 'Quit Sucking at Quidditch', 'Harry Potter', '1997', '500');
INSERT INTO BOOKS VALUES('Hufflepuff', 'Defensive Contracting', 'Ron Weasly', '1610', '20346');