USE myDatabase;

INSERT INTO `ADDRESSTYPE` (`AddressType`, `Description`) VALUES
(1, ‘Location’),
(2, ‘Postal’),
(3, ‘Delivery’);

INSERT INTO `PHONETYPE` (`PhoneType`, `Description`) VALUES
(1, ‘Home’),
(2, ‘Mobile’),
(3, ‘Work’);

INSERT INTO `CERTIFICATION` (`CertificationID`, `Description`) VALUES
(1, ‘Responsible Serving of Alcohol’),
(2, ‘First Aide Level 1’),
(3, ‘First Aide Level 2’),
(4, ‘First Aide Level 3’)
;

INSERT INTO STAFFTYPE (`StaffType`, `Description`) VALUES
(1, ‘Fulltime’),
(2, ‘Casual’),
(3, ‘Part-time’)
;

INSERT INTO PRODUCT (`ProductID`, `Description`) VALUES
(1, ‘Chair Cover’),
(2, ‘Chair Sash’),
(3, ‘Chair’),
(4, ‘Table – 8 seater round’),
(5, ‘Table – 8 seater rectangle’),
(6, ‘Table – 10 seater round’),
(7, ‘Table – 10 seater rectangle’),
(8, ‘Knife – steak’),
(9, ‘Knife – butter’),
(10, ‘Knife – entree’),
(11, ‘Knife – main’),
(12, ‘Fork – fish’),
(13, ‘Fork – entree’),
(14, ‘Fork – main’)
;

INSERT INTO SUPPLIER (`SupplierID`, `SupplierName`, `ContactName`) VALUES
(‘S0001’, ‘Decorative Events’,’Fred Smith’),
(‘S0002’, ‘KT Event Hire’, ‘John Depp’),
(‘S0003’, ‘Party Hire’, ‘Bonny Bons’);

INSERT INTO SUPPLIERPRODUCT (`SupplierID`, `ProductID`) VALUES
(‘S0001’,1),
(‘S0001’,2),
(‘S0001’,3),
(‘S0001’,4),
(‘S0001’,5),
(‘S0001’,6),
(‘S0001’,7),
(‘S0001’,8),
(‘S0001’,9),
(‘S0001’,10),
(‘S0001’,11),
(‘S0001’,12),
(‘S0001’,13),
(‘S0001’,14),
(‘S0002’,1),
(‘S0002’,2),
(‘S0002’,3),
(‘S0002’,4),
(‘S0002’,5),
(‘S0002’,6),
(‘S0002’,7),
(‘S0003’,8),
(‘S0003’,9),
(‘S0003’,10),
(‘S0003’,11),
(‘S0003’,12),
(‘S0003’,13),
(‘S0003’,14)
;

INSERT INTO `EVENTTYPE` (`EventType`, `Description`) VALUES
(1, ‘Wedding’),
(2, ‘Christening’),
(3, ‘Christmas Party’),
(4, ‘Birthday Party’),
(5, ’40th Birthday Party’),
(6, ‘Conference’)
;

INSERT INTO `CUSTOMER` (`CustomerID`, `ContactName`,`EmailAddress`,`CorporationName`,`Website`) VALUES
(‘c0001’,’Jim…