CREATE TABLE pet (
  species     CHAR(1),       /* D=dog, C=cat, B=bird, F=fish */
  name         VARCHAR(25),
  owner        VARCHAR(25),
  dob         DATE,
  PRIMARY KEY(name)    /* the unique identifier for each pet */
);

INSERT INTO pet VALUES ('C', 'Fluffy', 'Jane', '2014-03-12'),
       ('D', 'Rover', 'Susan', '2019-11-13'),
       ('B', 'Polly', 'John', '2018-05-18'),
       ('D', 'Fido', 'Robert', '2017-09-15');