ct1 - Name: Student number: University of Pretoria C LASS...

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

View Full Document Right Arrow Icon
University of Pretoria CLASS TEST 1: 31 AUGUST 2011 COURSE: Computer Science TIME: 30 minutes MEMORANDUM: COS326 MARKS: 15 EXAMINER: Prof MS Olivier THIS PAPER CONSISTS OF 2 PAGES. Name: Student number: Question 1 The Object-oriented Database System Manifesto lists five criteria for a system to be called a database. Name or describe any four (4) of them. [4] [Persistence, secondary storage management, concurrency, recovery, ad hoc query facility] Question 2 Answer the following wrt Codd’s 1970 paper. a) What is the impact of Access Path Dependence ? (1) [If the data organisation is changed, application programs have to be changed.] b) What is a relation? (1) [A set of tuples R, such that each for each r R , r S 1 × S 2 × ... × S n where each S i is a set.] c) What is a relationship ? (1) [A relation where order of columns does not matter] d) What does Codd call the process of removing nonsimple domains from relations? (1) [Normalisation] [4] 2./. . .
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 COURSE: Computer Science
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course IT 101 taught by Professor Unsure during the Spring '11 term at University of South Africa.

Page1 / 2

ct1 - Name: Student number: University of Pretoria C LASS...

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

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