• Order: OID, Date, Parts, Quantity, Customers;
  
• Customer: OID, Name, Addresses; Part: OID, Locations, Price;
  
• Location: OID, City, State, ZipCode.

It can be transformed into a relational schema

• Order: OID, Date, Part-OID, Quantity, Customer-OID;
• Customer: OID, Name, Location-OID;
• Part: OID, Location-OID, Price;
• Location: OID, City, State, ZipCode.

Consider the following query against the transformed relational schema
Find all orders that are ordered by customers whose addresses are the same as parts' location, and price for each order is less than $100.00

For the above query,

• (a) write SQL based on relational schema,
• (b) draw relational predicate graph,
• (c) draw OODB predicate graph,
• (d) construct OODB Where-clause.