Final2004S - 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 CSC340S - Information Systems Analysis and Design Spring 2004 John Mylopoulos April-May Examination Calculators are the only 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. ____________/15 3. ____________/20 4. ____________/15 5. ____________/10 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 1. [Entity-Relationship Diagrams; 15 marks] A telephone company decides to computerize its customer information system that keeps track of customers, their addresses, telephone numbers and rented telephone devices, also their monthly bills. Draw an entity-relationship diagram for the customer database, assuming the following: There are individual and corporate customers. Each individual customer has at least one and up to three residential addresses, but a residential address can have up to ten customers. For each customer, a residential address has one to two associated telephone numbers and zero to five rented telephone devices (some customers own the telephone devices they use at home). A bill is sent each month of the year for each customer address and includes charges for all telephone numbers and all rented devices at that address. Corporate customers have one to ten commercial addresses, one to one thousand telephone numbers, and one to one thousand rented devices. Commercial addresses can have any number of (corporate) customers. All customers have a name and a unique account number. Telephone devices are identified by their serial number. Addresses are identified by their street number, street name, and city. Make sure that your solution is an Entity-Relationship diagram, NOT a UML class diagram!
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.

This note was uploaded on 01/05/2012 for the course COMMERCE 398 taught by Professor Dale during the Spring '11 term at The University of British Columbia.

Page1 / 12

Final2004S - 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