Create CUSTOMERS Table

CREATE TABLE CUSTOMERS(
CUSTOMERID NUMBER(12),FIRSTNAME VARCHAR2(30) NOT NULL,

LASTNAME VARCHAR2(30) NOT NULL,

DATEOFBIRTH DATE NOT NULL,

GENDER CHAR NOT NULL,

NATIONALITY CHAR(2) NOT NULL,

RESIDENCYSTATUS CHAR NOT NULL,

ID_NUMBER NUMBER(20) NOT NULL,

REGISTRATIONDATE DATE NOT NULL,

VERIFICATIONSTATUS CHAR NOT NULL);

Questions