This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Note : Assume that the phone number attribute is unique for each record in your model. 4. Figure out the problem description and ERD representation for a certain database whose relational model schema is provided below. PERSON PersonID Name Address BirthDate PICTURE PictureID Date Location SNAPSHOT PersonID PictureID 5. Slide 40 of this lecture lists some queries than can be performed on the Student Registration Database. Describe in English the sequence of steps and what files and records you would access to answer these queries. See slide 20 for an example. a. Which courses does a specific professor teach? b. What courses are taught by two specific professors? c. Who teaches a specific course and where is his/her office? d. For a specific student number, in which courses is the student registered and what is his/her name? e. Who are the professors for a specific student? f. Who are the students registered in a specific course?...
View Full Document
This note was uploaded on 09/01/2010 for the course COMPUTER S CSI1306 taught by Professor Aziri during the Spring '10 term at University of Ottawa.
- Spring '10
- Relational Database