CREATE TABLE people $($person idINTEGER NOT NULLPRIMARY KEY, given nameVARCHAR$2(100)$ NOT NULL,family name VARCHAR$2(100)$NOT NULL,titleVARCHAR$2(20),$birth$\_$date DATECREATE TABLEpatientspatient idINTEGER NOTNULL PRIMARY KEY REFERENCES people $($person$\_$id$),$last admission date DATECREATE TABLE staff $($staff idINTEGER NOT NULL PRIMARYKEY REFERENCES people $($person id$),$ hired date DATEINSERT INTO peopleVALUES $(1,$'Dave', 'Badger', $\text{'}$Mr$\text{'},$date $\text{'}1960-05-01\text{'})$INSERT INTO people $($personid$,$givenname,family name, title$)$VALUES $(2,$'Simon', 'Fox', $\text{'}$Mr$\text{'})$