Create Table Person (
    personID Char(8) NOT NULL,
    firstName Varchar(30) NOT NULL,
    lastName Varchar(20) NOT NULL,
    streetNo Varchar(10) NOT NULL,
    streetName Varchar(20) NOT NULL,
    city Varchar(30) NOT NULL,
    state Varchar(4) NOT NULL,
    postcode Char(4) NOT NULL,
    dateOfBirth Date NOT NULL,
    email Varchar(50) NOT NULL,
    sex Char(1) NOT NULL,
    PRIMARY KEY(personID),
    CONSTRAINT sex_value CHECK (sex IN ('M','F','U')),
    CONSTRAINT email_value CHECK (email LIKE '%___@___%')
);

Insert Into Person Values ('02188873','Rhona','Sierra','31','Argust St','Middle Park','QLD','4207','2014-12-23','ramollin@aol.com','F');
Insert Into Person Values ('26924655','Ainslee','Paretski','135','Universal Dr','Oxenford','QLD','4211','2002-03-08','flaviog@msn.com','F');
Insert Into Person Values ('63173932','Domeniga','Watkins','10-14','Summerville Rd','Southport','QLD','4210','1972-11-21','mahbub@optonline.net','F');
Insert Into Person Values ('12692995','Ashely','Grey','60','Deaton Ave','Perisher Valley','NSW','4127','1998-04-04','alfred@me.com','F');
Insert Into Person Values ('29008529','Agathe','Michaelson','10','Gilbert St','Dubbo','NSW','2830','2012-07-25','rnewman@live.com','F');
Insert Into Person Values ('45610045','Teena','Popolopodus','13','Spit Rd','Mosman','NSW','2088','1996-10-16','ingolfke@icloud.com','F');
Insert Into Person Values ('94679772','Charmain','Zapzeda','61','Brodie St','Holland Park West','QLD','4121','1979-10-09','kiddailey@hotmail.com','F');
Insert Into Person Values ('55535777','Gleda','Jones','30','Arthur St','Sorell','TAS','7172','2017-07-31','jesse@me.com','F');
Insert Into Person Values ('15476925','Mariel','Thompson','365','Esplanade Ave','Scarness','QLD','4655','2004-12-12','dprice@me.com','F');
Insert Into Person Values ('86905538','Mariellen','Ryder','15','Kumnick St','Lobethal','SA','5241','2008-06-27','gemmell@mac.com','F');
Insert Into Person Values ('69967824','Patricia','DeWitt','10','Pinxton Crt','Carine','WA','6020','1967-08-08','gavollink@me.com','F');
Insert Into Person Values ('09405207','Timmie','Perkins','23','Timaru Cres','Eight Mile Plains','QLD','4113','1975-06-14','kingjoshi@outlook.com','F');
Insert Into Person Values ('42353947','Rhianon','Moman','2','Soderlund Drv','Doncaster','VIC','3108','1992-05-07','tamas@optonline.net','F');
Insert Into Person Values ('22447489','Tomi','Johnson','17','Adrian St','Margate','QLD','4019','1987-09-14','jaxweb@icloud.com','F');
Insert Into Person Values ('81987208','Micaela','James','746','Timboon-Colac Rd','Jancourt East','VIC','3266','1999-03-23','overbom@icloud.com','F');
Insert Into Person Values ('74123192','Meg','Carter','55','Cabarita Rd','Avalon','NSW','2107','1957-02-28','naoya@outlook.com','F');
Insert Into Person Values ('62309196','Julianne','Miller','9','Geographe Way','Withers','WA','6230','2000-01-21','chickibabs@hotmail.com','F');
Insert Into Person Values ('59690847','Birgit','Hankey','15','Ocean Ave','Surf Beach','NSW','2536','1985-06-19','bigbeard@live.com','F');

commit;