Due Date: Feb 17, 2000. ABSOLUTELY NO COLLABORATION WITH ANYONE.

Each year The International Conference on Peptides As Neurotransmitters (PAN) is held in a different country. Next year, PAN will be hosted by the Faculty of Medicine at the University of Western Ontario. Delegates to this conference register their name, email address, title (e.g., Professor, Dr., Mr., Ms), age and their gender with organisers along with their payment. Upon receipt of the registration form and payment, they are given a registration number. Many of the delegates have written conference papers to be presented at the conference. A conference paper must have a title and a page length. Some of the papers have been written by more than one delegate though PAN organisers place no limit on the number of papers any one delegate can submit. The conference is organized into 10 half-day Sessions (such as Spinal Cord or SNS). Each paper that is selected for presentation is assigned to a 30-minute slot during a single session, during which the paper is presented by one of the authors. All of the delegates hold a position (e.g., Lecturer, graduate student, Professor, etc.) from universities around the world. The conference organisers require that delegates register the name and country of the university they are from as well as their department when they register for the conference.

For example, Dr. Axon Hillock from the University of Hardknox (California, USA), aged 55, has written a twenty-page paper entitled "Identification of NPY by Immunocytochemistry in Ganglia". She has written this together with Professor Dendrite from Tokyo State University. Dr. Axon Hillock's email is axon@hardknox.edu but Professor Dendrite has not supplied his. Mr. Jus Tinterested from Bondy University (The Beach, Australia) has registered but has not written a paper. His email is info@bondy.edu.au. He shares this email address with Ms Synapse from the same University. She, too, has registered but is not presenting a paper. Professor Dendrite, Dr. Hillock, Mr. Tinterested and Ms Synapse are all senior lecturers in their respective universities.

Draw an Entity-Relation diagram that that clearly indicates all entities, relationships, given attributes, connectivities and cardinalities that will be useful for the development of the application. Identify the primary keys (underline) and foreign keys (circle). Clearly record ALL assumptions you make in drawing your diagram.

Supporting customer maintenance needs is an important part of providing customer service. A large soft drink bottling company wants to provide better maintenance support to its customers who lease over 20,000 soft drink vending machines. In particular, the organization wants to improve machine maintenance, parts-inventory management and management reports. When a customer calls in a problem with a soft drink vending machine (Equipment), this initiates a repair order (Repair). The repair order for the machine is in turn assigned to an individual (Repair Person) in the company.

 The ER diagram for this application follows. Transform this model into relational tables, shown in the following format: BOOKS (BookID, …, CategoryID) Underline Primary key(s), circle foreign keys (indicate whether each can be null) but do not create any additional attributes.