CIS 631: DATA MANAGEMENT SYSTEMS DESIGN

ASSIGNMENT 1

Consider the following schema:

SUPPLIERS (SID: integer , SNAME: string, STREET: string, CITY: string, ZIP: string)

PARTS (PID: integer , PNAME: string, COLOR: string)

CATALOG (SID: integer , PID: integer , COST: real)

The primary key attributes are underlined, and the domain of each attribute is listed after the attribute

name. Thus, SID is the primary key for SUPPLIERS, PID is the primary key for PARTS, and SID

and PID together form the primary key for CATALOG. Attribute SID in CATALOG is a foreign key

that refers to the primary key SID of SUPPLIERS and PID in CATALOG is a foreign key that refers

to the primary key PID of PARTS. The CATALOG relation lists the prices charged for parts by

suppliers.

State what the following query computes.

0.

CITY

(

PID

(

COLOR = 'red'

(PARTS)) *

COST>100

(CATALOG) *

SID, CITY

(SUPPLIERS