INSERT INTO Patient
 (PatientId, PatName, DOB,
  Breed, OwnerId, Specialty)
 VALUES (12310,'Calvin',1998-12-12,'Python',1110,'Snake')


INSERT INTO Owner
 (Address, Name, OwnerId)
 VALUES ('1002 Mortimter Ave.', 'Rick',1110)

Insert into Specialty
(ConsultChrg,Specialty)
Values (80, 'Snake')

INSERT INTO Appointment
(PatientID, Vet_ID, Reason, Date, BilledAmt)
VALUES (12310, 2220,'Check Up','2011-02-12',2000)

INSTER INTO VET
(vet_Id, VetName, BaseSal, StartDate, Specialty)
VALUES (2220,'Star Bucks', 40000, 2001-02-31,'Snake')


--

INSERT INTO Patient
 (PatientId, PatName, DOB,
  Breed, OwnerId, Specialty)
 VALUES (12307,'Josh',1991-07-07,'Husky',1111,'Dog')


INSERT INTO Owner
 (Address, Name, OwnerId)
 VALUES ('07 Touge Rd.', 'Bosh',1111)

Insert into Specialty
(ConsultChrg,Specialty)
Values (30, 'Dog')

INSERT INTO Appointment
(PatientID, Vet_ID, Reason, Date, BilledAmt)
VALUES (12307, 2221,'Cold','2010-08-11',230)

INSTER INTO VET
(vet_ID, VetName, BaseSal, StartDate, Specialty)
VALUES (2221,'James Bond', 200000, 2005-02-12,'Dog')

--

INSERT INTO Patient
 (PatientId, PatName, DOB,
  Breed, OwnerId, Specialty)
 VALUES (12308,'Jade',1994-02-03,'Poodle',1112,'Dog')


INSERT INTO Owner
 (Address, Name, OwnerId)
 VALUES ('1941 Golden Ave.', 'Lancey',1112)

Insert into Specialty
(ConsultChrg,Specialty)
Values (30, 'Dog')

INSERT INTO Appointment
(PatientID, Vet_ID, Reason, Date, BilledAmt)
VALUES (12308, 2222,'Check up','2011-09-01',300)

INSTER INTO VET
(vet_Id, VetName, BaseSal, StartDate, Specialty)
VALUES ('2222','Moutain Dew', 80000, 2009-01-02,'Dog')



--

INSERT INTO Patient
 (PatientId, PatName, DOB,
  Breed, OwnerId, Specialty)
 VALUES (12309,'Tash',1996-04-04,'Korat',1113,'Cat')


INSERT INTO Owner
 (Address, Name, OwnerId)
 VALUES ('302 Lumsden Ave.', 'Micheal',1113)

Insert into Specialty
(ConsultChrg,Specialty)
Values (90, 'Cat')

INSERT INTO Appointment
(PatientID, Vet_ID, Reason, Date, BilledAmt)
VALUES (12309, 2223','Check Up','2011-02-22',200)

INSTER INTO VET
(vet_Id, VetName, BaseSal, StartDate, Specialty)
VALUES ('23403','Sugar Crisp', 100000, 2005-06-30,'Cat')

--


INSERT INTO Patient
 (PatientId, PatName, DOB,
  Breed, OwnerId, Specialty)
 VALUES (12311,'Dominic',1996-01-11,'Persian',1114,'Cat')


INSERT INTO Owner
 (Address, Name, OwnerId)
 VALUES ('300 Spartian Ave.', 'Apple',1114)

Insert into Specialty
(ConsultChrg,Specialty)
Values (90, 'Cat')

INSERT INTO Appointment
(PatientID, Vet_ID, Reason, Date, BilledAmt)
VALUES (12311, 2224,'Check up','2011-04-08',300)

INSTER INTO VET
(vet_Id, VetName, BaseSal, StartDate, Specialty)
VALUES (2224,'Mike Hunt', 65000, 2003-12-23,'Cat')



--