exam-98-99 - UNIVERSITY OF LONDON Goldsmiths College BSc...

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

View Full Document Right Arrow Icon
UNIVERSITY OF LONDON Goldsmiths College BSc Examination 1998/1999 COMPUTING AND INFORMATION SYSTEMS CIS209 Database Systems Duration : 3 hours Date and time : This paper is divided into five parts, from Part A to Part E. All parts are compulsory. However, read the instructions for each part, carefully, because you are advised to attempt less questions than provided. If you choose not to follow these instructions and attempt more questions than advised, you might not be able to finish your paper because of lack of time. You do not need to use electronic calculators for this assignment, therefore they are not allowed. 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
CIS209 Databases - Exam paper 1998/1999 Part A Attempt four of the following six problems (estimated time 20 minutes) Problem 1 . Explain briefly, in one or two sentences, three advantages of your choice, of the database approach to software systems development. Problem 2 . Describe the three levels of the ANSI / SPARC architecture of a DBMS. Problem 3 . Define and point out the difference between the intension and the extension of a database (illustrate with an example). Problem 4 . Explain, based on a diagrammatic representation, two possible architectures for database systems. Problem 5 . Define the optimiser in the context of a relational DBMS? Problem 6 . Are foreign keys allowed to have null values? Explain why via an example. 2
Background image of page 2
CIS209 Databases - Exam paper 1998/1999 Part B Attempt two of the following three problems (estimated time 1 hour) Problem 1 . Model the following real life system, with a view to developing a database, by means of an entity relationship (E/R) diagram. The Department of Computing and Mathematical Sciences of Silversmiths College has a set of courses provided for the undergraduate level. For each course a well defined set of admission criteria is specified; for instance, for the "Computer Science" course, 3 A-levels are required, minimum B for each, an A level in Mathematics being compulsory. Each course has a name and a duration; certain courses can allow industrial placements. Each course consists of a set of modules, some compulsory and some optional. A certain module is described by its name, a short syllabus, type (lectured, seminar-like, project) and year of study for which it was intended. Each student enrolled with the department, is registered for one particular course. The student must attend the compulsory modules. For every year of study, from the set of optional modules, the student must attend a certain number
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

exam-98-99 - UNIVERSITY OF LONDON Goldsmiths College BSc...

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

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