Posted on: 3/31/2014 7:58:54 PM | Views : 382

Hello I have a different version of the code with the same intent: Something is still wrong. Any suggestions? Thanks. Jonathon
CREATE TABLE CHILDREN ( CHILD_ID INT NOT NULL PRIMARY KEY, FNAME VARCHAR(24) NOT NULL, LNAME VARCHAR(24) NOT NULL, PHONE CHAR(12) NOT NULL, CHECK (PHONE LIKE '(0[0-9][0-9])[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'), CHILDGRADE VARCHAR(8) NOT NULL, CHECK (CHILDGRADE LIKE 'BEGINNER' OR 'NOVICE' OR 'SKILLED' OR 'EXPERT')) CREATE TABLE INSTRUCTORS ( STAFF_NO INT NOT NULL PRIMARY KEY, FNAME VARCHAR(24) NOT NULL, LNAME VARCHAR(24) NOT NULL, PHONE CHAR(13) NOT NULL, CHECK (PHONE LIKE '(0[0-9][0-9])[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]')) CREATE TABLE LESSONS ( LESSON_ID INT NOT NULL PRIMARY KEY, DAY DATE NOT NULL, TIME TIME NOT NULL,  LESSONGRADE VARCHAR(8) NOT NULL, CHECK (LESSONGRADE LIKE 'BEGINNER' OR 'NOVICE' OR 'SKI ...

Go to the complete details ...