Fall_Final05

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

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

View Full Document Right Arrow Icon
CSE 412/598 Database Management Systems Final Exam Fall 2005 NAME_________________________ASUID____________________ CLASS_____________ [30 pts.] 1. Express the following queries in DRC . employee ( persname , street, city ). works ( persname , cname, salary ). company ( compname , city ). manages ( persname , mgrname ). a) Find all employees who live in the same city and on the same street as their managers. b) Find all employees in the database who do not work for ‘First Bank Corporation’. c) Find all employees who earn more than every employee of ‘Small Bank Corporation’. d) Assume that the companies may be located in several cities. Find all companies located in every city in which ‘Small Bank Corporation’ is located.
Background image of page 1

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

View Full DocumentRight Arrow Icon
[25 pts.] 2. Consider the following relational schema. employee ( empno , name, office, age ). books ( isbn , title, authors, publisher ). loan ( empno , isbn , date ). Write the following queries in
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

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

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

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