ISOM221+Lecture+8+-+Data+Modeling+I+Solutions

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 taken by Scenario: Course taking and offering in the university is taken by Department Course offers is offered by Professor Course teaches is taught by 2 Customer Book buys is bought by Scenario: Book sales on Amazon.com Customer Book reviews 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 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 12/22/2010 for the course ISOM ISOM221 taught by Professor Sheunhhee during the Spring '09 term at HKUST.

Page1 / 2

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

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