CREATE TABLE DoctorList (
 FirstName CHAR(10),
 LastName CHAR(15),
 IDNo NUMERIC(8),
 DeptNo NUMERIC(8)
 );

INSERT INTO DoctorList (FirstName, LastName, IDNo, DeptNo) VALUES ('Sandy', 'Wisienhowtz', 11111111, '00000001');
INSERT INTO DoctorList (FirstName, LastName, IDNo, DeptNo) VALUES ('Taylor', 'Giggins', 11111112, '00000021');
INSERT INTO DoctorList (FirstName, LastName, IDNo, DeptNo) VALUES ('Joe', 'Pepper', 11111111, '00000321');

CREATE TABLE Finance (
 BillingAddress VARCHAR(20),
 InsuranceCompany VARCHAR(30),
 PolicyNo NUMERIC(8),
 IDNo NUMERIC(8)
 );

INSERT INTO Finance (BillingAddress, InsuranceCompany, PolicyNo, IDNo) VALUES ('1876 Wall Street','State Farm', 16492648,00000001);
INSERT INTO Finance (BillingAddress, InsuranceCompany, PolicyNo, IDNo) VALUES ('3145 Springsting Ave','Geico', 43492444,00000002);
INSERT INTO Finance (BillingAddress, InsuranceCompany, PolicyNo, IDNo) VALUES ('48 Calamaster Lane','Allstate', 16492648,00000001);