Interview Question

Interview San Mateo, CA

Design a database for a vendor (including products

  , purchase orders, etc.) and then write a query to select the names of all products that need to be shipped today. (I can't remember the exact question, but it was something along these lines.)

Interview Answer

1 Answer


Determine the relationships between objects (and what fields each object should and must contain), draw an E.R. diagram, and then write a query of medium-level difficulty (involving at least a join, possibly also an aggregate function) on this database.

Interview Candidate on May 13, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.