logo
 
Homework One
CS 6800 - Advanced Database Management Systems
Utah State University
Home
Calendar
Homework   
Syllabus
Resources
People
Due date: Thursday Jan. 28 at the start of class (1:30PM)
Instructions: Please turn your homework in at the start of class.
Weight: The homework will count approximately 5% of your final grade.

  1. Consider a supplier-parts example database (modified from an example in a book by C. J. Date). The database has three relations, with the schema listed below.
    Supplier (SName, City)
    Part (PName, Color, Weight)
    Shipment (SName, PName, Date)
    Formulate the following queries in the tuple relational calculus and the domain relational calculus.
    1. What are the names of parts shipped by suppliers located in Paris?
    2. What is the name of the part(s) that are shipped by at least two different suppliers?
    3. List the names of suppliers that ship a part which is also shipped by a supplier in Boston (in a different shipment)?
    4. Which suppliers have shipped the same parts on two or more dates?
    5. On which date(s) has exactly two suppliers made a shipment?
    6. What are the names of the suppliers that have shipped all of the parts?
    7. What are the names of the suppliers that have shipped only red parts?
    8. What is the name of the supplier that has made the *latest* shipments?

  2. Exercise 5.7

  3. Exercise 5.11


                                                                                                                                                                                                                                                                                                                                             
  E-mail questions or comments to Curtis.Dyreson at usu dot edu