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

Project Phase 1 - Winter 2010 Winter 2010 - Solution available in another note

Computer Science
Course Code
Ihab Ilyas

This preview shows half of the first page. to view the full 1 pages of the document.
CS 348 Winter 2010
Project Phase 1 - Data Model
1 Overview
At the end of the second phase of this project, you and your project team are to produce an online software
system that will enable a user to access and update information about symphony orchestras. Your system must
be able to represent the following data:
Every symphony orchestra includes four sections: woodwinds (e.g., flutes, clarinets, oboes, bassoons),
brass (trumpets, trombones, horns, tuba), percussion (drums, timpani, xylophone, triangle, chimes,
etc.), and strings (first violins, second violins, violas, cellos, double basses, and harp).
An orchestra’s roster of players can include between one and 20 players for each type of instrument
(e.g., there is usually at most one harpist, but there are often three or four horn players and as many as
16 or 18 first violinists.) Even though most players play one instrument only, some may play several
Every orchestra has one principal conductor.
An orchestra typically plays several concerts each year, each concert consisting of a sequence of three
to eight pieces of music. Each piece of music has a title and a composer. A concert might be repeated
on several dates in various locations.
Some concerts have a guest conductor (for the whole concert), and some pieces of music require a
guest soloist (for that single piece only).
Here are some facts you should be able to support in your database:
John Helmers is a cellist for the KW Orchestra, and Edwin Outwater is the principal conductor.
On September 24 and September 26, 2009, the second piece played by the Toronto Symphony
Orchestra was Brahms’ Violin Concerto in D Major, Op. 77, with Joshua Bell as guest violin soloist
for that piece.
The Alabama Symphony Orchestra includes 10 first violinists and 6 second violinists.
Using your system, a user will, for example, be able to
Print a list of the players in the woodwind section of the Windsor Symphony Orchestra, giving each
player’s name and the instrument played (see, for example, this complete list of players).
Print a program for the St. Louis Symphony Orchestra concert on February 5, 2010, giving the name
of the conductor, the pieces played (in order), and the name of a guest soloist for any piece that has
one (see the example under Programme for a different orchestra and concert).
Find all the 2009 concerts that include a piece composed by Bach, giving the name of the orchestra,
the date(s) of the concert, and the name of the piece performed.
Add David Larson as a trumpet player on the roster of the New Jersey Symphony Orchestra.
Record that Thierry Fischer is the new musical director of the Utah Symphony, replacing Keith
Lockhart in that role.
2 Phase 1 Assignment
In this first phase, you are to work individually to specify an ER diagram for this application. Your diagram
should capture as much of the data description given above as possible. Include additional comments that
address any data consistency requirements omitted by your ER diagram.
You are encouraged to employ the notation presented in class. If you use an alternative ER notation, you must
cite a textbook or published article describing that notation.
Each student will submit his or her own individual design. (Note that project groups will be formed for the
second phase of the project that will be due later on in the term.)
You are to submit a hard copy of your solution by 5:00pm Tuesday January 26th, 2010, in the CS348
Assignment Drop Box, third floor MC.
You're Reading a Preview

Unlock to view full version