key-midterm1-fall2006

key-midterm1-fall2006 - CSCI 485, Midterm I Oct 3, 2006...

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

View Full Document Right Arrow Icon
CSCI 485, Midterm I Oct 3, 2006 (Fall 2006) Prof. Shahram Ghandeharizadeh Warm-up (10 Points) 1. (5 points) Write your name and student-id on your blue book. 2. (5 points) What is the difference between the primary key and the candidate key of a table? Provide an example. Candidate key is a minimal superliey that uniquely identifies either an entity or a relationship, e.g., Social security number, phone number. A primary key is a candidate key that is chosen by the database designer to identify the entities of an entity set or relationships in a relationship set. Magnetic Disk Drives (10 points) 3. (5 points) What does a disk do during a seek operation? Reposition its read/write head from their current cylinder to the destination cylinder. 4. (5 points) How does a Record identifier (RID or TID) uniquely identifies the location of a record on the surface of the disk drive? RID is (Page#, Slot#). The DBMS formats the underlying disk drive as a sequence of disk pages numbered from 1 to n. The Page# refers to one of these disk
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 01/11/2009 for the course CSCI 485 taught by Professor Ghandeharizadeh during the Fall '08 term at USC.

Page1 / 2

key-midterm1-fall2006 - CSCI 485, Midterm I Oct 3, 2006...

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