-- This script creates the tables.  Note that 
-- if you are not using Oracle you will need to
-- replace "Varchar2" with "Varchar"
-- Also, please verify that your RDBMS supports 
-- declarative referential integrity.
--
CREATE TABLE Owner (
       Owner_Id Number(10,0) NOT NULL,
       Name Varchar2(65) NOT NULL,
       StreetAddress Varchar2(65) NOT NULL,
       City Varchar2(65) NOT NULL,
       StateCode CHAR(2) NOT NULL,
       Phone Varchar2(20) NOT NULL,
       PRIMARY KEY (Owner_Id)
);

CREATE TABLE PetType (
       PetType_Id Number(4,0) NOT NULL,
       Description Varchar2(65) NOT NULL,
       PRIMARY KEY (PetType_Id)
);

CREATE TABLE Pet (
       Pet_Id Number(10,0) NOT NULL,
       PetType_Id Number(4,0) NOT NULL,
       Owner_Id Number(10,0) NULL,
       Name Varchar2(65) NOT NULL,
       Birthdate DATE NOT NULL,
       DeathDate DATE NULL,
       PRIMARY KEY (Pet_Id), 
       FOREIGN KEY (PetType_Id)
           REFERENCES PetType, 
       FOREIGN KEY (Owner_Id)
           REFERENCES Owner
);