Homework 3

Homework 3 - CSC4402 Homework 3 I. Due Wednesday September...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC4402 Homework 3 Due Wednesday September 30, 2009 I. Following is the logical schema for the Professor-Student database, describing professors, students, and the relationship "serving-on-the committee" between the professors and students. The primary keyfields are underlined : Prof: ( Pnum Pname City Dept) for Professors St: ( Snum Sname City Dept Degree Major_Pnum) for Students Com: ( Snum Pnum Hours) for committees In the above database, the data type for the Hours attribute in table C is SMALLINT ,and all other attributes have data type CHAR. Note that the attribute "Major_Pnum" denotes the Pnum for the stu- dent’smajor professor and thus it is a foreign key intable St. Assume that every professor serves on one or more committees and every student has a committee of one or more professors. The student’s major professor must be in his/her committee. Write CREATE TABLE statements to create the database for the above scheme (pay attention to the
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/25/2010 for the course CSC 4402 taught by Professor Staff during the Fall '08 term at LSU.

Ask a homework question - tutors are online