17 18. CREATE TABLE IF NOT EXISTS Pet( 19 PetID int NOT NULL, 20 PetName varchar(255), 21 Owner ID int, 22 PetType varch

[answerhappygod]

17 18 Create Table If Not Exists Pet 19 Petid Int Not Null 20 Petname Varchar 255 21 Owner Id Int 22 Pettype Varch 1 (70 KiB) Viewed 15 times

17 18. CREATE TABLE IF NOT EXISTS Pet( 19 PetID int NOT NULL, 20 PetName varchar(255), 21 Owner ID int, 22 PetType varchar(255), 23 PetDescription varchar(255), 24 foreign key (OwnerID) references Owner (ID), 25 primary key (PetID) 26 ); 27 28. INSERT INTO `Pet` (`PetID`, `PetName`, `OwnerID`, `Owner Name`, `PetType`, `PetDescription`) VALUES 29 ('001', 'Fluffy', '001', 'Carl', 'Dog', 'White Australian Shepherd'), 30 ('002', 'Lilith','002', 'Lucy', 'Snake', 'Boa Constrictor'), 31 ('003', 'salem', '002', 'Lucy', 'cat', 'Black Cat'), 32 ('004', 'Chica', '003', 'Freddy", "Dog", "Golden Retriever'), 33 ('ees', 'Luna','004', 'Sam", 'cat', 'Tortoiseshell cat'), 34 ('006', 'Ari', 'ees', 'Jaiden', 'Bird", "green-cheeked conure'), ('007', 'Tofu','005', 'Jaiden', 'Bird', 'Crimson-belly Conure') 35 36 ; 37 38 CREATE TABLE IF NOT EXISTS Treatment ( 39 VisitID INT, 40 IDPet varchar(255), 41 VisitDate Date, 42 TreatmentDescription varchar(255), 43 TreatmentCost varchar(255), 44 MedicinePerscribed varchar(255), 45 FOREIGN KEY(IDPet) REFERENCES Pet (PetID), 46 primary key (VisitID) 47 ); 48 49 ● INSERT INTO `Treatment` (`visitID`, `IDPet`, `VisitDate`, `Treatment Description`, `TreatmentCost`, `MedicinePerscribed`) VALUES ('123', 'Fluffy', '01-23-2022', 'Canine Hepatitis vaccine', '$100', 'None'), 50 51 ('125', 'Lilith', '04-17-2022', 'Tick removal', '$50', 'Ampicillin'), Output Action Output # Time Action X 7 05:10:29 CREATE TABLE IF NOT EXISTS Treatment (VisitID INT. Pet varchar(255), Visit Date Date, Treatment Description varchar(255), Treatment Cost varchar(255), Medicine Pe... X 8 05:11:13 CREATE TABLE IF NOT EXISTS Treatment (Visit ID INT, IDPet varchar(255). Visit Date Date, Treatment Description varchar(255). Treatment Cost varchar(255), Medicine... X 9 05:12:21 CREATE TABLE IF NOT EXISTS Treatment (Visit ID INT, IDPet varchar(255), Visit Date Date, Treatment Description varchar(255). TreatmentCost varchar(255), Medicine... X 10 05:13:21 CREATE TABLE IF NOT EXISTS Treatment (Visit ID INT, IDPet varchar(255), Visit Date Date, Treatment Description varchar(255). TreatmentCost varchar(255), Medicine... 11 05:15:37 CREATE TABLE IF NOT EXISTS Treatment (Visit ID INT. IDPet varchar(255). Visit Date Date, Treatment Description varchar(255). TreatmentCost varchar(255), Medicine... < Message Error Code: 3780. Referencing column "Pet" and referenced column "PetID" in foreign key constraint treatment_ibfk_1' are incompatible. Error Code: 3780. Referencing column "IDPet' and referenced column "PetID' in foreign key constraint treatment_ibfk_1' are incompatible. Error Code: 3780. Referencing column "'IDPet' and referenced column "PetID' in foreign key constraint treatment_ibfk_1' are incompatible. Error Code: 3780. Referencing column "IDPet' and referenced column "PetID"' in foreign key constraint treatment_ibfk_1' are incompatible. Error Code: 3780. Referencing column "IDPet' and referenced column "PetID' in foreign key constraint treatment_ibfk_1' are incompatible.