internal-02 - 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 2002 COMPUTING AND INFORMATION SYSTEMS IS52003A (CIS209) Database Systems Internal Duration : 3 hours This paper consists of 5 problems. Each problem carries 25 marks. Answer only 4 of them. You may choose any 4 problems; full marks will be awarded for complete answers to 4 problems. Problems are made of questions. For each problem you choose, attempt all its questions. The mark carried by each question is printed within square brackets. Gauge the length of each answer by the number of marks awarded. 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. CIS209 – IS52003A 2002 Internal 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
PROBLEM 1 [25] Topics covered: generalities about databases ; generalities about the relational model. Question 1 Define the relational model. What is a relational database management system (DBMS)? [3] Question 2 Define the notion of “foreign key”. Give an example. [3] Question 3 Explain the two types of program–data independence on the basis of the three level ANSI/SPARC architecture of a database system. [4] Question 4 What is a system catalogue? Give examples of two types of data/information it usually includes and, in each case, explain the (potential) use of this data/information (one or two sentences per type of data/information). [5] Question 5 Data can be stored in files and application programs can share this data by having a direct access to the respective files (refer to Diagram 1, below). However, data-centred applications normally employ a database management system (refer to Diagram 2, below). State why the latter approach (Diagram 2) is preferred for data-centred applications (refer to at least two features of a DBMS). [5] Question 6 Explain what is it meant by impedance mismatch, in the context of relational database systems. [5] CIS209 – IS52003A 2002 Internal 2 data as files (disk) Program/Application 1 Program/Application n data as files (disk) Program/Application 1 Program/Application n Diagram 1 Diagram 2 TURN OVER Database Management System
Background image of page 2
PROBLEM 2 [25] Topics covered: conceptual design / ER modelling ; the transformation of an ER model into a relational model. Question 1
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.

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 / 6

internal-02 - 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