Data Modeling with the Entity-Relationship Model - Database Processing: Fundamentals, Design, and Implementation - page 225

West Side Story
Based on a conception of Jerome Robbins

Jet Song
(Riff, Action, Baby John, A-rab, Chorus)
Something's Coming
(Tony)
Maria
(Tony)
Tonight
(Maria, Tony)
America
(Anita, Rosalia, Chorus)
Cool
(Riff, Chorus)
One Hand, One Heart
(Tony, Maria)
Tonight (Ensemble)
(Entire Cast)
I Feel Pretty
(Maria, Chorus)
Somewhere
(A Girl)
Gee Officer Krupke
(Action, Snowboy, Diesel, A-rab, Baby John, Chorus)
A Boy Like That
(Anita, Maria)
I Have a Love
(Maria, Anita)
Taunting Scene
(Orchestra)
Finale
(Maria, Tony)

[3'13]

1

[2'33]

2

Book by ARTHUR LAURENTS
Music by LEONARD BERNSTEIN
Lyrics by STEPHEN SONDHEIM

[2'56]

3

[5'27]

4

Entire Original Production Directed
and Choreographed by JEROME ROBBINS

[4'47]

5

[4'37]

6

Originally produced on Broadway by Robert E. Griffith and Harold S. Prince
by arrangement with Roger L. Stevens
Orchestration by Leonard Bernstein with Sid Ramin and Irwin Kostal

[5'38]

7

[3'40]

HIGHLIGHTS FROM THE COMPLETE RECORDING

8

[3'22]

9

Maria
Tony
Anita
Riff
and MARILYN HORNE singing “Somewhere”

. . . . . . . . . . . . . . . . .KIRI TE KANAWA
. . . . . . . . . . . . . . . . JOSE CARRERAS
. . . . . . . . . . . . . TATIANA TROYANOS
. . . . . . . . . . . . . . . . . . . . KURT OLLMAN

[2'34]

10

[4'18]

11

[2'05]

12

[3'30]

Rosalia
Consuela
Fancisca
Action

. . . . . . . . . . Louise Edeiken
. . . . . . . . . Stella Zambalis
. . . . . . . . . Angelina Reaux
. . . . . . . . . . David Livingston
Bernardo

. . . . . . . . . . . . . Marty Nelson
. . . . . . Stephen Bogardus
. . . . . . . . . . . . . . . Peter Thom
. . . . . . . . . . . . .Todd Lester
. . . .Richard Harrell

Diesel
Baby John
A-rab
Snowboy

13

[1'21]

14

[2'40]

15

Figure 5-60
CD Cover

Combine the models you developed in your answers to B and C. Create new enti-
ties if necessary, but strive to keep your model as simple as possible. Specify iden-
tifiers and attributes of new entities, name new relationships, and indicate their
cardinalities.

D.

5.63 Consider the data model in Figure 5-43. How should this model be altered if the users
want to keep track of how many of each part are used? Suppose, for example, that the
wheel assembly requires four washers and the handle assembly requires just one, and
the database must store these quantities. (Hint: Adding Quantity to this N:M relation-
ship is analogous to adding Price to the N:M relationship in Figure 5-22.)

5.64 The data model in Figure 5-52 uses the attribute Room in COLLEGE and DEPARTMENT,
but uses OfficeNumber in PROFESSOR. These attributes have the same kind of data,
even though they have different names. Examine Figure 5-46 and explain how this situ-
ation came to be. Do you think having different names for the same attribute types is
rare? Do you think it is a problem? Why or why not?

Case Questions

Washington State Patrol Case Questions
Consider the Washington State Patrol traffic citation shown in Figure 5-61. The rounded cor-
ners on this form provide graphical hints about the boundaries of the entities represented.

a. Draw an E-R data model based on the traffic citation form. Use five entitiesn, and use
the data items on the form to specify identifiers and attributes for those entities. Use
the IE Crow's Foot E-R model for your diagram