Pet Name Species Age Microchip Owner Visit Date Proc Procedure Shiloh Dog 3 Yes
ID: 3751419 • Letter: P
Question
Pet Name Species Age Microchip Owner Visit Date Proc Procedure Shiloh Dog 3 Yes Joan Burger 2/15/2017 EXAM 01-Annual Checkup VACC 05-Rabies Vaccination 7/18/2017 TREAT 08-Laceration VACC 11- Tetanus Shot 7/25/2017 EXAM 03-Follow-up Exam Silver Cat 8 No Grace Chen 06/01/2017 EXAM 01-Annual Checkup VACC 05-Rabies Vaccination Gromit Dog 7 Ye Pavan Singh 03/03/2017 TREAT 10-Gl Distress 08/01/2017 EXAM 01-Annual Checkup TEST VACC 18-Heart Worm Test 05-Rabies Vaccination Pete Bird 13 No Sue Goldman 01/15/2017 TREAT15 Limb Create a SQL script that inserts the records from the report shown above into the database tables that you created in Question 1. Then, write a SELECT statement whose results replicate the data in the report. Sample output shown below Please paste the SQL code for your SELECT statement into your homework submission and upload as a .pdf or .doc file Result Grid | Fiter Rows Export: E Wrap Cell Content: petName species age microchip owner visitDate type procedureID description Joan Buroer 2017-02-15EXAM1 Joan Buroer 2017-02-15 VACC 5 Joan Buroer 2017-07-18TREAT8 Joan Buroer 2017-07-18 VACC 11 Joan Buroer 2017-07-25 EXAM 3 Grace Chen 201706-01 EXAM 1 Grace Chen 2017-06-01 VACC5 Pavan Sinah 2017-03-03 TREAT10 Pavan Sinah 2017-08-01 EXAM 1 Pavan Sinah 201708-01 VACC 5 Pavan Sinah 2017-08-01 TEST 18 Sue Goldman 2017-01-15 TREAT 15 Annual Checkuo Rabies Vaccination Laceration Tetanus Shot Follow up Exam Annual Checkuo Rabies Vaccination GI Distress Annual Checkuo Rabies Vaccination Heart Worm Test Intured Limb Shoh Doa oh Doo Shiloh Doa 3 Shiloh Doa 3 Yes Cat Cat No No GromitD7 GromitDoa Gromit D 7 GromitDoa Pete 7 Yes Bird 13 NoExplanation / Answer
CREATE TABLE Database (
petName varchar(255),
Species varchar(255)
Age int,
Microchip varchar(255),
Owner varchar(255),
visit date date,
Proc type varchar(255),
Procedureid int,
Description varchar(255)
);
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Shiloh', 'Doa', 3, 'yes', 'JoanBuroer','2017-02-15','EXAM',1,'Annual Checkup');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Shiloh', 'Doa', 3, 'yes', 'JoanBuroer','2017-02-15','VACC',5,'Rabies Vaccination');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Shiloh', 'Doa', 3, 'yes', 'JoanBuroer','2017-02-18','TREAT',8,'lACERATION');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Shiloh', 'Doa', 3, 'yes', 'JoanBuroer','2017-02-18','VACC',11,'Tetanus Shot');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Shiloh', 'Doa', 3, 'yes', 'JoanBuroer','2017-02-18','EXAM',3,'Follow up Exam');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Silver', 'Cat', 8, 'No', 'Grace chen','2017-06-01','EXAM',1,'Annual Checkup');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Silver', 'Cat', 8, 'No', 'Grace chen','2017-06-01','VACC',5,'Rabies Vaccination');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Gromit', 'Doa', 7, 'yes', 'pavan singh','2017-08-01','TREAT',10,'GI Distress');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Gromit', 'Doa', 7, 'yes', 'pavan singh','2017-08-01','EXAM',1,'Annual Checkup');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Gromit', 'Doa', 7, 'yes', 'pavan singh','2017-08-01','VACC',5,'Rabies Vaccination');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Gromit', 'Doa', 7, 'yes', 'pavan singh','2017-08-01','TEST',15,'Heart Worm Test');
INSERT INTO Database (petName,Species,Age,Microchip,Owner,visitdate ,Proctype,Procedureid,Description)
VALUES ('Pete', 'Bird', 13, 'No', 'Sue Goldman','2017-01-15','TREAT',15,'Injured Limb');
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.