exam-99-00 - 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 1999/2000 COMPUTING AND INFORMATION SYSTEMS CIS209 Database Systems West Duration : 3 hours Date and time : This paper is divided into three parts: Part A, B and C. All parts are compulsory . Parts consist of problems. Within each part, you are required to attempt fewer problems than the total number provided. Read the instructions for each part carefully . The marking scheme has been made available for you. Part A carries 9 marks. Part B carries 60 marks. Part C carries 30 marks. 1 mark is given for presentation. Within a part, all problems carry equal marks. The number of marks carried by each question within a problem is printed within square brackets, aligned to the right. 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
Part A Attempt three of the following four problems. Total marks = 9; all problems carry equal marks . Problem 1 . Do database systems provide physical program–data independence? Explain why? [3] Problem 2 . Define the concept of “database schema”. Describe the types of schemas that exist in a database complying with the three level ANSI/SPARC architecture. [3] Problem 3 . Define the notion of scalar data value. Give examples. Can the same data type be considered atomic by one designer in one application but non-atomic by another designer in another application (in your explanation, use the data type ADDRESS)? [3] Problem 4 . What is a data dictionary (also called a system catalogue)? Describe some of the information that it can contain. How is this information organised in a relational database? Give an example. [3] CIS209 99/00 West 2
Background image of page 2
Part B Attempt two of the following three problems Total marks = 60; all problems carry equal marks. Problem 1 . Total marks: [30] a) Create a conceptual data model – ER diagram – for the Video Club of Silversmiths College described below. [10] b) If your solution contains multi-valued or composite attributes, many-to-many relationships or relationships with attributes, transform it into an equivalent one that does not contain these aspects. State any further assumptions you make that differ from the ones explicitly made in the text. [10] c) Transform the ER diagram into a relational model, specifying the primary, alternate (if any) and foreign keys. [10] The Information Services of Silversmiths College have decided to create a Video Club for both students and staff. The members of this club will be allowed to either borrow videos for home or watch them using television sets installed in the building. The present database that is in use for the library (for borrowing books) will have to be extended to cover this new video facility. For this, you are required to create an ER diagram. Work as if the old system did not exist, i.e. consider only the present application. The data stored in the database should represent information about the videos and members of the
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 / 8

exam-99-00 - 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