internal-exam - UNIVERSITY OF LONDON Goldsmiths College BSc...

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

View Full Document Right Arrow Icon
UNIVERSITY OF LONDON Goldsmiths College BSc Examination 2001 COMPUTING AND INFORMATION SYSTEMS IS52003A (CIS209) Database Systems Internal Duration : 3 hours This paper is divided into three parts: Part A, B and C. All parts are compulsory . Each part consists of problems. Within each part, you are required to attempt one problem only . The marking scheme has been made available for you. Part A carries 40 marks. Part B carries 30 marks. Part C carries 30 marks. Within a part, all problems carry equal marks. The number of marks carried by each question, within a problem, are printed within square brackets, aligned to the right. Electronic calculators are not necessary for this assignment, therefore they should not be used. THIS EXAMINATION PAPER MUST NOT BE REMOVED FROM THE EXAMINATION ROOM.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Part A Attempt one of the following two problems Total marks = 40; both problems carry equal marks. Problem 1 . Total marks: [ 40 ] a) Define an ER model/diagram that describes the data to be stored in a database for a sports competitions organiser, according to the requirements specification provided below. Your final answer should consist of a model that is readily translatable into a relational model; however, if you cannot achieve this requirement, provide the best answer you are capable of. [ 30 ] b) Transform the ER model into a relational model, specifying the primary, alternate (if any) and foreign keys of each resulting relation. [ 10 ] OPTION: You may disregard the last two paragraphs (in italics) of the requirement specification. If you do so, the maximum marks you can achieve are 25 for a) and 7 for b). A company called Sports-Events wants to build a database to store information about the competitions they organise. A part of the data they require is described below. Each competition is described by: a name, a list of regulations (the list may be though as being just one item of data, for no requirement exists to access parts of a certain list of regulations), a deadline, by which all the contenders must register, and an in-house generated id for a convenient identification (unique per competition). Contenders must register for each competition they want to participate in. The date of the registration needs to be recorded. A contender is allowed to register for more than one competition. Each competition has a winner who has to be recorded in the database. A contender is described by: an alias/name (of their choice), an address, a telephone number and gender. Contenders, too, are given an in house generated id for an easier identification. A competition consists of events. Usually, a competition has more than one event. A competition has no events if it has no registered contenders (which is possible). A certain event belongs to a single competition. An event is described by: a level (e.g. “qualifications”, “semi- finals”, “final”, etc.), a number (e.g. number = 2 and level = “semi-finals” means the second semi- final of the competition), a day (when it takes place), a (starting) time and a venue. Contenders
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 05/13/2010 for the course COMPRO CS401 taught by Professor Just during the Spring '10 term at Maharishi.

Page1 / 8

internal-exam - UNIVERSITY OF LONDON Goldsmiths College BSc...

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