CSC4402 Homework 3Due Wednesday September 30, 2009I. Following is the logical schema for theProfessor-Studentdatabase, describing professors, students,and the relationship "serving-on-the committee" between the professors and students.The primarykey fields areunderlined:Prof: (PnumPname City Dept)for ProfessorsSt: (SnumSname City Dept Degree Major_Pnum)for StudentsCom: (SnumPnumHours) for committeesIn the above database, the data type for theHoursattribute in table C is SMALLINT, and all otherattributes have data type CHAR.Note that the attribute "Major_Pnum" denotes the Pnum for the stu-dent’s major professor and thus it is a foreign key in table St.Assume that every professor serves onone or more committees and every student has a committee of one or more professors.The student’smajor professor must be in his/her committee.Write CREATE TABLE statements to create the database for the above scheme (pay attention to theprimary key and foreign key clauses).
This is the end of the preview.
access the rest of the document.
professors, Major Professor, City Dept Degree, Pname City Dept