Class Notes (1,100,000)
CA (650,000)
UW (20,000)
CS (1,000)
CS348 (20)
Lecture

Project Phase 1 Solution - Winter 2010 Winter 2010


Department
Computer Science
Course Code
CS348
Professor
Ihab Ilyas

This preview shows half of the first page. to view the full 1 pages of the document.
CS348: Introduction to Database Systems
(Winter 2010)
Sample Solution for Project Phase 1
Unrepresented constraints:There exist only four sections in total. At most 20 players per instrument per orchestra. Most persons play only 1
instrument. Order values are distinct, sequential numbers from 1. (Names of sections, names of instruments are not represented.)
Person
Program
pid
pname
(3,8)
Plays
PlaysSolo
OnRoster
OrchSect
oname
Section
(4,4)
(1,N)
sname
SectInst
type
venue
date
title
day
month
year
loc
PrincCond
GuestCond
order
(1,N)
(1,1)
Composes
Performs
cid
(1,1)
You're Reading a Preview

Unlock to view full version