{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}


ISOM221+Lecture+8+-+Data+Modeling+I+Solutions - Exercise#1...

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

View Full Document Right Arrow Icon
ISOM221 Information Systems Analysis and Design Lecture 8: Data Modeling I (Solutions of In-Class Exercises) 1 Exercise #1 Draw the cardinalities for the following relationships Student Course takes is taken by Scenario: Course taking and offering in the university Department Course offers is offered by Professor Course teaches is taught by 2 Customer Book buys is bought by reviews Scenario: Book sales on Amazon.com Customer Book is reviewed by Publisher Book publishes is published by 3 Exercise #2 Scenario: A wealthy businessman owns a large number of paintings that he loans to museums all over the world. He wants to set up a system that records what he loans to whom so that he doesn’t lose track of his investments. He would like to keep information about the paintings that he owns as well as the artists who painted them. He also wants to track the various museums that reserve his art, along with the actual reservations.
Background image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '09
  • Entity-relationship model, Artist Painting Reservation Museum, Artist Painting Reservation, Reservation Museum, RESERVATION *res_ReservationID res_ReservationDateOut

{[ snackBarMessage ]}