hw1 - Home Work I: S307 (Spring 2010) Due Date: February 4,...

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

View Full Document Right Arrow Icon
1 Home Work I: S307 (Spring 2010) Due Date: February 4, 2010 (Please staple this sheet with your answer sheet.) Name: Question Maximum Points Points Scored Qs 1 15 Qs 2 15 Qs 3 10 Qs 4 10 Total 50 I have neither given nor received unauthorized aid on this deliverable. _________________________________ (sign) Draw an EER diagram for each of the following descriptions below. State any of your assumptions clearly. 1. Design an EER diagram for symphony orchestra: (15 points) CONCERT SEASON: The season during which a series of concerts will be performed. Identifier is opening date. CONCERT: A given performance of one or more compositions. Identifier is concert number. Another important attribute is concert date; each concert typically has more than one concert date. COMPOSITION: Compositions to be performed at each concert. Identifier is composition ID. Other attributes include composition name, composer name, and movement (which, in turn, is composed of movement number and movement name); many, but not all, compositions have multiple movements. CONDUCTOR: Person who will conduct the concert. Attributes include conductor ID (identifier) and conductor name. SOLOIST: An artist who performs a given composition.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/02/2010 for the course BUS-S 307 taught by Professor Vijay during the Spring '10 term at Indiana.

Page1 / 2

hw1 - Home Work I: S307 (Spring 2010) Due Date: February 4,...

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