/********************************************************************************/
/*																				*/
/*	Kroenke, Auer, Vandenberg, Yoder - DBC (8th Edition)						*/
/*																				*/
/*  Pet_Database Data															*/
/*																				*/
/*	These are the MySQL 5.7						SQL code solutions				*/
/*																				*/
/********************************************************************************/

USE pet_database;

/*****   PET_OWNER DATA   *******************************************************/

INSERT INTO PET_OWNER (OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) 
	VALUES('Downs', 'Marsha', '555-537-8765', 'Marsha.Downs@somewhere.com');
INSERT INTO PET_OWNER (OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) 
	VALUES('James', 'Richard', '555-537-7654', 'Richard.James@somewhere.com');
INSERT INTO PET_OWNER (OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) 
	VALUES('Frier', 'Liz', '555-537-6543', 'Liz.Frier@somewhere.com');
INSERT INTO PET_OWNER (OwnerLastName, OwnerFirstName, OwnerEmail)
	VALUES('Trent', 'Miles', 'Miles.Trent@somewhere.com');

/*****   BREED DATA   ***********************************************************/

INSERT INTO BREED VALUES('Border Collie', 15.0, 22.5, 20);
INSERT INTO BREED VALUES('Cashmere', 10.0, 15.0, 12);
INSERT INTO BREED VALUES('Collie Mix', 17.5, 25.0, 18);
INSERT INTO BREED VALUES('Std. Poodle', 22.5, 30.0, 18);

INSERT INTO BREED(BreedName) VALUES('Unknown');


/*****   PET DATA   *************************************************************/

INSERT INTO PET (PetName, PetType, PetBreed, PetDOB, OwnerID) VALUES('King', 'Dog', 'Std. Poodle', '2014-02-27', 1);
INSERT INTO PET (PetName, PetType, PetBreed, PetDOB, OwnerID) VALUES('Teddy', 'Cat', 'Cashmere', '2015-02-01', 2);
INSERT INTO PET (PetName, PetType, PetBreed, PetDOB, OwnerID) VALUES('Fido', 'Dog', 'Std. Poodle', '2013-07-17', 1);
INSERT INTO PET (PetName, PetType, PetBreed, PetDOB, OwnerID) VALUES('AJ', 'Dog', 'Collie Mix', '2014-05-05', 3);
INSERT INTO PET (PetName, PetType, PetBreed, PetDOB, OwnerID) VALUES('Cedro', 'Cat', 'Unknown', '2012-06-06', 2);
INSERT INTO PET(PetName, PetType, PetBreed, OwnerID)
	VALUES('Wooley', 'Cat', 'Unknown', 2);
INSERT INTO PET(PetName, PetType, PetBreed, PetDOB, OwnerID)  VALUES('Buster', 'Dog', 'Border Collie', '2011-12-11', 4);


/*****   PET_3 DATA   ***********************************************************/

INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('King', 'Dog', 'Std. Poodle', '2014-02-27', 25.5, 1);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('Teddy', 'Cat', 'Cashmere', '2015-02-01', 10.5, 2);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('Fido', 'Dog', 'Std. Poodle', '2013-07-17', 28.5, 1);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('AJ', 'Dog', 'Collie Mix', '2014-05-05', 20.0, 3);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('Cedro', 'Cat', 'Unknown', '2012-06-06', 9.5, 2);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetWeight, OwnerID)
	VALUES ('Wooley', 'Cat', 'Unknown', 9.5, 2);
INSERT INTO PET_3 (PetName, PetType, PetBreed, PetDOB, PetWeight, OwnerID) VALUES ('Buster', 'Dog', 'Border Collie', '2011-12-11', 25.0, 4);


/****************************************************************************************/

