Final2001S - csc340 Information Systems Analysis and Design...

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

View Full Document Right Arrow Icon
csc340 Information Systems Analysis and Design page 1/12 University of Toronto Faculty of Arts and Science Department of Computer Science Faculty of Arts and Science at Erindale CSC340S - Information Systems Analysis and Design Spring 2001 John Mylopoulos Arnold Rosenbloom April-May Examination No Aids Allowed Duration: 2 hours Make sure that your examination booklet has 12 pages (including this one). Write your answers in the space provided. This examination counts for 35% of your final mark. Name: (Please underline your last name) Student Number: Question Marks 1. ____________ /15 2. 3. 4. 5. 6. /25 Total /100
Background image of page 1

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

View Full DocumentRight Arrow Icon
csc340 Information Systems Analysis and Design page 2/12 Blockbuster Video managers want to improve the way they maintain information about their customers. In particular, they want to create an information system (“VideoSystem”) able to perform the following functions: Given the id of a customer, find his/her name, address and phone number; Given the id of a customer, determine if he/she has any outstanding videos (rented but not returned); Find out how many rental items are currently rented; this operation is performed very frequently! Return a rental item to the store; when a rental item is returned, it is inspected and its status is updated accordingly; Retrieve information about a particular rental item, given its id (barcode); Given a customer id and barcode, find the customer with the given id, find the rental item with the given barcode; if both exist (and the rental item is rentable) then rent the item to the customer; List all the rental items currently rented/owned by a specific customer; For a specific rental item, (if it is currently rented/owned) identify the customer who is renting it; In general, the VideoSystem will need to keep track of a collection of customers and a collection of rental items, as well as relationships between them. Here are additional details on how Blockbuster Video conducts its business: A customer can rent (possibly many) items. There are two types of rental items: DVDs and video cassettes (“videos”). Customers rent either of these two types of rental items. A rental item has a barcode and a movie name. The status of a rental item is either rented, available, expired (if it has been rented a maximum number of times), damaged or sold (if it was sold to a customer). If its rented, a rental items due date specifies the date that the item should be returned. Each video cassette has a lifespan (a maximum number of times that it can be rented). A newly created video cassette has a lifespan of 50 rentals. DVDs have unlimited lifespans. A non-damaged, available rental item can either be rented or sold to a customer. An expired rental item can only be sold. You can ask for the status of a rental item. All rental items can be rented (by a customer) and returned. When an item is returned, the clerk who handles the transaction labels it “OK” or "damaged" depending on its status. Because of the differences between DVDs and video cassettes, some of these operations (rent, return etc.) have DVD-
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Final2001S - csc340 Information Systems Analysis and Design...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online