Milestone : Example

• R1(ID, NAME, PHOTO, TYPE)

• select * => select R1.ID, R1.NAME, R1.PHOTO, R1.TYPE

• • • from R1 => from R1
    • where type == “pugs” => R1.TYPE == “pugs”

• PHOTO --> TYPE

• R1 (ID, NAME, PHOTO) and R2 (PHOTO, TYPE)

• select R1.ID, R1.NAME, R1.PHOTO, R2.TYPE

• • • from R1, R2
    • where R1.TYPE == “pugs” AND R1.PHOTO == R2.PHOTO

• add a foreign key constraint to the schema definition