Course Offering StudentiD : number (10) InstructorID : number (10) Instructor Student ID : number (10) Name : varchar2 (255) Program : varchar2 (255) CourselD : number (10) Time : date SectionNo :...

herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints

Extracted text: Course Offering StudentiD : number (10) InstructorID : number (10) Instructor Student ID : number (10) Name : varchar2 (255) Program : varchar2 (255) CourselD : number (10) Time : date SectionNo : number (10) Roomld : number (10) Year : number (10) Semester : char (2) ID : number (10) + Name : varchar2 (255) Department : varchar2 (255) Title : varchar2 (255) Course ID : number (10) Syllabus : varchar2 (255) Title : varchar2 (255) Credits : varchar2 (255) Prerequisite : varchar2 (255)