Database work

CREATE table MEMBER (Member_ID int constraint pk_member_id PRIMARY KEY, Name varchar2(50) constraint nm_name NOT NULL, Phone_Num varchar2(12), Birthday date constraint nm_birthday NOT NULL, Gender char (1) constraint nn_gender NOT NULL, constraint chk_gender check (Gender in ('M','F')), Lives_In int); CREATE table PARENT (Mother_ID int constraint nm_mother NOT NULL, Father_ID int constraint nm_father NOT NULL, Child_ID int constraint nm_child NOT NULL); CREATE table PET (Pet_ID int constraint pk_pet_id PRIMARY KEY, PName varchar2(50) constraint pt_name NOT NULL, Type varchar2(50), Fur_Type Varchar2 (30), Year_Born int, House_In int); CREATE table HOUSEHOLD (House_ID int constraint pk_house_id PRIMARY KEY, Address_num char(10), Street varchar2(50), City varchar2(50), State char(2), zip int); INSERT ALL INTO MEMBER values(1, 'Nelson Freeman', '614-601-5147', '1-Jun-1922', 'M', 1) INTO MEMBER values(16, 'Mary Mader', '614-624-6628', '12-Jan-1918', 'F', 1) INTO MEMBER values(3, 'William Mack', '330-949-2522', '12-Aug-1923', 'M', 2) INTO MEMBER values(4, 'Mary Burbank', '330-512-9725', '15-Feb-1922', 'F', 2) INTO MEMBER values(7, 'Enoch Whitman', '216-848-9837', '16-Dec-1918', 'M', 3) INTO MEMBER values(8, 'Rebecca Gardner', '', '25-May-1923', 'F', 3) INTO MEMBER values(2, 'Samuel Hunter', '513-395-7045', '26-Aug-1922', 'M', 4) INTO MEMBER values(10, 'Lucerna Harlow', '513-786-2650', '3-Sep-1918', 'F', 4) INTO MEMBER values(11, 'David Freeman', '513-545-8812', '28-Nov-1948', 'M', 5) INTO MEMBER values(12, 'Desiah Mack', '330-802-5776', '14-Oct-1947', 'F', 5) INTO MEMBER values(13, 'Nathanial Whitman', '216-596-6123', '17-Jun-1943', 'M', 3) INTO MEMBER values(9, 'Jane Hunter', '216-596-6321', '29-Jan-1948', 'F', 3) INTO MEMBER values(14, 'Joseph Freeman', '312-893-2254', '27-Dec-1972', 'M', 6) INTO MEMBER values(15, 'Abigale Whitman', '773-254-8919', '3-Feb-1968', 'F', 6) INTO MEMBER values(5, 'Samuel Freeman', '', '15-Mar-1998', 'M', 6) INTO MEMBER values(6, 'Jessica Freeman', '614-719-9213', '22-Jul-1952', 'F', 1) INTO MEMBER values(17, 'Alex Whitman', '216-596-6240', '23-Jan-1948', 'F', 3) SELECT * FROM DUAL; COMMIT; INSERT ALL INTO PARENT values(16,2,11) INTO PARENT values(16,2,6) INTO PARENT values(4,3,12) INTO PARENT values(8,7,12) INTO PARENT values(8,7,17) INTO PARENT values(7,8,9) INTO PARENT values(11,12,14) INTO PARENT values(9,13,15) INTO PARENT values(15,14,5) SELECT * FROM DUAL; COMMIT; INSERT ALL INTO PET values(1,'Jack','Dog', 'Long_Hair',2008,1) INTO PET values(2,'Crookshanks','Cat','Long_Hair',2015,1) INTO PET values(3,'Whiskers','Dog','Short_Hair',2010,2) INTO PET values(4,'Jingles','Potbelly Pig','Short_Hair',2004,3) INTO PET values(5,'Tweet','Canary','Feather',2018,5) SELECT * FROM DUAL; COMMIT; INSERT ALL INTO HOUSEHOLD values(1,'321', 'High St.','Columbus','OH',43050) INTO HOUSEHOLD values(2,'123', '2nd Ave.','Akron','OH',44223) INTO HOUSEHOLD values(3,'444', 'Main Dr.','Cleveland','OH',44101) INTO HOUSEHOLD values(4,'999', 'Freeland St.','Cincinnati','OH',45220) INTO HOUSEHOLD values(5,'265', 'Iota Ave.','Cincinnati','OH',45220) INTO HOUSEHOLD values(6,'102', 'Michigan Ave.','Chicago','IL',60632) SELECT * FROM DUAL; COMMIT; ALTER table MEMBER add constraint fk_lives_in foreign key (Lives_In) references HOUSEHOLD (House_ID); ALTER table PARENT add constraint fk_mother_id foreign key (Mother_ID) references MEMBER (Member_ID); ALTER table PARENT add constraint fk_father_id foreign key (Father_ID) references MEMBER (Member_ID); ALTER table PARENT add constraint fk_child_id foreign key (Child_ID) references MEMBER (Member_ID); ALTER table PET add constraint fk_house_in foreign key (House_In) references HOUSEHOLD (House_ID);