(3 pts) Which foreign keys would we expect to see in the Cases table?
SELECT ALL THAT APPLY.
H. None of the above
(3 pts) Which foreign key from the above would we expect to see in the Judges table? __
(3 pts) Which foreign key from the above would we expect to see in the Documents table? __
ActiveRecord associations are
to support the query: "Return all the defendants whose cases are
administered by this clerk"?
(Answers have the form "X has many Y", "X belongs to Y", and so on.
Be sure to use the
correct letter choices for each blank!)
(3 pts) Association #1 (pick THREE items): ____
(3 pts) Association #2: (pick FOUR items):
RottenPotatoes has just rolled out a new feature that lets you click on the name of an actor and then shows you all recent
movies starring that actor.
Next to the entry for
you click on George Clooney’s name. Below is a series of
steps in the “life cycle” of what happens as a result of that click. Indicate which part of the overall SaaS system is
responsible for each step:
E___ (1 pt) Determine the IP address corresponding to
F___ (1 pt) Initiate HTTP connection to that IP address on port 80
F___ (1 pt) Determine which cookie(s), if any, correspond to
F___ (1 pt) Send URL of clicked link, and cookie(s) if necessary, to
D___ (1 pt) Convert incoming URL to appropriate method call in Ruby on Rails app
A___ (1 pt) Perform search for all movies containing actor George Clooney
C___ (1 pt) Determine which results will be shown (if there were matches for George Clooney) or whether an error
message will be shown (if there were no matches)
B___ (1 pt) Construct HTML page containing list of movies or the error message
C___ (1 pt) Set flash message if there is an error message
A___ (1 pt) Interface to RDBMS
of the following that imply a project is suitable for Agile development.