Assignment 2

Apply the systematic approach to build a skeletal ER model for the following situation. Discuss which steps were difficult to apply.

  1. "A student can take many courses but can register in only one section of a course. Each course section is assigned a classroom where it meets throughout the semester. A faculty member teaches several courses each semester." -- Teams 1,2,3
  2. "Members rent videos from XYZ video by handing to the sales clerk their membership card and the set of videos. The sales clerk scans the membership card and a membership screen opens-up indicating any past due charges. The sales clerk scans each video to generate a rental record for each video and the final sales receipt." -- Teams 4,5,6
  3. "Members of XYZ video return borrowed videos by dropping the videos in a return bin. The returned videos are processed by a sales clerk. The processing involves (1) checking that the video tape is rewound, (2) entering any late return charge, and (3) updating the video inventory database." -- Teams 7,8,9
  4. "Customers use the ATM machine to check account balances, shift money between customer accounts, withdraw up to 300 dollars per day, and deposit checks." -- Teams 10,11,12