logo
 
Homework 1 - Fun with the Relational Model
CS 5800 - Database Systems
Utah State University
Home
Calendar
Homework   
Lectures
Syllabus
Resources
People

Overview

Due Date Thursday, Sep 28 at the start of class (1:30PM), late turnins will have 20% per day deducted.
  1. Consider the following three relations, with the schema listed below. Primay keys are underlined.
    Supplier (Name, City)
    Part (Name, Color, Weight)
    Shipment (SupplierName, PartName)

    Shipment(SupplierName) is a foreign key on Supplier(Name)
    Shipment(PartName) is a foreign key on Part(Name)

    Formulate the following queries in relational algebra.

    1. What are the names of suppliers?
    2. What are the names of suppliers located in Paris?
    3. What parts are red and weigh more than 40?
      1. using selection only -
      2. using intersection and selection -
    4. From which cities are red parts shipped?
    5. What are the names of suppliers that ship a part?
    6. What are the names of suppliers that do not ship a part?
    7. What are the names of suppliers that ship at least two different parts?
    8. What are the names of suppliers that ship exactly one part?
    9. What are the names of suppliers that ship all of the parts?
  2. Exercise 3.21
  3. Exercise 3.25
  4. Exercise 3.27
  5. Exercise 3.28

                                                                                                                                                                                                                                                                                                                                             
  Copyright © 2017 by Curtis Dyreson. All rights reserved.