Homework #1 - o SSN = primary key Graduate students can...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Scott Sommer Homework #1 IST 210 2/19/07
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Scott Sommer Homework #1 IST 210 2/19/07 Graduate students are identified by SSN, name, age and degree program o ssn = primary key Graduate students can work on many projects Projects are identified by project number, start date, end date, budget and sponsor name o project number = primary key Projects are managed by one professor but many professors can participate in the project Professors are identified by SSN, name, age, rank and research specialty
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o SSN = primary key Graduate students can only have one major in one department Departments are identified by department number, department name, and main office o department number = primary key Each department must have only one chairperson, and the chairperson must be a professor A professors time percentage teaching in each department must be recorded...
View Full Document

This note was uploaded on 05/04/2008 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Spring '08 term at Pennsylvania State University, University Park.

Page1 / 2

Homework #1 - o SSN = primary key Graduate students can...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online