CREATE TABLE PUPIL ( PupilID CHAR(9) PRIMARY KEY CHECK (PupilID LIKE 'P_____'), PupilName NVARCHAR2(30) NOT NULL, ClassID CHAR(5) NOT NULL, DateOfBirth DATE NOT NULL, Gender NVARCHAR2(4) NOT NULL, ...