mtExamsp03

mtExamsp03 - CSE 412/598 Database Management Systems...

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

View Full Document Right Arrow Icon
CSE 412/598 Database Management Systems Mid-Term Exam Spring 2003 NAME_______________________________ ASU ID: ________________________ [20 pts.] 1. Translate the ER diagram on the following page to a relational schema. Indicate the key of each relation and show all foreign-key-to-primary-key relationships. 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
THE UNIVERSITY DATABASE 2
Background image of page 2
WinRDBI Sun Devil Health Club Relational Database Schema Member ( mID , fName, lName, age, primary, monthlyFee, acctNum ) trainer ( mID, insID, startDate, duration, fee ) Instructor ( insID , ifName, ilName ) Show the major steps involved in the optimization of the following relational algebra query. Draw a separate query tree for each step and provide an explanation of each step. QUERY: Print the first and last names of members under the age of 20 that are training with the instructor name Joe for duration of more than “6” months. project fName, lName (select age < 20 and ifName = "Joe" and duration > 6
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.

Page1 / 7

mtExamsp03 - CSE 412/598 Database Management Systems...

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